Report in rational insight based on workitem history data
HI,
I am researching the possibility of report based on History. For example:
We want to have report which includes modified date and time on my particular workitem change only.
Suppose in workitem i have changed state from one state to another at Jan 28, 2015 1:55:42 PM and later on we did changes on workitem so its modified date and also changed suppose to Feb 12, 2015 6:47:12 PM.
we are looking for report which will show us the last modified date and time only on my state change i.e. Jan 28, 2015 1:55:42 PM.
could you please assist how this can be achieved.
Thanks and regards,
Suyash
I am researching the possibility of report based on History. For example:
We want to have report which includes modified date and time on my particular workitem change only.
Suppose in workitem i have changed state from one state to another at Jan 28, 2015 1:55:42 PM and later on we did changes on workitem so its modified date and also changed suppose to Feb 12, 2015 6:47:12 PM.
we are looking for report which will show us the last modified date and time only on my state change i.e. Jan 28, 2015 1:55:42 PM.
could you please assist how this can be achieved.
Thanks and regards,
Suyash
Accepted answer
Hi Suyash,
Under the Request Area folder of the Operational Data Store in Query Studio or Report studio, you should find a section called "Request History" that will contain the workitem changes for any change you make. Alternately there is a "Request State History" which will capture state changes. Between these two, it should help you generate the report you want.
Thanks,
Jackie
Under the Request Area folder of the Operational Data Store in Query Studio or Report studio, you should find a section called "Request History" that will contain the workitem changes for any change you make. Alternately there is a "Request State History" which will capture state changes. Between these two, it should help you generate the report you want.
Thanks,
Jackie