It's all about the answers!

Ask a question

How can we get Modified Date of any workitem with respect to state change in RPE


Rima Kumari (175) | asked Aug 11 '20, 12:25 a.m.

Hi,

How can we get Modified Date of any workitem with respect to state change (From New to In- progress etc.)??

One answer



permanent link
Subramanya Prasad Pilar (4.5k14) | answered Aug 11 '20, 5:43 a.m.

workitem/workItem/itemHistory/modified will give modified date for each history. You need to check for state (workitem/workItem/itemHistory/state/name) to find state change and print the corresponding modified date.


Comments
Rima Kumari commented Aug 11 '20, 7:50 a.m. | edited Aug 11 '20, 7:51 a.m.

I applied native filter(_value=="In Progress") in (workitem/workItem/itemHistory/state/name)after that i am printing modified date from this query(workitem/workItem/itemHistory/modified) but error is coming


Subramanya Prasad Pilar commented Aug 11 '20, 9:07 a.m.

Can you try using RPE filter (scripted filter) or condition?


Rima Kumari commented Aug 12 '20, 12:48 a.m.
yes i tried with both RPE filter (scripted filter) or condition but still error is coming.

Rima Kumari commented Aug 12 '20, 1:11 a.m.
Please find the given below details of error

CRRPE3096E Output processing could not continue due to an error.

The maximum length of cell contents (text) is 32,767 characters
[Error context] Template is C:\Users\rkmt329\Desktop\RPE\rtc.dta
[Error context] Template element is 12
CRRPE1064I Error in engine

Invalid output state.


Subramanya Prasad Pilar commented Aug 12 '20, 3:26 a.m.

Can you attach the rtc.dta?


Rima Kumari commented Aug 12 '20, 5:04 a.m.
Please find the attached link for rtc.dta file
showing 5 of 6 show 1 more comments

Your answer


Register or to post your answer.