How to use WC_String_Ext table in BIRT to get historic data on custom attribute?
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
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.
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 |
|
|