BIRT Retrieving Workitem description

Zachary K (193●5●42●39) | asked Jun 02 '12, 9:32 p.m.
edited Jun 02 '12, 10:38 p.m.

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

Most liked answers|Newest answers|Oldest answers ↑

permanent link

VK L (817●7●155●159) | answered Jun 03 '12, 9:49 p.m.

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.

Comments

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?

Thanks,

permanent link

Sean G Wilbur (872●1●24●21) | answered Jun 04 '12, 9:19 a.m.
JAZZ DEVELOPER
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.
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.

RTC Report Screen

http://screencast.com/t/s7Z0E03ra3c
http://screencast.com/t/UOZqw3Y7

-Sean

0	permanent link Zachary K (193●5●42●39) \| 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...

0	permanent link Zachary K (193●5●42●39) \| answered Jun 05 '12, 3:18 p.m. Thank you Sean - That works fine now

Your answer

Register or log in to post 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.

It's all about the answers!

Related questions

BIRT Retrieving Workitem description

4 answers

Your answer