It's all about the answers!

Ask a question

Historical data in BIRT for items' states


Zachary K (19354339) | asked Mar 26 '13, 10:07 a.m.
 Hello,
What is the more efficient way to query historical data for items state? For instance I'd like to report on items states from last week versus this week.
Is the table WORKITEMS_CHNGS the way to go?
Thanks in advance for your help.

Accepted answer


permanent link
Lily Wang (4.9k714) | answered Mar 26 '13, 6:42 p.m.
Hi Z K,
The information you are looking for is in table WORKITEM_CHNGS stored in the WORKITEMS_SNAPSHOT.
You can find the detail description of the table from https://jazz.net/wiki/bin/view/Main/DataWarehouseSnapshotSchemas20.

The last comments of the forum topic https://jazz.net/forum/questions/31293/query-work-items-history talked more detail about your requirement.

Regards,
Lily
Zachary K selected this answer as the correct answer

Your answer


Register or to post 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.