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

Earn badges and make progress

You're on your way to the next level! Join the Kudos program to earn points and save your progress.

Deleted user Avatar
Deleted user

Level 1: Seed

25 / 150 points

Next: Root

Avatar

1 badge earned

Collect

Participate in fun challenges

Challenges come and go, but your rewards stay with you. Do more to earn more!

Challenges
Coins

Gift kudos to your peers

What goes around comes around! Share the love by gifting kudos to your peers.

Recognition
Ribbon

Rise up in the ranks

Keep earning points to reach the top of the leaderboard. It resets every quarter so you always have a chance!

Leaderboard

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,551,708
Community Members
 
Community Events
184
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!

7 answers

1 accepted

9 votes
Answer accepted
Daniel Turczanski - JQL Search Extensions
Marketplace Partner
Marketplace Partners provide apps and integrations available on the Atlassian Marketplace that extend the power of Atlassian products.
Mar 05, 2020 • edited Sep 18, 2020

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)

3 votes
Jack Brickey
Community Leader
Community Leader
Community Leaders are connectors, ambassadors, and mentors. On the online community, they serve as thought leaders, product experts, and moderators.
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....

On our Jira (v8.20.10) it had been renamed "Epic Link" as Siddharth mentioned, but the 'is' did not work, so my final search was:

 

project = <MYPROJECTNAMEHERE> AND type = Story AND "Epic Link" = EMPTY

Mauricio Borges
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!
Mar 02, 2023

Worked for me

0 votes
Jayadev BS
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!
Apr 09, 2023
The best I explored is: 

"Epic Link" = EMPTY AND type != Epic 

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"

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