Parent / Child Relationship
![]()
Hi,
I'm pulling in data from RTC into RI. I'm trying to build a report linking child tasks to parents stories so I can compare the estimation points to the actual hours spent on the tasks. I was following this post: https://jazz.net/forums/viewtopic.php?p=62233&sid=48ef8934e0d5354e5f250f43edb60388#62233 The issue is that I can't find anyway to link the stories to the tasks in the "Request Related Requests" query subject. Any help would be appreciated. |
6 answers
![]()
I am not entirely sure what you mean by "can't find anyway to link", but
what you have to do is - create a query and drag in Request fields - create a filter that only shows Requests of type story - drag in "Request Related Requests" fields - filter those to only show requests of the type task - use the query to create a list report and group by the story fields This is very similar to what is shown here plus you add filters to your query fields: http://blog.haumer.net/wp-content/uploads/2011/06/SimpleListReport/ Hope this helps, Peter. On 8/15/2011 1:53 PM, colinjoyec wrote: Hi, |
![]()
Thanks for your response.
I followed the blog post and it was very helpful, however when I add the fields from both the request and request related requests query subjects, I'm only getting data returned from the request fields. I have not applied any filters - so I don't know if this would affect it. |
![]()
Mmh, if you do not see the parent-child elements then we would not to
analyze why this is not working on your system. Did the Data Collection tasks succeed? Is there data in the REQUEST_HIERACHY table? Do you have permission to view the child tasks. It might be good to work with tech support to analyze the specific reasons. On 8/18/2011 2:53 AM, colinjoyec wrote: Thanks for your response. |
![]()
Thanks Peter, the request_hierarchy table is not populated.
What part of the ETL loads this data? |
![]()
Oh, going back to the beginning of this thread I realize that no version
numbers have been mentioned. Could it be that you are using RTC 2.x or 3.0? I had a look at the ETL and don't think the hierarchy was supported for these releases. For the 3.0.1 release there is an all new Data Manager ETL provided by the RTC team, which populates this table. If I am correct, are you planning to upgrade? Peter. On 8/22/2011 2:24 PM, colinjoyec wrote: Thanks Peter, the request_hierarchy table is not populated. |
![]()
Correct - we are on RTC 3.0 - We have no plan to upgrade to 3.1 but I'll look into this.
Thanks for your help. |
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.