How to query out Coutinious Request History
I need to find a way to show all the Request History Day by Day. What I can get now from Data Warehouse is a the history table which records the changes. However, I can't find a table recording the status for each Request in the past days.
Could anyone please help? The package I'm referring to is Data Warehouse/Operational Data Store/Request Area. I can provide any detail if I'm not stating clear in my question. Thanks in advance. |
Accepted answer
Hello Zhaolong,
Request History only stores the changes, like you correctly noticed, not the daily status of the work items. If you need that kind of information you will need to built it yourself in a report, for example by comparing the daily date with the date of the request history entry and pick the matching one, however this might not be trivial to accomplish. Another option is to use the request metrics, the advantage is that you get an entry for each day, the disadvantage is that the data is aggregated meaning that you cannot see the status of a single request but you will get totals for all the requests sharing the same dimensions; also not all the request fields are available in the metrics. You can find more information on metrics in this article: Improve the value of your CLM reports by using metrics http://www.ibm.com/developerworks/rational/library/improve-value-clm-reports-metrics/index.html Best Regards, Francesco Chiossi Zhaolong Li selected this answer as the correct answer
Comments Hi Francesco,
Hello Zhaolong,
|
One other answer
Instead of Request History, have you looked at Request State History?
Comments I did. It only stores Request State History change record. I can't come up with a idea to get those pieces together
Ralph Schoon
commented Aug 07 '14, 10:02 a.m.
FORUM ADMINISTRATOR / FORUM MODERATOR / JAZZ DEVELOPER
The data is in RTC, at least the one that can be seen on the history of RTC work items. It would be possible to traverse all the historical states of a work item for example using the API. Not sure about REST/OSLC. Not sure how much load that would add, if you ran some tool over night.
|
Comments
I would try to provide more information on what you try to do with which product and what you want to show. I think this is about reporting and the history of work item (workflow states).
I am not a data warehouse/reporting expert, however a data warehouse typically does some kind of data compression and does not store all the history of all data.
Thank you Ralph for the clarification and your warm heart as always.