Hi,
While I'm waiting for you to answer about the version of JRS you're using, let me just tell you how you would do this in 6.0.3 or later. I just can't remember which version the History information was added into the Report Builder UI. My guess is that the metadata is available in the Data Warehouse in earlier versions in any case, so I could share the Advanced SQL with you if you are not able to build this report yourself. I can also export the report example I've created and you can import it into your environment.
In the Report Builder UI, build your report like this (I'm assuming a default Defect workflow):
-
Choose a report type: Current Data (table or graph)
-
Limit the scope Your choice
-
Choose an artifact: Work Item History > Defect
-
Trace relationships and add artifacts: Work Item History > Work Item History Previous Work Item History
-
Conditions:
-
Work Item History: Type = Defect (should be set automatically by #3 above)
-
Work Item History: Status = New (depends on your workflow)
-
Previous Work Item History: Status = Done (depends on your workflow)
-
Previous Work Item History: Resolution = Fixed (depends on your workflow)
The formatting is up to you. Hope that helps.
Please don't hesitate to reach out to me through email if you'd like me to share the report or the SQL.
Amy (asilber@us.ibm.com)