JQL for all Work Items Under Initiative

[Cyril James]

Hey Friends, I have an Initiative with 20 child epics, and then about 100 stories within the epics.

Is there a simple query that I can use to pull all work items under one initiative.  All epics and stories.

Thank you!

[John Funk]

Hi Cyril - Welcome to the Atlassian Community!

Try this query: issuekey in portfolioChildIssuesOf("INIT-001") 

where INIT-001 is the key for your Initiative.

[Mikael Sandberg]

You need an app from the Marketplace in order to do search like that, default JQL cannot do it. I have used JQL Tricks and Enhanced Search (Scriptrunner) in the past to create similar filters. You could also use JXL to do this.