Report to show linked work item types?
Hi,
I would like to create a new BIRT custom report that shows a list of work items and their related work items (i.e, parent work items and their related child work items). How can I navigate through these relationship in the RTC datawarehouse model? Thanks, Ana |
3 answers
On 6/28/2010 3:13 AM, Ana Lopez wrote:
Hi, Ana, There is a video and sample report that might help. http://jazz.net/library/video/285 james RTC Reports Team Lead |
Many thanks for the sample report. I have followed it and I have been
able to create a BIRT report that given the WI ID as a parameter I can get all related WIs and works fine. Problem is that I would need to give the WI summary as input parameter instead of the WI ID. I have checked the LINKS table and the issue is that only the WI ID is available. Could I create a "pre-parameter processing" (I don't know how to call it) to get first the WI ID based on summary and work item type for example, and later use the sample report? How could I "join" the "pre-parameter processing" to the report to get first the WI ID based on summary and work item type input values? Thanks, Ana On 28/06/2010 14:07, James Moody wrote: On 6/28/2010 3:13 AM, Ana Lopez wrote: |
Ana,
Maybe I misunderstand but I don't think you need to do pre-parameter processing. Either (a) the Summary parameter is free-form text (you type it in) or (b) it gets its choices from a data set on (say) LIVE_WORKITEM_CNT. In the latter case, just use WI_ITEMID as the "value" of the parameter, and SUMMARY as the "label" of the parameter. In the former case, when the report runs you just do a lookup using the LIVE_WORKITEM_CNT, passing in the Summary parameter as a data set parameter and using RESULT_SET_SIZE of 1, and select WI_ITEMID. In either case, you now have the WI_ITEMID. Then pass the WI_ITEMID as a parameter to the LINKS table, with the appropriate link type as well. Does this help? james RTC Reports Team Lead On 6/28/2010 9:24 AM, Ana Lopez wrote: Many thanks for the sample report. I have followed it and I have been |
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.