Filter JQL - All Issues Under Initiative

[Cyril James]

I am not good with JQL.  I would like to create a filter that captures all issues under an Initiative.  

Initiative->Epics>Stories>Tasks

I am going to use this filter to set up a Jira Plan.

Thank you so much

[Trudy Claspill · Accepted solution]

Hello @Cyril James 

Refer to this:

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

you should be able to use the porfolioChildIssuesOf() function.

• To get all child issues below INIT-001 and not just the child issues at the epic hierarchy level:

  issuekey in portfolioChildIssuesOf("INIT-001")

[Cyril James]

Thank you Trudy!  So, I got this filter set up that you mentioned and it does pull the Epics and Stories under the Initiative but it does not pull the Initiative as an issue.

I tried "Parent" in (INIT-0001" or key = INIT-0001) which pulls the Initiative and Epics but no stories.

Is there a way to combine them both.

[Trudy Claspill]

If this gets you the Epics and the Epic's child issues under the specified Initiative

issuekey in portfolioChildIssuesOf("INIT-001")

...and you want to add to that list the Initiative itself, then modify the filter thus:

issuekey in portfolioChildIssuesOf("INIT-001") or issuekey in (INIT-001)

[Cyril James]

That worked!  I wish I could send you a Starbucks!

[Trudy Claspill]

I'm glad I could help you.

Please consider clicking the Accept Answer button to help other users searching this forum find posts with validated solutions.

[Bolaji Lawal]

@Trudy Claspill Please help. What if I want to see more than one Initiative for the filter above? 

[Trudy Claspill]

Hello @Bolaji Lawal 

Welcome to the Atlassian community.

For future reference:

1. Adding to an existing post with a tangentially related question, especially when the post is so old, is considered poor community etiquette.
2. Also the only people who get notified of updates to a post are the original author, people who elected to Watch the post, and people who responded. Those people may no long be active in the community.
3. So, to get better visibility and notice from the entire community, it is better to create your own new Question by using the Ask a question option at the top of the screen in the blue menu bar.

To get information for more than one initiative you would have to replicate the criteria for each initiative and join them with OR.

issuekey in portfolioChildIssuesOf("INIT-001") OR issuekey in portfolioChildIssuesOf("INIT-002") OR issuekey in portfolioChildIssuesOf("INIT-003")

[Bolaji Lawal]

@Trudy Claspill Apologies for the bad etiquette. I was searching through google when I saw this post, so I just replied to it. Thanks for your help!