How do I create a filter that shows all user stories and bugs in an initiative?

[EricC]

Our company has a large initiative that has 17 parent epics. We'd like to see all the work items that are in each epic, without including the epics. Is there a way to do this?

[Trudy Claspill · Accepted solution]

Hello @EricC 

Welcome to the Atlassian community.

Yes, there is a way to do that!

Referring to this document:

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

...you can use a JQL like this:

issuekey in portfolioChildIssuesOf("INIT-001") AND issueType != Epic

...where INT-001 is the issue key for your initiative. If the children of the Epics might have sub-tasks that you want to exclude also, you can modify the JQL thus:

issuekey in portfolioChildIssuesOf("INIT-001") AND issueType not in (Epic, subTaskIssueTypes())

[EricC]

That worked, Trudy, thank you so much!

[Trudy Claspill]

I'm glad I could help you!

If my response helped you solve your problem, please consider clicking on the Accept Answer button to mark your question as Solved. That helps others searching this community find posts that have validated solutions.