how to fetch the work item history through Query
We have CLM version 4.0.3, hosted on our project servers. We wanted to know the DB table names, which store the History details of each of the work items. Could you please help us in retrieving the History of the work items based on the work item ID. Thanks!
Is it possible to fetch the all work items history thourgh queries? Please help on this.
Thanks in Advance ...
3 answers
Directly access to the backend database is not a good idea. I suggest you use the reportable REST API. The property "itemHistory" contains the work item history entries.
https://jazz.net/wiki/bin/view/Main/ReportsRESTAPI
https://jazz.net/wiki/bin/view/Main/ReportsRESTAPI
Comments
Hi Donald,
Thanks for reply. I have gone through the link but i am unable to find exact query for my requirement and how to execute it.
It's not about the "query". You need to learn how to use XPath to select and/or filter fields. See the examples at the bottom of the Wiki page to get an idea.
Per my discussion with IBM developer Rafik Jaouani (excellent resource on CCM reporting and DW reporting questions). I will summarize my understanding of my conversation with Rafik. He stated that you use ReportableRESTAPI to query on "some history" in CCM DB but the drawback is that filtering is very limited and you cannot do direct SQL queries against CCM DB because the data is stored in XML format. The solution for querying against history would be to use the DW (datawarehouse) DB which you can then use JRS or direct SQL queries.