JQL: Search for all issues without associated epics

[Emanuel Braga]

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!

[Daniel Turczanski - __JQL Search Extensions · Accepted solution]

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

parent is empty

[Emanuel Braga]

It works! Thanks a lot!

[Alyson Murphy]

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

[Lori Mendoza]

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)

[Jack Brickey]

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. 

[Emanuel Braga]

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....

[Jaime Basco]

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"

[Siddharth Dalal]

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

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

[John Allen Rabalais]

Epiclink=null works for me.