It's all about the answers!

Ask a question

How to use WC_String_Ext table in BIRT to get historic data on custom attribute?


Cesar Sasaki (511289129) | asked Oct 10 '16, 4:28 p.m.
edited Oct 10 '16, 4:44 p.m.
 Hi

I want to make a report on historic changes on a custom attribute of a workitem.
I may have to use the "WC_STRING_EXT" but I can not understand it. I filter the "KEY" to my attribute id,  but I keep seein the same value.

The DW says that there should be a PREV_VAL column but I can not see it on the table.
I'm using BIRT and RTC 4.0.6
thanks!

One answer



permanent link
Donald Nong (14.5k614) | answered Oct 10 '16, 8:34 p.m.
Are you referring to this post?
https://jazz.net/forum/questions/113542/historical-data-for-custom-attribute-in-birt

You need to join the Workitem_Chngs table to get what you want. Note the definition of the second column of the Wc_Type_Ext table.

Wc_Factid Long The Workitem_Chngs fact representing the work item state. A reference to the Workitem_Chngs table


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.