It's all about the answers!

Ask a question

Query to show all children items (including sub children)


Dave Gordon (642) | asked Apr 02 '10, 1:17 p.m.
I was hoping that there would be an easy way to do this, but so far I can't find it. I would like to run a query on a top level EPIC and have the results show me all the sub epics and stories listed below it. For example, suppose I have the following:
EPIC
US1
US2
SubEpic1
SE-US1
SE-US2

Currently, using a query, I can only get US1, US2 and SubEpic1. I want and need to see SE-US1 and SE-US2. Is there anyway to run a recursive query like this?

3 answers



permanent link
Patrick Streule (4.9k21) | answered Apr 06 '10, 4:36 a.m.
JAZZ DEVELOPER
I was hoping that there would be an easy way to do this, but so far I
can't find it. I would like to run a query on a top level EPIC and
have the results show me all the sub epics and stories listed below
it. For example, suppose I have the following:
EPIC
US1
US2
SubEpic1
SE-US1
SE-US2

Currently, using a query, I can only get US1, US2 and SubEpic1. I
want and need to see SE-US1 and SE-US2. Is there anyway to run a
recursive query like this?

In the Eclipse UI, you can enable the hierarchical "Relationships" mode
from the work item view's menu.

Plans will also show you the hierarchical structure of work items.

--
Regards,
Patrick
Jazz Work Item Team

permanent link
Dave Gordon (642) | answered Apr 08 '10, 9:47 a.m.
Thanks .. I've been able to figure that out, but I don't believe that it helps me much. I want to be able to run a report or query where I can see everything below a parent item, including sub-children. Looking at it in the Plan view, unfortunately doesn't help. There is no way to run a recursive query?

permanent link
Patrick Streule (4.9k21) | answered Apr 08 '10, 12:12 p.m.
JAZZ DEVELOPER
Thanks .. I've been able to figure that out, but I don't believe that
it helps me much. I want to be able to run a report or query where I
can see everything below a parent item, including sub-children.
Looking at it in the Plan view, unfortunately doesn't help. There is
no way to run a recursive query?

There is currently no support for recursive queries from the query editor.

I am not sure if it would be possible to create a report for your case.

--
Regards,
Patrick
Jazz Work Item Team

Your answer


Register or to post 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.