Jazz Forum Welcome to the Jazz Community Forum Connect and collaborate with IBM Engineering experts and users

How to filter date in IBM RPE

Questions
Tags
Users
Badges
meghana kaddu
(21●10) Apr 27 '21, 4:06 a.m.

 Hi,


 I am using RPE 6.0.6. I have custom timestamp attribute called submitted date.

I want filter this date with set of time range.( For ex from 1-4-21 to 30-4-21)

Please let me know if any such mechanism is available in IBM RPE.

Thanks and Regards,
Meghana

 

0 votes

1 answer
772 views
0 votes

Accepted answer

Permanent link
Subramanya Prasad Pilar
(4.6k●1●6) edited
Apr 27 '21, 7:29 a.m.
Hi Meghana,

You should be able to use Scripted Filter in RPE for this. Try with using Greater than and Less than operators. If that does not work, you can get date, month and year from submitted date and check if it is within your date range. The javascript code should return true or false.
meghana kaddu selected this answer as the correct answer

0 votes

Comments
meghana kaddu
Apr 27 '21, 6:13 a.m.

Hi Subramanya,


Thank you for the response. 

The submitted date is custom attribute in IBM RTC work item. I used allextension query with filter displayname=="submitted date". 

Should I append to this?

Thanks and Regards,
Meghana

Subramanya Prasad Pilar
Apr 27 '21, 7:32 a.m.

You can add a special attribute and try - right click on workitem/workItem node in Data Source View and select Add Special Attribute... You can then use the special attribute in Scripted Filter.

Your answer

Register or log in to post your answer.

Dashboards and work items are no longer publicly available, so some links may be invalid. We now provide similar information through other means. Learn more here.

Ask a question
Guidelines
FAQ
Search context
Follow this question

By Email: 

Once you sign in you will be able to subscribe for any updates here.

By RSS:

Answers
Answers and Comments
Question details
× 12,033

Question asked: Apr 27 '21, 4:06 a.m.

Question was seen: 772 times

Last updated: Apr 27 '21, 7:32 a.m.

Confirmation Cancel Confirm