RTC custom contributors on top of custom text fields to add on BIRT Report
Hi,
I have a situation to display a report in BIRT that should include custom fields (text field and contributors list) in RTC. Thanks to Rafik's video I am able to display custom text fields on the report by creating "Workitem Snapshot" datasource and using LIVE_WORKITEM_CNT table without the duplicate rows.
I am pulling custom text fields value from String_key and String_Val by storing the values in an array on the onfetch of the dataset and later retrieve it on another dataset using the computed columns. On top of that I want to display the custom contributor i.e. UAT Officer on the report. What I have found is Live_Snapshot does have a table "com.ibm.team.workitem.WorkItem" wherein itemExtensions.key and itemExtensions.value.itemId pair store this information in the encrypted form. To retrieve the meaninful value I have to link it with the Contributors table in the Common Snapshot. I want to achieve this as well. Any one please help me how to do this?
Thanks.
|
One answer
I was able to get this to work and this is how. 1. Create a data source to Live_Snapshot 2. Create a new "Simple" Data set. a. Set data source to Live_Snapshot b Set Table Name: com.ibm.team.workitem.WorkItem c. Select columns: itemExtensions.value.itemId d. Select parameters: itemId: This can be defaulted to a known WI_ITEMID of a Work Item for testing workItemType = hard code to work item type itemExtensions.key: hard code to the name of the work item field holding the contributor 3. Create a new Simple Data Set a. Set Data Source = Common_Shapshot b. Select columns: Contributor_Itemid, Contributor_Name c. Select parameters: Contributor_ItemID This can be defaulted to a known CONTRIBUTOR_ITEMID for testing purposes 4. Create a Join Query that joins data set in 2 on the left to data set in 3 on the right Do a left outer join and join itemExtensins.value.itemId to Contributor_Itemid 5. In your report, add the join data set in 4 to the column for the custom contributor 6. Do a parameter binding as follows: a. Bind the itemid to the WI_ItemID b. Remove the extra column, header and footer from this nested table You now have the custom attribute contributor listed on your report. |
Comments
Any suggestion please?