JQL Assistance - Retrieve the Children of multiple Initatives

[Lee Street]

I want to create a filter to retrieve the children of multiple initiatives but have not been successful

An initiative is the parent to an Epic in our structure

Id like to retrieve all the initiative children (Epics, Stories, Bug, etc) for a plan

Can you assist?

[Prosper Agwegiokhe]

Hi @Lee Street, 

My name is Prosper, and I’m a support engineer at Appfire. I’m here to help.

If you’re open to a plugin suggestion, I recommend trying our app, JQL Search Extensions for Jira.

You can use the following query:

issue in childrenOfIssuesInQueryRecursive("key in ('issueKey1', 'issueKey2') and type=Initiative")

This query will recursively return the children of the issues "'issueKey1', 'issueKey2'".

For more details about these queries, feel free to refer to our documentation, and don't hesitate to reach out to our support team if you have any further questions.

We’d be happy to assist you!

Best regards,
Prosper.

[Rachel Wright]

Hi @Lee Street ,

It sounds like you might be using the issue hierarchy and plans feature in Jira Cloud. If so, you can use a JQL statement like:

issuekey in portfolioChildIssuesOf("ISSUE-123")

Simply replace ISSUE-123 with the ID of one of your initiative issues.

There's more info about this query and others you can use with plans here: https://support.atlassian.com/jira-service-management-cloud/docs/search-for-advanced-roadmaps-custom-fields-in-jql/

Hope this helps!

Rachel Wright
Author, Jira Strategy Admin Workbook

[Lee Street]

Thanks Rachel, how do I do that for multiple initiatives, not just one though in one JQL filter?