BIRT - Historical data for attribue Due Date

Zachary K

(193●5●43●39) Jul 11 '13, 4:21 p.m.

Hello,
Is it possible to get historical data in BIRT for the attribute DUE DATE.
I don't see this information in table WORKITEM_CHNGS stored in the WORKITEMS_SNAPSHOT.
Thanks in advance for your help

1 vote

2 answers

4,438 views

1 vote

Accepted answer

Permanent link

Sandy Grewal

JAZZ DEVELOPER (1.6k●12●23) Jul 11 '13, 8:43 p.m.

Zack, try

Live_Workitem_Cnt Due_Date field

Zachary K selected this answer as the correct answer

0 votes

Comments

@zachary, I thought you were looking for historical data... To my understanding, this Live_Workitem_Cnt only contains live data. For example, if the due date was changed several times, the due date in the Live_Workitem_Cnt would only show the current.

The historical data are ETLed into those work item changes table when snapshot is running.

@sandyg, can you confirm? Thanks.

Zachary K

Jul 12 '13, 2:18 p.m.

Correct, the table to use is WORKITEM_CHNGS not Live_Workitem_Cnt

One other answer

Permanent link

Clement Liu

(1.5k●5●43●49) edited

Jul 11 '13, 4:53 p.m.

Did you check WC_TIMESTAMP_EXT?

Thanks.

0 votes

Comments

Zachary K

Jul 11 '13, 9:26 p.m.

Wc_TIMESTAMP_EXT is only for custom attribute. Duedate is a build-in attribute

Clement Liu

Jul 12 '13, 10:09 a.m.

Sorry, you're right

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: Jul 11 '13, 4:21 p.m.

Question was seen: 4,438 times

Last updated: Jul 12 '13, 2:18 p.m.

BIRT - Historical data for attribue Due Date

2 answers

4,438 views

1 vote

Accepted answer

Live_Workitem_Cnt Due_Date field

Comments

One other answer

Comments

Your answer

Follow this question

Question details

Related questions