nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Retrieving a dynamic list of all epics and stories under Initiative

zahir.nuckchady

Hi,

I have defined a Jira Project with a number of Initiatives. Under each Initiative, there is a number of Epics that originate from different Jira Projects. Under each Epic, there are tasks that come from different Jira Projects.

I am struggling to find a query that will dynamically list all of the Epics and Tasks that are added to the Initiatives.

Appreciate the support.

Thanks Jira Projects Example.JPG

Accepted answers

mauricio.groth

Hi @zahir.nuckchady

In Jira Cloud you can currently find the children of initiative by specifying the issue key:

issuekey in portfolioChildIssuesOf(MYKEY-1)

You can specify multiple keys by duplicating the above query and connecting the queries with OR.

To get children of initiatives based on more advanced criteria you can install our professional indexing service:

JQL Search Extensions

After you install the app you can simply search:

issue in childrenOfIssuesInQuery("project='ACME' and type=Initiative")

issue in childrenOfIssuesInQuery("key in (MYKEY-1, MYKEY-2, MYKEY-3)")

You can also find children of initiatives and children of their children with the recursive function:

issue in childrenOfIssuesInQueryRecursive("project='ACME' and type=Initiative")

Check out the documentation for more examples.

If you have any other questions, please contact our support. We’ll be happy to help you!
Best regards,
Maurício

All comments

Mark Segall

Hi @zahir.nuckchady - Assuming you're using the parent link field to link epics to initiatives, you could do this:

issuekey in childIssuesOf(YOURINITIATIVEKEY)

Trudy P Claspill

Hello @zahir.nuckchady

I don't work with Advanced Roadmaps, but found the following by searching.

This post has comments about methods to get the results.

https://community.atlassian.com/t5/Jira-questions/JQL-query-to-find-child-issues-of-Initiative/qaq-p/461409

There is also this article that you might find helpful.

https://support.atlassian.com/jira-software-cloud/docs/search-for-advanced-roadmaps-custom-fields-in-jql/

And there is also this issue in Atlassian's backlog

https://jira.atlassian.com/browse/JSWCLOUD-19543

mauricio.groth

Hi @zahir.nuckchady

In Jira Cloud you can currently find the children of initiative by specifying the issue key:

issuekey in portfolioChildIssuesOf(MYKEY-1)

You can specify multiple keys by duplicating the above query and connecting the queries with OR.

To get children of initiatives based on more advanced criteria you can install our professional indexing service:

JQL Search Extensions

After you install the app you can simply search:

issue in childrenOfIssuesInQuery("project='ACME' and type=Initiative")

issue in childrenOfIssuesInQuery("key in (MYKEY-1, MYKEY-2, MYKEY-3)")

You can also find children of initiatives and children of their children with the recursive function:

issue in childrenOfIssuesInQueryRecursive("project='ACME' and type=Initiative")

Check out the documentation for more examples.

If you have any other questions, please contact our support. We’ll be happy to help you!
Best regards,
Maurício

zahir.nuckchady

Hi Mark,

Thank you for your reply. I am having an error with this query.

Unable to find JQL function 'childIssuesOf

However, it works with issuekey in portfolioChildIssuesOf

zahir.nuckchady

Hi Mauricio.

Appreciate the feedback. It works perfectly. Thanks.

My challenge (without any plugin) is that I need to add to manually edit the filter to add new initiatives as they are being added.

Thanks again.

zahir.nuckchady

Hi Trudy. Thank you for taking the time to post this.

Welcome!

It looks like you're new here. Sign in or register to get started.

Quick Links

Find more posts tagged with

jira

cloud

jira-software

jira-software-cloud

jql