How can I write a query that finds all children based on the ultimate parent?

[Gavin Stone]

Our Jira is currently setup like this:
- High Level Objective
- Initiative
- Epic
- Stories in Epic

Let's say the reference for the high level objective is AB-12345. How do I write a query that essentially says "Find all issues where the ultimate parents is AB-12345". I am doing this so I can create a plan that has these items in it. We're currently doing this with a label but I feel there must be an easier way to do this.

Any help appreciated!

[Barnali Putatunda · Accepted solution]

Hi Gavin,

Welcome to the comunity!
You can get all the child issues under AB-12345 using the following JQL: 

issue in (portfolioChildIssuesOf("AB-12345"))

But remember, Currently, portfolioChildIssuesOf() only accepts one input parameter in the form of an issue key. This makes searching for child issues of multiple parents in one JQL not possible, and  it also doesn't allow search of child issues based on other query parameters. Issues under Team managed projects are also not included.

Hope this answers your question.

Best Regards,
Barnali

[Gavin Stone]

Excellent - this works well enough for my use case. Thank you, Barnali!

[Sebastian Krzewiński]

Hi @Gavin Stone 

By "Find all issues where the ultimate parents is AB-12345" are you thinking about all tickets (Initiative, Epic, Story) under your objective or just Stories?

[Gavin Stone]

Hi Sebastian - I need all the initiative/epic/story level. We have a plan that allows a drill down through all those levels so we need more than just stories. Hope that helps clarify.