Filter list of issues by number of linked issues

Question

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

Jack Brickey · Answer

oops....i missed that you are on Server.

Mario Carabelli_h0bo0y · Answer

Thanks for sharing your solution. Scriptrunner to the rescue😁

Jason Yeung_2zffgc · Answer

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