How would I find Epics or Stories with no linkedIssues?

[Steve Arrants]

I would like to find all Epics or Stories that don't have any Linked Issues.  Is that possible? 

I've tried, but get the message.  The field 'linkedIssue' does not support searching for EMPTY values.

[Paloma Fondon Araujo · Accepted solution]

Hi @Steve Arrants 

You can try the following JQL:

project = "XXX" and issuetype in (Epic, Story) and issueLinkType is EMPTY

I hope it helps you.
Greetings

[Sudarshan]

Hello @Paloma Fondon Araujo 
I checked your query but issuelinktype does not support "is".

the reason could be that it is an exhaustive list of values for it and there is no value like empty, hence you dont get any.

Hope I am correct.

[Paloma Fondon Araujo]

Hi @Steve Arrants & @Sudarshan 

I have done the test in my environment and the JQL performs the filter correctly and finding those Epics and Stories that do not have any linked Issue, also "issuetypelinks" admits me "IS" value. Attached image:

I don't know if there is something that is not correct ...

Regards

[Sudarshan]

ahh that is good to know, Sorry.

But I dont get it, to me when I use IS it does not work. :( 

[Paloma Fondon Araujo]

Hi again!!! :)

Could you try the following JQL?

project = "XXX" and issuetype in (Epic, Story) and issueLinkType = null

I've tried it and it works for me too...

Regards

[Sudarshan]

ahh ok ok, you are using Jira Cloud.

I checked in Server, so I suspect there could be some changes in the operators and maybe some upgrade in the functions.

Its totally correct :) 

[Sudarshan · Accepted solution]

Hi @Steve Arrants 
try this JQL - to get the list of Stories which are not linked to any Epic.

project = <projectname> AND issuetype = Story AND "Epic Link" = EMPTY

[Steve Arrants]

That does help. I may be able to build on that. What I really need is to find all epics and all stories for a Sprint that don't have any issue links. 

[Sudarshan]

try this 

project = <projectname> AND issuetype = Story AND "Epic Link" = EMPTY and Sprint in closedSprints()

 
If you want from a specific sprint then use Sprint = <sprint ID>