It's all about the answers!

Ask a question

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

Georg Kellner (840479109) | 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
Subramanya Prasad Pilar (4.6k16) | 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.

permanent link
Guido Schneider (3.4k1491115) | 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.


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

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.