How can we get Modified Date of any workitem with respect to state change in RPE
One answer
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
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
Can you try using RPE filter (scripted filter) or condition?
yes i tried with both RPE filter (scripted filter) or condition but still error is coming.
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.
Can you attach the rtc.dta?
Please find the attached link for rtc.dta file
showing 5 of 6
show 1 more comments