How to filter date in IBM RPE

meghana kaddu (21●4) | 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.6k●1●4) | 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.

It's all about the answers!

Related questions

How to filter date in IBM RPE

Accepted answer

Your answer