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.
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 :)
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.
Connect with like-minded Atlassian users at free events near you!Find an event
Connect with like-minded Atlassian users at free events near you!
Unfortunately there are no Community Events near you at the moment.Host an event