Query to find Tickets with No Issues Linked

Dash_ Karrie Contractor March 6, 2024

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

3 answers

1 accepted

1 vote
Answer accepted
Brant Schroeder
Community Leader
Community Leader
Community Leaders are connectors, ambassadors, and mentors. On the online community, they serve as thought leaders, product experts, and moderators.
March 6, 2024

@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 March 6, 2024

Thank you, this worked for me!

Like # people like this
0 votes
Laurie Sciutti
Rising Star
Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Leaders.
March 6, 2024

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 

0 votes
Bill Sheboy
Rising Star
Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Leaders.
March 6, 2024

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

Suggest an answer

Log in or Sign up to answer