It's all about the answers!

Ask a question

Automatically record a date when state transitions


varun poshala (11) | asked May 28 '18, 8:53 a.m.

  

I would like to some how record the timestamp of when a work item moves from one particular state to other. This is actually to track cycle time, and we know that it logs it down in the history but we need populate the those dates in the custom attributes for metrics

2 answers



permanent link
Ralph Schoon (56.8k23642) | answered May 29 '18, 3:55 a.m.
FORUM ADMINISTRATOR / FORUM MODERATOR / JAZZ DEVELOPER
edited May 29 '18, 3:55 a.m.

I don't think this is advisable for many reasons, one being that maintaining the workflow stated becomes tied to your customization. This should be provided and stored in the data warehouse if at all possible.
Another approach is https://github.com/jazz-community/rtc-statushistory-presentation which gets the information out of the history. You could also run some automated tool that calculates the information (e.g. nightly) and stores it in another database.

Finally:

There is no good way to implement something like this using the JavaScript attribute customization API, because detecting the state change is so hard. You could use a follow up action on work item save. This has still issues because the artificial second save can collide with the user UI activities. You have been warned.


Here examples how to update work items in the server API

https://rsjazz.wordpress.com/2012/11/27/resolve-parent-if-all-children-are-resolved-participant/
https://rsjazz.wordpress.com/2012/07/31/rtc-update-parent-duration-estimation-and-effort-participant/





permanent link
Matt Muller (54812052) | answered May 29 '18, 4:55 a.m.

Hi Varun,

Have you investigated the reporting options in JRS?  You may wish to review : https://jazz.net/library/article/1540

Introducing Historical Trend Reporting in Jazz Reporting Service Report Builder 6.0.1

Scroll to

Appendix

Change and Configuration Trend Details

Your answer


Register or to post your answer.