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.
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
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
Comments
One other answer
Instead of Request History, have you looked at Request State History?
Comments
Comments
Ralph Schoon
FORUM ADMINISTRATOR / FORUM MODERATOR / JAZZ DEVELOPER Aug 07 '14, 3:43 a.m.Zhaolong Li
Aug 07 '14, 9:34 a.m.