Create
cancel
Showing results for 
Search instead for 
Did you mean: 
Sign up Log in

Next challenges

Recent achievements

  • Global
  • Personal

Recognition

  • Give kudos
  • Received
  • Given

Leaderboard

  • Global

Trophy case

Kudos (beta program)

Kudos logo

You've been invited into the Kudos (beta program) private group. Chat with others in the program, or give feedback to Atlassian.

View group

It's not the same without you

Join the community to find out what other Atlassian users are discussing, debating and creating.

Atlassian Community Hero Image Collage

Filter list of issues by number of linked issues

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

 

2 answers

1 vote
Jack Community Leader Mar 16, 2021

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 :)

Jack Community Leader Mar 17, 2021

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

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

Thanks for sharing your solution. Scriptrunner to the rescue😁

Suggest an answer

Log in or Sign up to answer
DEPLOYMENT TYPE
SERVER
VERSION
8.15
TAGS

Community Events

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

You're one step closer to meeting fellow Atlassian users at your local event. Learn more about Community Events

Events near you