Need a SQL filter

[Aria Naseri]

Please help me Prepare a JQL search in Jira (ScriptRunner enhance) to filter all Epics (those without stories as children) + All stories under an Epic excluding the Epic itself - the name of the initiative on top is "NV6PO-1"

here is the output I am looking for:

A filter that does the following filtering:

• All Stories under Epics (excluding the Epics themselves).
• All Epics that have NO Story children.

[Mathew Lederman]

@Aria Naseri your question isn't entirely clear, so you may have to piece some of this together yourself, but here are 3 queries to get each of the data points you've requested.

This will get you all children of your initiative.

 issueFunction in childrenOf("key = NV6PO-1")

 This will get you all stories under an epic assuming NV6PO-2 is an epic

 issueFunction in childrenOf("key = NV6PO-2"") and issueType = Story

This will get you all Epics without stories:

issuetype = Epic and issueFunction not in parentsOf("type = Story")