BIRT - Historical data for attribue Due Date
![]()
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
![]()
Zack, try
Live_Workitem_Cnt Due_Date fieldSG Zachary K selected this answer as the correct answer
Comments Thanks Sandy
@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.
Correct, the table to use is WORKITEM_CHNGS not Live_Workitem_Cnt |
One other answer
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.