Come for the products,
stay for the community

The Atlassian Community can help you and your team get more value out of Atlassian products and practices.

Atlassian Community about banner
4,362,152
Community Members
 
Community Events
168
Community Groups

JQL: Search for all issues without associated epics

Hi,

I'm trying to create a filter that returns all the issues with no epic associated.

I've searched and tried '"Epic Link" = EMPTY order by created DESC' but it does not return any results, wich is not correct because there are many issues without an associated epic .

I don't know if it is relevant but I'm using only next-gen projects.

Thanks in advance!

5 answers

1 accepted

In next-gen projects it's the parent field that points to the epic.  This returns the issues without epics:

parent is empty

It works! Thanks a lot!

This does not work for me. Included in the results are many items that do have an epic. 

To get a list of just the tickets without epics, I added "AND type not in (Epic), otherwise I got all the tickets without Epics along with all the Epic tickets.

parent is EMPTY AND type not in (Epic)

1 vote
Jack Brickey Community Leader Feb 17, 2020

Well for Classic it would be Epic Link is Empty. But for NG you can’t use that as the epic link is empty for all issues. Odd I know. They are working on a solution last time I checked. 

Thanks! NG projects are good but it seems that are far from being completed. It's a pity.

We will have to wait for the solution....

how can i filter the tasks in an epic that do not have an epic link?

I have tried with this JQL but it doesn't give me results.


project = "BSAN­ Implantacion SIREC ­ 20223.1" and "Epic Link" is EMPTY and issuetype =Task AND "Epic Name" ~ "Fase de Despligue"

0 votes

None of the above worked. This is what worked for me:

"Epic Link" is EMPTY and type not in (Epic, Subtask, Sub-task)

Epiclink=null works for me.

Suggest an answer

Log in or Sign up to answer