It's all about the answers!

Ask a question

BIRT - Historical data for attribue Due Date


Zachary K (19354339) | 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.6k1223) | answered Jul 11 '13, 8:43 p.m.
JAZZ DEVELOPER
Zack, try

Live_Workitem_Cnt  Due_Date field

SG

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



permanent link
Clement Liu (1.5k54349) | 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 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.