Possible to create a calculated attribute displaying the number of days a work item has been in its current state ?
I need to create a work item custom field which would display the number of days the work item has been in its present state.
e.g. when a Defect is in New state, the field would display the number of days it has been in this New state, then when the Defect moves to InProgress state, the field would display for how many days it has been in this InProgress state.
Is this possible ? If Y, any hint welcome.
Thanks
One answer
The data in RTC is static until you update it in some way, i.e., opening a WI will not show you a different value in the field you are talking about without some automation.
You can capture the date/time you enter a state easy enough using scripting, and then either use the dashboard, or some other reporting mechanism to determine how long you have been in that state.
Alternatively, if you have Insight, I believe you can report on the sort of thing your talking about.
Comments
sam detweiler
Jun 27 '14, 9:28 a.m.you would have to write a java participant extension to accomplish this. the javascript calculated value service doesn't give u the ability to see state changes, or state history.
see the extensions workshop https://jazz.net/library/article/1000