How can we extract the Defect work item history from RTC without any additional tools
Hello, We have a requirement in the project to be able to extract the defect work item history which can be used for calculating the Aging of the defect with a particular team. HP QC / ALM provides a facility to query the history of test plan and test lab and also at the test case level. Similarly is there a way to use history in RTC for various update purposes
Can this be done by deploying newly introduced Jazz Reporting Services. If yes is all features of it has been enabled in 5.0.1 ? since some aritcle is saying it introduced in 5.0 but all futures are supported in 5.0.2. And do we need a separate license for this component additionally. Kindly let us know your inputs ....! Thanks & Regards Ashwath |
2 answers
Hello,
A question before I propose some possible workflows using the JRS Report Builder -->
Why do you think you need to query on the work item history for the aging characteristics? If you're interested in age since creation, the Work Item stores a Creation Date attribute that indicates the date created. In addition, there is a Resolution Date attribute indicating the date of resolution. So it would help to know specifically what kind of aging characteristic you're trying to measure?
The Jazz Reporting Service was introduced in 5.0 and has progressively added more functionality in each subsequent release. We started out with a series of Out of the box reports in 5.0. In 5.0.1 we provided some basic self service report creation. In 5.0.2 we introduced traceability reports and our latest release 6.0 now has the capability to aggregate and calculate values (count all values etc.). It's possible this new aggregation functionality in 6.0 could be used as a starting point to count all work items that meet a certain aging characteristic to be displayed in a graph or a table.
In 5.0.2 this is not available, but we did provide an advanced SQL mode where the raw data query can be created in SQL and then pasted into report editor. This is probably the only avenue for the 5.0.2 release.
Best Regards,
-Steve
|
Hello Ashwath,
|
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.
Comments
Thanks Steven.
There is a way to extract the work item history using the JRS Report Builder. First you would select Work Item History as the artifact, then add a condition on the particular work item ID and add the columns you want to display (including Last Update Time and the Work Item Category). Then you would be able to see the paticular changes that occurred and when they occurred.
Hello Steven,
Thanks for the inputs....we will explore the solution to build the reports.
And is there any article or documentation available explaining the report designing and execution using JRS.
Thank You....!