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

[mauricio.groth · Accepted solution]

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 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.

[Trudy 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

[zahir.nuckchady]

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

[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)

[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