JQL Code to filter Initiative, All Epics for that Initiative, and All Stories for those Epics

[Bob Martin]

Hello, for a filter, I need to pull all Epics in an Initiative and then all Stories in those Epics.

parent = PROJ-100 returns a list of 16 Epics.

Now I need to include all the Stories in those 16 Epics.  How do I get this level included?

[Trudy Claspill · Accepted solution]

Hello @Bob Martin 

Welcome to the Atlassian community.

You can use this instead.

If PROJ-100 is the issue key for the Initiative:

issuekey in portfolioChildIssuesOf("PROJ-100")

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

[Bob Martin]

@Trudy Claspill Works perfectly, thank you!  

A follow up question, is there a way to display with Epic and then all the Stories after a child of that Epic?

[Trudy Claspill]

No, not in the issue search screen.

You could use the same sort of filter as a Quick Filter in an Agile Board, with the swimlanes set to Epics, and get a display that way of the stories organized by Epics under the specified Initiative.

Use an Advanced Roadmaps Plan to display the results.

[Hannes Obweger - JXL for Jira]

Hi @Bob Martin

welcome to the community!

I understand that you'd also want to see your epics and stories in their hierarchy, with the stories nested under their respective epics.

In addition to the options that have already been mentioned, you'll also find options in the Atlassian Marketplace.

E.g., this is what it could look like in the app that my team and I are working on, JXL for Jira:

For context, JXL is a full-fledged spreadsheet/table view for your issues that allows viewing, inline-editing, sorting, and filtering by all your issue fields, much like you’d do in e.g. Excel or Google Sheets. It also comes with a number of advanced features, including support for Jira's built-in issue hierarchy as shown above, configurable custom issue hierarchies, issue grouping by any issue field(s), sum-ups, or conditional formatting.

There may be other apps that can help with this, too. You may already know that you can trial any app for free for 1 month, and depending on the size of your size, it may be free forever. So if an app is an option for your, perhaps try a few and see which works best for you.

Any questions just let me know,

Best,

Hannes

[Bob Martin]

Thanks, Hannes!