Historical data in BIRT for items' states

Zachary K

(193●5●43●39) 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.

0 votes

1 answer

4,822 views

0 votes

Accepted answer

Permanent link

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

1 vote

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.

Follow this question

By Email:

Once you sign in you will be able to subscribe for any updates here.

By RSS:

Answers

Answers and Comments

Question details

rational-team-concert

× 42,901

birt

× 324

data

× 26

historical

× 5

Question asked: Mar 26 '13, 10:07 a.m.

Question was seen: 4,822 times

Last updated: Mar 26 '13, 6:42 p.m.

Historical data in BIRT for items' states

Zachary K

1 answer

4,822 views

0 votes

Accepted answer

Lily Wang

Your answer

Follow this question

Question details

Related questions