It's all about the answers!

Ask a question

BIRT Retrieving Workitem description

Zachary K (19344239) | asked Jun 02 '12, 9:32 p.m.
edited Jun 02 '12, 10:38 p.m.

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.

4 answers

permanent link
VK L (8177145159) | answered Jun 03 '12, 9:49 p.m.
           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.


Zachary K commented Jun 04 '12, 9:09 a.m. | edited Jun 18 '15, 11:31 a.m.

Thanks for the reply - 

Yes that's a possibility but it is very slow - Is there any other way of doing it without having to resort to a join?

permanent link
Sean G Wilbur (87212421) | answered Jun 04 '12, 9:19 a.m.
edited Jun 04 '12, 12:25 p.m.
 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.

[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.

RTC Report Screen


permanent link
Zachary K (19344239) | answered Jun 04 '12, 11:30 a.m.
edited Jun 04 '12, 11:31 a.m.
Yes but running a query as a data set will not return all the fields defined in the query. It only returns the WI id and the summary...

permanent link
Zachary K (19344239) | answered Jun 05 '12, 3:18 p.m.
Thank you Sean - That works fine now

Your answer

Register or to post your answer.