Needs to create a query which will show hierarchy view of Parent Story with Children Task?

Hello Lauren,

Thanks for your help.

Could you please help with Summary section as  hierarchy view parent story with children task.

Example:

Id   Summary     Children

1    Story_1       2,3

2    Task_1        -

3    Task_2        -

4    Stroy_2       5,6

5    Task_3       -

6    Task_4       -

Hi Rajeev,
I'm not sure what you mean?  The summary is listed in the query results.

Hello Lauren,

Thanks for your help.  Could you please run your suggested query with pleany of story and task.  Do you get the summary  hierarchy view for Story and task?

Does this make sense?  If it does not and I can call you.  Please privde a way so that I can talk to you.  Thanks again for your help.

Hi Rajeev,
I ran the query in our RTC project area.  I'm including a screenshot of a portion of the results.  There were over 1000 results.  You can create the query yourself and see the results at https://jazz.net/jazz/web/projects/Rational Team Concert#action=com.ibm.team.workitem.newQuery.

Hello Lauren,

Thanks for the info.  I am looking to get the info exported to csv file with NOT only the task numbers but also the summary part of it.  This only shows up on the screen but NOT in exported csv format and also NOT in View Full Result in Printable Format.

Example:

Is it possible to get the summary  hierarchy view for Story and task?

Example for desire query:

The report you have with story id 253416 Summary and all the children task also shows up as hiearchy view in Summary and also allows it to export to a csv file and View Full Result in Printable Format.

Hi Rajeev,
I think I finally understand what you mean.  The problem you're hitting is that while the query results display the summary of the children, the csv file and view full results in printable format do not.  I created a query that returns stories that have tasks as children and tasks that have stories as parents.
 

The problem is that there is not a good way to sort these in the ui.  I think if you downloaded this as a csv, you could use a spreadsheet program to sort these by the id if it was a story or by the parent id if it was a task.

You could submit an enhancement request for this issue.

Hello Lauren,

Thanks for the info.  I created the suggested query but it will not produce any output.  Would you be kind enogh to submit an enhancment request for us.  If you us to submit it then could you please tell us the process for it.

Hi Rajeev,

I'm surprised you didn't get any output.  To make sure you're setting up the query correctly, you could create the query in our RTC project area, which has plenty of data that will return results.

To submit an enhancement request, go to My Stuff (there is a link at the top of this page).  Click the Submit a Bug option and choose Rational Team Concert.  This will create a new defect for you in the RTC project area.  Since you'll want an enhancement instead, use the Work Items menu to create a new enhancement.  You may want to include a link to this forum post in the description.