How to get work item status history using LQE in JRS
Accepted answer
Hi Amruta,
Currently LQE does not include the full WI history. It does include dates for Created, Closed (as defined by the WI workflow), Last Update. Depending on your WI workflow, the Closed value might correspond to your completion. You could create an attribute for the inprogress date and set it manually when you transition the state. Not sure, but you might be able to extend RTC to set the date automatically on save. That date attribute would then be reportable in LQE. That is for Current Data reports only, not Historical Trends.
Alternatively, the data warehouse does include the WI history including status history.
One other answer
Thank you Kathryn. I like to knw is it possible to get history data using SPARQL query ??
Comments
It depends what you mean by "history data". LQE contains some historical data to support the trend reporting in Report Builder (open/closed/created). The reports use SPARQL to extract that data; you can see the generated queries in Report Builder's Advanced section of Report Builder. LQE does not include the complete WI history, so that would not be available.
If you have access to LQE Admin, you could use the query facility to explore the data in LQE (e.g. select a small # of WIs and look at all the associated attributes). You can use RB to generate an initial query and then modify it. Be mindful of query performance, especially on production systems.