It's all about the answers!

Ask a question

Any way to get a count of number of times a work item has been reopened/state changed

Corey Jacobs (642539) | asked Jun 11 '14, 7:40 p.m.
Hi, I'm working on a report in Rational Insight Query Studio to gather the defects have been reopened.  I was looking for a way to figure out the number of times this work item has been reopened and has had its state changed in RTC.  Was there a way to report on this?  I was looking at the Operational Data Store > Request Area and wondered if one of these tables stored this information. 

Accepted answer

permanent link
Jackie Albert (1.6k14947) | answered Jul 22 '14, 4:03 p.m.

Yes, look at Request Area -> Request State History.

This has a record of each state change, the old state, new state, and the date it changed.  You should be able to do a count on a specific combination if needed.

Corey Jacobs selected this answer as the correct answer

Corey Jacobs commented Jul 28 '14, 12:45 p.m.

Thanks Jackie.  Will look at this approach.

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.