It's all about the answers!

Ask a question

Report in rational insight based on workitem history data


Suyash adsul (91218) | asked Feb 25 '15, 11:37 a.m.
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

Accepted answer


permanent link
Jackie Albert (1.6k14947) | answered Feb 25 '15, 3:50 p.m.
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
Suyash adsul selected this answer as the correct answer

Your answer


Register or 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.