How do I write a filter to extract all Initiatives and their Epics, Stories, Task and Sub-tasks?

[Jerry Raterman]

I need a filter to extract Initiatives for my Roadmap.  I have the filter to do this, but ALSO need each of the underlying sub-task for these Initiatives to display on the Roadmap.  The only way I have found to do this to date is:    

"...OR issue in childIssuesOf("PR-1234")  ".   

This means that I have to specify each Initiative individually, currently up to 40 times.  I would like to extract all the Initiatives that meet my extract AND all of their subtasks.  Appreciate any help!

[Laurie Sciutti]

Hi @Jerry Raterman ~ do you use ScriptRunner?  If so, this will work, https://docs.adaptavist.com/sr4js/8.25.0/features/jql-functions/included-jql-functions/portfolio#portfolioChildrenOf 

[Danut M _StonikByte_]

Hi @Jerry Raterman,

Not sure if this is possible with Jira's default JQL.

Some queries that might be helpful: 

parentEpic IN (EPIC-1, EPIC-2) -  this returns the two epics along with their stories and subtasks

parent IN (EPIC-1, EPIC-2) -  this returns the stories under these two epics

But why do you need this? What are you trying to achieve?

Danut.