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

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

Questions
Tags
Users
Badges
Corey Jacobs
(64●25●39) 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. 

0 votes

1 answer
4,474 views
0 votes

Accepted answer

Permanent link
Jackie Albert
(1.6k●1●49●47) 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

0 votes

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

Thanks Jackie.  Will look at this approach.

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
× 12,031

Question asked: Jun 11 '14, 7:40 p.m.

Question was seen: 4,474 times

Last updated: Jul 28 '14, 12:45 p.m.

Confirmation Cancel Confirm