It's all about the answers!

Ask a question
QuestionsTagsUsersBadges
Follow this question
Question details

×42,787
×1,500
×1,036
×406

question asked: Aug 11 '20, 12:25 a.m.
question was seen: 1,139 times
last updated: Aug 12 '20, 5:04 a.m.

Related questions

FAQ - How this Forum works

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

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

0
permanent link
Subramanya Prasad Pilar (4.6k●1●6) | 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.


Dashboards and work items are no longer publicly available, so some links may be invalid. We now provide similar information through other means. Learn more here.