Parent / Child Relationship

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,

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.

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.

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.

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.

What part of the ETL loads this data?

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.