Create
cancel
Showing results for 
Search instead for 
Did you mean: 
Sign up Log in

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 edited

 

 

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
atlassian, team '25, conference, certifications, bootcamps, training experience, anaheim ca,

Want to make the most of Team ‘25?

Spend the day sharpening your skills in Atlassian Cloud Organization Admin or Jira Administration, then take the exam onsite. Already ready? Take one - or more - of 12 different certification exams while you’re in Anaheim at Team' 25.

Learn more
AUG Leaders

Upcoming Jira Events