The Atlassian Community Forums are currently in read-only mode. We will be relaunching on a new platform on September 22 (read more here). We apologize for the extended downtime. For concerns or questions, please email communitymanagers@atlassian.com. See you on the other side, on the new Atlassian Community Forums! :)

×

Forums

Articles
Create
cancel
Showing results for 
Search instead for 
Did you mean: 

How do I search issues that have no issue links?

Alec Jasanovsky
Contributor
August 12, 2019

Before, I was using issueTypeLink is EMPTY, however now this is no longer working. What else can i use to pull in tickets that have no links?

2 answers

1 accepted

Comments for this post are closed

Community moderators have prevented the ability to post new answers.

0 votes
Answer accepted
Rachel Wright
Community Champion
August 12, 2019

Hi @Alec Jasanovsky , I've been trying this in my Jira Cloud instance and I can't get it to work either.  The closest I can get is to filter by issues that have certain types of links, which is of course, the opposite of what you are asking for.

The format for that type of query, for anyone looking for it, is:

  • issueLinkType in ("<insert link type>")
  • Ex: issueLinkType in ("relates to")

Since I haven't solved your problem, here's a workaround, until someone posts a better answer:

Try exporting your issues to Excel and then sort on the "Links" column, which you can't seem to sort on in Jira Cloud. 

I hope this helps in the mean time,
Rachel Wright

Alec Jasanovsky
Contributor
August 13, 2019

Thank you Rachel! That'll definitely work as a good workaround.

1 vote
Muhammad Ramzan_Atlassian Certified Master_
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 Champions.
August 12, 2019

You can get these results using plugin "JQL Search Extensions for Jira & reports"

 

Following queries can help you

 

linksIssuesCount = 0

 

linkedByIssueCount =0

 

Please use this documentation for more queries.

https://jqlsearchextensions.atlassian.net/wiki/spaces/SEARCH/pages/3375124/JQL+Reference+Cloud#JQLReference(Cloud)-LinkType

TAGS
AUG Leaders

Atlassian Community Events