How to create data set to make a BIRT report as in attached image
We are trying to obtain the dates when a workitem changed state as per the attached image.
We found this article, which helps some. Creating custom reports with BIRT and Rational Team Concert: Part 3. Advanced reporting techniques http://www.ibm.com/developerworks/rational/library/10/creatingcustomreportswithbirtandrtc-part3/index.html?ca=drs- It explains about a table called WORKITEMS_SNAPSHOT-->WORKITEM_CHNGS. This provides most of the information we need, but there are times when there is more than one record with the same workitem id and state. 
Is there a way to filter out the rows that have the same workitem id and state, but an older timestamp? Is there a better way to join tables.. create a calculated value etc.. to achieve data for our BIRT report? |
One answer
Hello ,
You can use the Java Script Object to store the work items and its multiple states. Then use that object to generate the report. refer following topics into the below link for more info about script : Scripted variables Using the objects in other data sets http://www.ibm.com/developerworks/rational/library/10/creatingcustomreportswithbirtandrtc-part3/index.html?ca=drs- Comments Hi there,
|
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.