It's all about the answers!

Ask a question

How to get workitems, which had the "new" state more than once


Georg Kellner (825375103) | asked Nov 29 '18, 10:53 a.m.
We have a project where lots of stories seems to pass the workflow at least two times, so
New - Open - Done - New - Open -Done

Is there an easy way to find those workitems?
We have RTC 6.0.5, ReportBuilder in combination with LQE and DCC in version 6.0.3,

greetings georg.

2 answers



permanent link
Guido Schneider (3.4k1384111) | answered Dec 02 '18, 3:48 p.m.

Hello Georg,


In report Builder you can create a report with traceability of "Work Item History" linked to the "Work Item History Work Item".
Then you can set a condition on current state off the "Work Item History Work Item" and the previous state on "Work Item History"

e.g. give me all WI where actual state is New and previous state was Done.

regards
Guido

(p.s. you can ping me tomorrow if you like)


permanent link
Subramanya Prasad Pilar (4.5k14) | answered Dec 02 '18, 1:32 p.m.

Since you can get state along with itemHistory information via reportable REST URL for WorkItem, you should be able to get this through RPE. Not sure about other options.

Your answer


Register or to post your answer.