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

Calculating aging of workitem states in JRS

Questions
Tags
Users
Badges
hani zaidi
(11●2●5) Sep 22 '16, 6:00 a.m.
Is aging on different states of workitem possible by custom reporting in JRS?

I've to create a report on Percentage of duration over the stages in comparison with the overall release duration or Effort distribution pf SDLC phases (BD + DD/DS+ QA) based on the following formula:
Duration for of particular  phase during a release-Duration of the release/Duration of the release  * 100

I am using CLM V6.0.2 with SQL DB and custom reporting is enabled in jrs.

The underlined assumption is that phases represent states and we have to calculate total time period of CR in individual states over the total time period from creation to deployment. 

Any help from GUI or custom SQL query will be appreciated

P.S Using historical data we are bound to give a time range which is not required in this calculation.

Thanks!

0 votes

2 answers
3,982 views
0 votes

2 answers

Permanent link
Jackie Albert
(1.6k●1●49●47) Sep 22 '16, 9:22 a.m.
I'm only on CLM 6.0.1,  but if you check in the "Work Item State History" instead of "Work Item" under Current Data reports,  it has a 'Days in State' option.  This may help you generate what you're looking for. 

0 votes

Permanent link
hani zaidi
(74●8●22) edited
Sep 22 '16, 12:00 p.m.
 Hi Jackie,

Thanks for you response, I've few queries related to work item state history. Is it possible to get work item type as attribute using this artifact? 

And I tried using this artifact but every time I get '0' value against Days in State. Do you know what could be the possible reason behind this? I did changes in states of different work items and ran the dcc job again to confirm and still getting the same value for 'days in state'

Thanks!

0 votes

Comments
Jackie Albert
Sep 22 '16, 12:08 p.m.

If you use the Traceability links from "Work Item State History" you can link to the related "Work Item" and get the Type or any other attribute value.  Keep in mind this is only the current value, not any of the historical values it might have contained at the point in time it was in that state  (For that check out the full "Work Item History").

I'm not sure why your values are always '0' - I definitely get more detailed data in mine matching what I would expect.  Hopefully someone from the development or support teams can give some assistance there. 

hani zaidi
Sep 22 '16, 12:52 p.m.

 Thanks Jackie!

"Keep in mind this is only the current value, not any of the historical values it might have contained at the point in time it was in that state  (For that check out the full "Work Item History"). " 


That was needed for confirmation. I've checked work item history but in that type of report we have to specify a time range. I think I need some sort of customization to log start and end date on each state change. If you come up with any other workaround please do share. Thankyou again for your help. 

Jackie Albert
Sep 22 '16, 1:45 p.m.

Keep in mind, I'm not talking about the data in Historical Trends, but the 'Work Item History' that's listed under "Current Data" type reports.  This screenshot is from 6.0.1, so maybe it's moved in 6.0.2 (I know it moves to a new spot in 6.0.3)  but this is the section I'm referring to.  Both 'Work Item History' and 'Work Item State' history are available with full workitem change details - this is not a snapshot with metrics like you get in the Historical Trends.



hani zaidi
Sep 23 '16, 10:11 a.m.

 Hi jackie Thanks again. I've checked Work Item History, Work Item State History and Historical Trends. All I can get is last/previous state and action. I want a report where I can get duration against each state of a single work item or collection for say:


Column 1: State (Open,closed,in progress)
Column 2: Sum of timespent by all workitems in the following state

So far I am unable to find a direct solution to this. Please guide me if there is a possible solution? I am ready to work with sql custom queries

Thanks again.

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
× 7,495
× 1,220
× 481
× 360
× 28

Question asked: Sep 22 '16, 6:00 a.m.

Question was seen: 3,982 times

Last updated: Sep 23 '16, 10:11 a.m.

Confirmation Cancel Confirm