Use JQL to find all child issues under an Initiative

Yi Meng March 22, 2024

Hi Community, 

In my Jira cloud, I have set up my issue type hierarchy as: Initiative --> Epic --> Story

I have make one initiative as parent of several Epics and the Epics have stories as their child issues. And I have create a plan to include initiative, Epic and story. Right now, I'm using JQL as ' issuetype in (Initiative, Epic, story) OR parent in (Epic-1, Epic-2, Epic-3). This works now since I don't have to many Epics yet. But it would be hard to maintain if we have more Epics in the future. 

I don't have apps like scriptrunner installed in my Jira. So I can't use the advance search provided by scriptrunner. 

Is it possible to get all the child issues and grandchild issues for an Initiative using JQL? I think the function childIssuesOf() is no longer available now. 

Thanks

3 answers

1 accepted

1 vote
Answer accepted
Stephen Wright _Elabor8_
Community Leader
Community Leader
Community Leaders are connectors, ambassadors, and mentors. On the online community, they serve as thought leaders, product experts, and moderators.
March 22, 2024

Hi @Yi Meng 

This should work:

issue in portfolioChildIssuesOf("ABC-123")

ABC-123 is the issue key for your Initiative.

Ste

Marcin Krasicki March 22, 2024

@Stephen Wright _Elabor8_  isn't 

portfolioChildIssuesOf

require Portfolio for Jira as well as

childIssuesOf

function? 

Stephen Wright _Elabor8_
Community Leader
Community Leader
Community Leaders are connectors, ambassadors, and mentors. On the online community, they serve as thought leaders, product experts, and moderators.
March 22, 2024

Not in Cloud.

You need a Premium plan - as you need Plans (formerly known as Advanced Roadmaps, or Portfolio for Jira).

Then you get access to this function.

Ste

Like # people like this
Marcin Krasicki March 22, 2024

Good to know. Thanks!

0 votes
Charlotte Santos -Appfire-
Rising Star
Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Leaders.
March 22, 2024

Hi @Yi Meng 

I’m Charlotte, a support engineer at Appfire and I’m here to help you.

Unfortunately, natively, you’ll not be able to do it dynamically.

In the app where my team works, JQL Search Extensions for Jira, you can use this query to get all initiatives and their children:

issue in childrenOfIssuesInQueryRecursive("type=Initiative") OR issue in parentsOfIssuesInQuery("type=Epic")

Please contact our support if you have any other questions about this query.

We’ll be happy to help you! 😁

0 votes
Marcin Krasicki March 22, 2024

jira.png

Yi Meng March 22, 2024

You're right. JQL doesn't support recursive query. But I think this function can solve my problem. 

portfolioChildIssuesOf("ABC-123")  

 I can use linedIssues and parent together but it's a little bit tedious if I have many Epics. In general initiatives are less than Epics. :)

Thank you for your help. 

Suggest an answer

Log in or Sign up to answer
DEPLOYMENT TYPE
CLOUD
PRODUCT PLAN
PREMIUM
PERMISSIONS LEVEL
Site Admin
TAGS
AUG Leaders

Atlassian Community Events