Reporting based on History
I am researching the possibility of queries based on History. For example:
Show all work items where...
Planned For has changed from the current iteration to something else.
Owned By has changed from a certain user to anyone else.
Specific changes were made by a specific user.
From my web searching, History data is not in the data warehouse and not exposed through the API. Is that still correct or is that old info? If that is correct, then web-scraping may be the only way to retrieve results based on History. Has anyone succeeded in using web-scraping for reporting?
Show all work items where...
Planned For has changed from the current iteration to something else.
Owned By has changed from a certain user to anyone else.
Specific changes were made by a specific user.
From my web searching, History data is not in the data warehouse and not exposed through the API. Is that still correct or is that old info? If that is correct, then web-scraping may be the only way to retrieve results based on History. Has anyone succeeded in using web-scraping for reporting?
One answer
Hi Mike,
Here is the data warehouse schema: https://jazz.net/wiki/bin/view/Main/DataWarehouseSnapshotSchemas20
Please scroll down to the "Workitem_Chngs" table and see if it meets your need.
Hope it helps. Thanks.
Comments
Geoffrey Clemm
FORUM ADMINISTRATOR / FORUM MODERATOR / JAZZ DEVELOPER Jun 17 '13, 3:52 p.m.Historical data is available in the data warehouse (trending reports is one of the primary purposes of the data warehouse, and that requires historical data). So you'll want to be looking there. I'm making this a comment rather than an answer, since I don't have the details on the particular reports that you are looking for.
Mike Shkolnik
Jun 17 '13, 4:26 p.m.Is it the trend data that is stored in the DW or the actual historical data? This post led me to believe the detailed historical data is not available in the DW or the API:
https://jazz.net/forum/questions/85795/is-it-possible-with-rrdi-or-insight-to-report-on-the-history-of-the-latest-result-for-a-ter-in-rqm
Geoffrey Clemm
FORUM ADMINISTRATOR / FORUM MODERATOR / JAZZ DEVELOPER Jun 17 '13, 4:46 p.m.I've added a comment to that post clarifying that historical data is available in the DW.