Come for the products,
stay for the community

The Atlassian Community can help you and your team get more value out of Atlassian products and practices.

Atlassian Community about banner
4,365,129
Community Members
 
Community Events
168
Community Groups

Retrieving a dynamic list of all epics and stories under Initiative

Edited

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.

 

ThanksJira Projects Example.JPG

3 answers

1 accepted

0 votes
Answer accepted

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:

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

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.

1 vote

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

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

0 votes
Mark Segall Community Leader Aug 18, 2022

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

issuekey in childIssuesOf(YOURINITIATIVEKEY)

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

Suggest an answer

Log in or Sign up to answer
DEPLOYMENT TYPE
CLOUD
PRODUCT PLAN
PREMIUM
TAGS

Atlassian Community Events