Forums

Articles
Create
cancel
Showing results for 
Search instead for 
Did you mean: 

Need help with jql query to find non-closed epics with all stories & tasks closed

sammy malak
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!
September 1, 2023

I am trying to write a JQL that will give us all the EPICS that have Closed Stories and Tasks associated to it.

 

This should enable our team to "find" all the EPICS that perhaps should be closed out because all their work has been addressed. Help would be appreciated!

1 answer

1 accepted

4 votes
Answer accepted
Mikael Sandberg
Community Champion
September 1, 2023

Hi @sammy malak,

Welcome to Atlassian Community!

Out-of-the-box JQL cannot do nested queries which you would need to do in order to get the result you are looking for. You need to get an app that extends JQL in order to do a search like that. There are multiple apps in the Marketplace that can do this, I have used both Scriptrunner/Enhanced Search and JQL Tricks before for searches like that.

sammy malak
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!
September 1, 2023

That's good to know, thanks!

Like Mikael Sandberg likes this

Suggest an answer

Log in or Sign up to answer