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

Earn badges and make progress

You're on your way to the next level! Join the Kudos program to earn points and save your progress.

Deleted user Avatar
Deleted user

Level 1: Seed

25 / 150 points

Next: Root


1 badge earned


Participate in fun challenges

Challenges come and go, but your rewards stay with you. Do more to earn more!


Gift kudos to your peers

What goes around comes around! Share the love by gifting kudos to your peers.


Rise up in the ranks

Keep earning points to reach the top of the leaderboard. It resets every quarter so you always have a chance!


Come for the products,
stay for the community

The Atlassian Community can help you and your team get more value out of Atlassian products and practices.

Atlassian Community about banner
Community Members
Community Events
Community Groups

issueLinkType is not finding negative results


Using Jira cloud


Following Advanced search reference - JQL fields cloud documentation.


This clause:

and issueLinkType = "is tested by"


returns 3 results, as expected.


This clause:


and issueLinkType != "is tested by"


returns 0 results, whereas about 8 are expected.

1 comment

I think you've run into the thing where humans are not as logical as computers and assume "not there" is the same as "is not".  We are not good a negative logic.

Let's say you've got 11 issues, 3 have links of type "is tested by", 6 have links of another type, and the last 2 have no links.

When you say "issueLinkType != "is tested by", a human will get the logic wrong, and answer 8. 

But that's logically wrong, because there's actually only 6 that have links that are not of that type.  The other 2 don't have links, so they can't have links that are not of that type.  Neither do they have links that are of that type.

My guess is your about-8 issues don't have any links.  So they don't have any links that are not "is tested by"

Try to extends your JQL query in the way:

(issueLinkType != "is tested by" OR issueLinkType is EMPTY)

 I ran into this problem myself wondering why and where the rest disappears, "is EMPTY" comes to the rescue for some of fields.




Log in or Sign up to comment