How to get the issues in hierarchy using a JQL

[Ganeshkumar Meenakshisundaram]

We use Jira Data Center. I would like to get the list of child issues under a Theme.

We have 2 issues of Issue type Theme - say TH-1 andTH-2

Our hierarchy goes like Theme -> Initiative -> Epic

I would like to get the list of Initiatives and Epics that are child issues of TH-1 and TH-2. Is there a way I could get this using JQL?

Additional Info - We have Advanced Roadmaps and Script Runner

TIA

[Anandhi Arumugam _Cprime_ · Accepted solution]

Hello @Ganeshkumar Meenakshisundaram Welcome to the community!

issue in childIssuesOf("TH-1") AND issuetype in (Initiative, Epic)

This should get the Initiatives linked to TH-1 and Epics linked to those Initiatives.

Hope this helps!

[Ganeshkumar Meenakshisundaram]

This worked for me.

[Sebastian Krzewiński]

Hi @Ganeshkumar Meenakshisundaram 

With standard JQL query it is not possible to get what you want. You can try to use "order by" but still I'm not sure that you will get right order.

Regards,

Seba