How to Write a JQL That Ignores LinkedIssues of a Specific Issuetype

[Kashif Saleem]

I'm trying to create a jql in jira cloud that returns all tickets in a specific status that are not linked to stories.

Any help would be much appreciated.

[Daniel Turczanski - JQL Search Extensions]

Hi @Kashif Saleem, as others already posted, you can get approximate results with issueLinkType, or, if you happen to have our app JQL Search Extensions, you can use linkedIssueType extension:

linkedIssueType!=Story or linkedIssueType is empty

[Bill Sheboy]

Hi @Kashif Saleem 

I do not believe that query is possible with out-of-the-box JQL.  You would need a marketplace addon app for JQL/scripting to do it.  This would get you close, but it does not check the type of the linked issues:

project = myProject AND status = "In Progress" AND issueLinkType IS EMPTY

You could refine that if you know stories only use certain types of links.

If you only need this one time, you could try to export to a spreadsheet to perform the check.

Kind regards,
Bill

[Jack Brickey]

insert your desired status

status = "to do" and issueLinkType is empty