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!
Thanks in Advance ... |
3 answers
![]()
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.
|
![]()
Ok thanks for the reply..But is there any workaround to full filly request.
|
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.