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

Cesar Sasaki (511●2●89●129) | asked Oct 10 '16, 4:28 p.m.
edited Oct 10 '16, 4:44 p.m.

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

Most liked answers ↑|Newest answers|Oldest answers

permanent link

Donald Nong (14.5k●6●14) | 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 log in 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.

It's all about the answers!

Related questions

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

One answer

Your answer