It's all about the answers!

Ask a question
QuestionsTagsUsersBadges
Guidelines | FAQ
Follow this question
Question details

×42,876
×324
×26
×5

question asked: Jul 11 '13, 4:21 p.m.
question was seen: 4,318 times
last updated: Jul 12 '13, 2:18 p.m.

Related questions

BIRT - Historical data for attribue Due Date

1
Zachary K (193●5●43●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

0
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

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

Most liked answers ↑|Newest answers|Oldest answers

0
permanent link
Clement Liu (1.5k●5●43●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 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.