CODEWITHSUNDEEP
jirajqlepic
user3535684
user3535684

Reputation: 79

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

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!

Upvotes: 7

Views: 19256

Answers (6)

Dannid
Dannid

Reputation: 1697

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

Upvotes: 1

HeavyDNickell
HeavyDNickell

Reputation: 76

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

Upvotes: 0

Nesar Khadem
Nesar Khadem

Reputation: 1

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

Upvotes: -1

Andre Oliveira
Andre Oliveira

Reputation: 128

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.

Upvotes: 0

Nabil Kirmani
Nabil Kirmani

Reputation: 51

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?

Upvotes: 5

Manohar Don
Manohar Don

Reputation: 129

issuetype = Story and "Epic Link" != EMPTY

Upvotes: 12

Related Questions