Defect Lifecycle Reporting
CLM 6.0.1
Using CLM queries or the Jazz report builder is there any way to report how many times a Defect had been set to a particular Workflow Status. For Example How many times it has been set to "Sent for restest".
I'm looking to report how many attempts it took to get a defect properly resolved.
Thanks
Using CLM queries or the Jazz report builder is there any way to report how many times a Defect had been set to a particular Workflow Status. For Example How many times it has been set to "Sent for restest".
I'm looking to report how many attempts it took to get a defect properly resolved.
Thanks
Accepted answer
You can build a report via Report Builder using the 'Work Item State History' under the 'Current Data' report type to see a listing of state transitions, but I don't think there's a way via the report builder UI to calculate the count. You may be able to take the SQL generated by this report and customize it though. I haven't tried that part, but here's what I was able to build that might get you started.
Here's a quick example of a list view, with the top item being an example of one that went through the Working -> Verify state transition multiple times. In this example I used the traceability linking to get the WI ID and URL, and sorted by those fields to get the grouping you see in my screenshot.
Here's a quick example of a list view, with the top item being an example of one that went through the Working -> Verify state transition multiple times. In this example I used the traceability linking to get the WI ID and URL, and sorted by those fields to get the grouping you see in my screenshot.
