It's all about the answers!

Ask a question
QuestionsTagsUsersBadges
Guidelines | FAQ
Follow this question
Question details

×42,884
×324
×26
×5

question asked: Mar 26 '13, 10:07 a.m.
question was seen: 4,754 times
last updated: Mar 26 '13, 6:42 p.m.

Related questions

Historical data in BIRT for items' states

0
Zachary K (193●5●43●39) | 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

1
permanent link
Lily Wang (4.9k●7●14) | 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.