2 JQLs apparently similar doesn't return the same results and we want to understand why

[Gabriel]

Hello Community!

We recently created 2 JQLs that should return the same results but aren't and we are trying to figure out why.

Here are the 2 JQLs:

(project = IE AND issueLinkType != blocks) OR (project = IE AND issueLinkType is empty)

project = IE AND (issueLinkType != blocks OR issueLinkType is EMPTY)

Can someone help us with this?

Thanks!

Gabriel

[Bill Sheboy · Accepted solution]

Hi @Gabriel 

There appear to be at least two open defects for that symptom, which you may watch/vote for here to see progress:

https://jira.atlassian.com/browse/JRACLOUD-76961

https://jira.atlassian.com/browse/JRACLOUD-73640  (Work is in-progress to fix this one!)

Kind regards,
Bill

[Gabriel]

Hi Bill,

Thanks for looking into this.

Have a great day! :)

[John Funk]

Hi Gabriel,

So what are the different results you are getting? Obviously you want to see all issues on the IE project that are not linked to any other issues or are linked to issues with a Link type other than Blocks. 

[Nic Brough -Adaptavist-]

Ideally, compare the two lists and pick on an issue that appears in one, but not the other.

What, exactly, are the links on that issue?

[Gabriel]

We have identified 1 ticket (so far) that doesn't show up using the first JQL but does using the second one.

This ticket has no linked issues so basically issueLinkType is empty

Thanks for jumping in so quickly to help us with this.

[John Funk]

I see no reason why the first one would not show an issue in the project that has an empty link to it. 

[Gabriel]

To add to our research, the first JQL returns 274 results and the second one over 1000 issues (which makes more sense). 

I'll reach out to support as it seems very odd indeed.

[Gabriel]

Another interesting thing:

the first JQL only returns tickets with outward issue links but the second one returns inward AND outward issue links.

[Gabriel]

Thanks @John Funk and @Nic Brough -Adaptavist- for your feedback on this.

Have a great day :)