It's all about the answers!

Ask a question

Assistance needed with an RTC Query


Greg Aurand (111) | asked May 23 '16, 1:51 p.m.
edited May 23 '16, 4:57 p.m.

I need help writing a query.  My tickets are structured as follows:

Epic #123

Story #456 (Parent is 123)

     Children:

          Task 387 (Parent is 456)

          Task 978 (Parent is 456)

Story #789 (Parent is 123)

     Children:

          Task 657 (Parent is 789)

          Task 105 (Parent is 789)

My goal is to write a query that will return all of the stories the Epic.  For example

Epic     Story & Tasks

123      456

123      387

123      978

123      789

123      657

123      105

One answer



permanent link
sam detweiler (12.4k6179201) | answered May 23 '16, 6:00 p.m.
the query layout tool will not allow that data on the same row..

you can do the tree pretty easily, but not always in the right order..
in eclipse query results, click the down twisty (all the way right) and select children in the relationships section


Your answer


Register or to post your answer.