BIRT Retrieving Workitem description
Hi,
I've created 2 data set one for Live_WorkItem_Cnt and another one for Work_item_extra_data table. I need to display the list of workitems with their description.
I fetch the live_workitem_cnt data set and create a table from it in the report editor. How can I then add the description from the other Work_item_extra_data table? I don't know how to bind the Work_item_extra_data parameter to the work item ID for that particular table row.
Also how could I display the workitems' ranking?
Any sample or guidance is much appreciated.
Thanks
4 answers
Hello,
Now you have 2 data-sets - create a joint state mentioning ID as the unique key column from both and then taking the other required columns...then use this new data -set for the table.
Thanks.
Now you have 2 data-sets - create a joint state mentioning ID as the unique key column from both and then taking the other required columns...then use this new data -set for the table.
Thanks.
Another simple option if you want to avoid joining all the tables your self if to use the results of a query as your data set.
http://www.youtube.com/watch?v=NgkJs6Mk2IE
[edit] Forgot that the query results only return the limited set of fields. Quickly tried out the join method and using an inner join that is terribly slow. I also tried just doing a simple sub-query and that returned surprisingly quickly, so that is worth a shot.
http://screencast.com/t/s7Z0E03ra3c
http://screencast.com/t/UOZqw3Y7
-Sean
http://www.youtube.com/watch?v=NgkJs6Mk2IE
[edit] Forgot that the query results only return the limited set of fields. Quickly tried out the join method and using an inner join that is terribly slow. I also tried just doing a simple sub-query and that returned surprisingly quickly, so that is worth a shot.
http://screencast.com/t/s7Z0E03ra3c
http://screencast.com/t/UOZqw3Y7
-Sean