Help with filtering Tickets based on issueLinkType

[inahury1]

I am trying to create a filter to view all Tickets where the issueLinkType is Empty and not having any luck.

I know I can get a list of tickets with that value filled out using this:

issuetype = Ticket AND issueLinkType = "related Story"

However, I need to reverse. Any help would be appreciated! Thanks!

[inahury1 · Accepted solution]

I figured it out! 

issuetype = Ticket AND (issueLinkType != "related story") works! Thanks!!

[David Blank]

Hi @inahury1 and welcome to the Atlassian Community!

To get the issues that do not have linked issues, have you tried:

issueLinkType IS EMPTY 

The reverse of what you have would be:

issuetype = Ticket AND issueLinkType != "related Story"

[inahury1]

Unfortunately, Jira says that "is EMPTY" isn't supported by issueLinkType. 

Thanks though!

:(

[David Blank]

@inahury1 have you tried:

issuetype = Ticket AND issueLinkType != "related Story"

That will give you the issues that do not meet your link type. You could also try:

issueLinkType NOT IN ("related Story", "other linktype")

[inahury1]

Thanks!!