Is there a JIra query which will return all stories without an EPIC?

Question

I'm trying to tidy up our Jira board and create an accurate story map.

To do that I need to come up with a query that will return open user stories within a certain project that don't have any issue links (preferably 'related to (primary)')- the last part does not seem to be supported.

I've had a look around an post of the Q&As are a few years old, so i'm wondering if it was been updated recently?

I'm using version 5.1

Thanks!

The easiest way would be to create a throwaway JIRA Agile board for the project and look at the No Epics area in the Epic column on the left. If you want to do it in JQL alone you can use: — mdoar, Apr 17 '14 at 19:26
"Epic Link" is empty. Gosh, I don't like the way that stackoverflow decides when to submit text. — mdoar, Apr 17 '14 at 19:27

score 12 · Answer 1 · answered Feb 24 '15 at 19:16

12

issuetype = Story and "Epic Link" != EMPTY

answered Feb 24 '15 at 19:16

Manohar Don

129
1
4

2

this doesn't answer the question correctly. rather, this would return all stories WITH an epic. – thejohnbackes Sep 25 '18 at 18:37

score 5 · Answer 2 · answered Dec 09 '15 at 13:56

5

I used the following query:

project = PROJECTNAME AND issuetype = Story AND "Epic Link" is EMPTY

Seems to work for me, what do you guys think?

answered Dec 09 '15 at 13:56

Nabil Kirmani

51
1
1

score 1 · Answer 3 · answered Mar 04 '19 at 17:43

In addition to "Epic Link" = EMPTY, you might want to filter out issues that, themselves, are EPICs, since they can't have Epic Links and will otherwise show up in the search.

Here's a search to get only issues that have no Epic (but are not Epics themselves):

issuetype != Epic AND "Epic Link" is EMPTY

score 0 · Answer 4 · answered Jun 09 '17 at 07:07

0

Just to throw another answer into the bowl.

You can use your normal workboard (Scrum, Kanban, etc) and add a swimlane with the JQL:

"Epic Link" is EMPTY

Just did this for our board after looking exactly for this.

answered Jun 09 '17 at 07:07

Andre Oliveira

128
2
12

score 0 · Answer 5 · answered Oct 09 '18 at 03:10

0

I don't have enough points for comments or votes yet ... but to add to the one answer provided about the "Board", the JQL will work in a simple issue search as well. I just ran this JQL from Issue Search and it worked like a champ:

project = BI and "Epic Link" is empty

answered Oct 09 '18 at 03:10

HeavyDNickell

56
4

This will return Epic tickets as well, since Epics can't have Epic Links. Perhaps it works for you if you don't have any Epics in that project? – Dannid Mar 04 '19 at 17:40

score -1 · Answer 6 · answered Oct 08 '18 at 19:03

-1

project = PROJECT NAME AND issuetype = ISSUETYPE AND "Epic Link" = EMPTY

answered Oct 08 '18 at 19:03

Nesar Khadem

1

Is there a JIra query which will return all stories without an EPIC?

6 Answers6