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:
@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")
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.