Jazz Forum Welcome to the Jazz Community Forum Connect and collaborate with IBM Engineering experts and users

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

Questions
Tags
Users
Badges
Rima Kumari
(17●1●1●8) 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.)??

0 votes

1 answer
3,345 views
0 votes

One answer

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

0 votes

Comments
Rima Kumari
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
Aug 11 '20, 9:07 a.m.
Can you try using RPE filter (scripted filter) or condition?

Rima Kumari
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
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
Aug 12 '20, 3:26 a.m.
Can you attach the rtc.dta?

Rima Kumari
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

Your answer

Register or log in 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.

Ask a question
Guidelines
FAQ
Search context
Follow this question

By Email: 

Once you sign in you will be able to subscribe for any updates here.

By RSS:

Answers
Answers and Comments
Question details

Question asked: Aug 11 '20, 12:25 a.m.

Question was seen: 3,345 times

Last updated: Aug 12 '20, 5:04 a.m.

Confirmation Cancel Confirm