RRDI and Work item Parent / Child linking
There are a number of posts on Jazz.net regarding the creation of Parent / Child reports in RRDI. Most simply advise the use of the Request Related Requests table but don't actually advise HOW to do that. Is it possible for someone to generate a simple 'story and it's child tasks / defects' report in RRDI and post it on Jazz.net with some instructions ?
5 answers
Hi Mark
I'll document this in more detail and possibly publish on DeveloperWorks. My preferred way to find and utilize Work Item to Work Item links is use of the 'ODS -> Request Area -> Request Relational Link' folder that is exposed through the default Rational reporting package.
If a CCM project had the following work items in place;
The 'ODS -> Request Area -> Request' (R) folder provides the following crucial data;
The 'ODS -> Request Area -> Request Relational Link' (RRL) folder provides the following crucial data;
By using Joins it is possible to find parent work item information (Join Link being 'RRL.Request2 ID' -- 'R.Request ID') and then use another Join to bring into the result query the child work item information (Join Link being 'RRL.Request1 ID' -- 'R.Request ID').
I have exported a few sample reports detailing a both the above scenario and also how > 1 level of relationship can be reported upon using the example of 'Epic -> Story -> Task'. This zip file can be located here.
Hope that helps,
Mark
Comments
i need same about but again like parent child grandchild relationship report
for Work Item
Parent -> Child ->Child of Child
Comments
