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

0	Rima Kumari (17●6) \| 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

Most liked answers ↑|Newest answers|Oldest answers

permanent link

Subramanya Prasad Pilar (4.6k●1●4) | 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.

rtc.dta

Please find the attached link for rtc.dta file

showing 5 of 6 show 1 more comments

It's all about the answers!

Related questions

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

One answer

Your answer