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.
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

The last comments of the forum topic talked more detail about your requirement.

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.