Need a SQL filter

Aria Naseri
I'm New Here
I'm New Here
Those new to the Atlassian Community have posted less than three times. Give them a warm welcome!
March 4, 2025

 

 

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.

1 answer

0 votes
Mathew Lederman
Rising Star
Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Leaders.
March 4, 2025

@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")

 

Suggest an answer

Log in or Sign up to answer
DEPLOYMENT TYPE
CLOUD
PRODUCT PLAN
PREMIUM
TAGS
AUG Leaders

Atlassian Community Events