BIRT - Historical data for attribue Due Date

1	Zachary K (193●5●42●39) \| asked 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

Accepted answer

permanent link

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

Zack, try

Live_Workitem_Cnt Due_Date field

Zachary K selected this answer as the correct answer

Comments

Zachary K commented Jul 12 '13, 8:35 a.m.

Thanks Sandy

Clement Liu commented Jul 12 '13, 10:04 a.m. | edited Jul 12 '13, 10:13 a.m.

@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 commented Jul 12 '13, 2:18 p.m.

Correct, the table to use is WORKITEM_CHNGS not Live_Workitem_Cnt

One other answer

Most liked answers ↑|Newest answers|Oldest answers

permanent link

Clement Liu (1.5k●5●42●49) | answered Jul 11 '13, 4:50 p.m.
edited Jul 11 '13, 4:53 p.m.

Did you check WC_TIMESTAMP_EXT?

Thanks.

Comments

Zachary K commented Jul 11 '13, 9:26 p.m.

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

Clement Liu commented Jul 12 '13, 10:09 a.m.

Sorry, you're right

Your answer

Register or log in 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.

It's all about the answers!

Related questions

BIRT - Historical data for attribue Due Date

Accepted answer

Live_Workitem_Cnt Due_Date field

One other answer

Your answer