Historical Values for custom attributes in BIRT
Hi
I am creating a few custom reports using BIRT for RTC 3.0.1.1. We have a requirement to historical values for a custom attribute 'Health' which is an enumeration having values 'Red', 'Amber' and 'Green'. In my report I want to display the value of this attribute this week (current value) and previous week (past value). I am looking at the WORKITEMS_CHNGS table to see the historical values but there is no option for me to query the historical value for a custom attribute of workitem. Can you please guide me on this? Thanks!!
Regards
Vinay
I am creating a few custom reports using BIRT for RTC 3.0.1.1. We have a requirement to historical values for a custom attribute 'Health' which is an enumeration having values 'Red', 'Amber' and 'Green'. In my report I want to display the value of this attribute this week (current value) and previous week (past value). I am looking at the WORKITEMS_CHNGS table to see the historical values but there is no option for me to query the historical value for a custom attribute of workitem. Can you please guide me on this? Thanks!!
Regards
Vinay