You've been invited into the Kudos (beta program) private group. Chat with others in the program, or give feedback to Atlassian.
View groupJoin the community to find out what other Atlassian users are discussing, debating and creating.
Hi,
I have a list of issues, some having at least 1 linked issues while others having none. I was wondering what is the syntax of the JQL that would filter out the issues with linked issues?
The end result should be a list of issues with no linked issues.
Sincerely,
Jason
Try the following in your JQL filter
issueLinkType is empty
I was interested in this issue because the inbuilt issueLinkType is rather new (since 8.0) and I had never used it.
It seems like the "is" operator is not supported though(https://confluence.atlassian.com/jiracoreserver/advanced-searching-fields-reference-939937719.html#Advancedsearching-fieldsreference-issuelinktypeIssuelinktype)
so the way I could achieve this was by using "issueLinkType not in ( Linktype1, ... , Linktype n)". So basically saying its Not in the list of all the issuelinks present in my instance. of course if it would be possible the is-operator would be more stable (in case new issue Link Types gets introduced). So its only a workaround but atleast it works :)
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi all,
thanks for your help. I tried "issueLinkType" and as Mario mentioned, the "is" operator didn't work. I did some investigation and found the solution. This assumes you have the Adaptavist ScriptRunner add-on installed.
I added the following line to my JQL:
and issueFunction not in linkedIssuesOf("")
This would give me issues that have no linked issues. I could add a subquery to the linkedIssuesOf to filter linked issues via status, resolution, etc.
Jason
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Connect with like-minded Atlassian users at free events near you!
Find an eventConnect with like-minded Atlassian users at free events near you!
Unfortunately there are no Community Events near you at the moment.
Host an eventYou're one step closer to meeting fellow Atlassian users at your local event. Learn more about Community Events
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.