It's all about the answers!

Ask a question

How to filter date in IBM RPE


meghana kaddu (192) | asked 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

 

Accepted answer


permanent link
Subramanya Prasad Pilar (4.5k14) | answered Apr 27 '21, 5:59 a.m.
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

Comments
meghana kaddu commented Apr 27 '21, 6:12 a.m. | edited 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 commented 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 to post your answer.