Is it possible to fetch history of workitem having PREVIOUS_REQUEST_RESOLUTION in JRS 603?
4 answers
Hi,
The short answer is 'yes, probably' but the details matter. What kind of history are you after? State changes, that kind of thing? You say resolution, so are you specifically referring to something like a Defect that not only has a state but also a resolution like duplicate? I would be happy to cook up an example if you can specifically tell me what you want.
Amy
Comments
Thku Amy for response,
Actually condition is when the status repoens from Closed->open ,
the resolution changes from released(resolved) to Reopened
Now in report i want count of the workitems where status moved from "closed to "open" and with a condition Where resolution has moved to" reopened" only from "released".
Formula its like this below:
D = number of issues with transition
“Re-Open” from status “Closed” status where only moved only from(Resolution = Released(resolved) to status.
IS it possible to fetch the previous resoluttion to put the condition moved only from released?
Actually yes the defect has both state and resolution so we need to fetch the resolution history only wen resolution has moved from "released(resolvedl) " To reopened" along with state moving closed to open.
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)
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)
Comments
Thku so much Amy for your detail response, I am using Jrs 603.. AND I was trying to fetch the report using Historical trends using data warehouse house with traceability relationship work items state history,Unfortunately I was not able to fetch the data of previous resolution resolution is resolvedor released.. Thku would like to reach you on email incase of further query,il try your solution and get back to you.