Query to find Tickets with No Issues Linked

[Dash_ Karrie Contractor]

Is there a query available on Jira Software Server that shows tickets with NO Issues Linked? Using plugins is not an option.

[Brant Schroeder · Accepted solution]

@Dash_ Karrie Contractor You can use issueLinkType NOT IN.  You will have to list all the issue link types like so:

issueLinkType NOT IN (blocks, "is blocked by", clones, "is cloned by", duplicates, "is duplicated by", "has to be finished together with", "has to be done before", "has to be done after", "earliest end is start of", "start is earliest end of", "has to be started together with", causes, "is caused by", "relates to")

[Dash_ Karrie Contractor]

Thank you, this worked for me!

[Laurie Sciutti]

Hi @Dash_ Karrie Contractor ~ IF you use ScriptRunner, you can try this for Data Center:

issuetype in standardIssueTypes() and issueFunction not in hasLinks()

I specified only standard issue types as sub-tasks are handled a bit differently.  If you need to include sub-tasks, you can leave off the issuetype portion of the above JQL.  HTH 

[Bill Sheboy]

Hi @Dash_ Karrie Contractor 

I am using Jira Cloud, not Data Center, but I wonder...have you tried using issueLinkType, perhaps like this:

issueLinkType IS EMPTY

I believe that would still include issues with an epic parent but exclude all other link types.

Kind regards,
Bill