Difference in JQL results

[Volodymyr]

I have two JQL queries:
- The first:
project = CLPS AND issuetype = Opportunity AND status != Closed AND (cf[16217] is EMPTY OR cf[16217] is not EMPTY)
- The second:
project = CLPS AND issuetype = Opportunity AND status != Closed
The first one returns 565 and the second one 594 issues.

I've tried modifying these queries in different ways (w/ or w/o a specific value), but at the end I always got a difference of 29 issues and can't find out what exactly might be the problem.

Maybe a mistake lies in the request itself?

[Volodymyr · Accepted solution]

The queries are working correctly and the issue is not in JQL, but in indexes. After re-indexing project everything works and JQL started showing the same result for both queries.

Hope it can help someone.

[Pavel Junek]

Hi Volodymyr,

In the first case, it looks like Jira is returning a number of issues for cf[16217] is not EMPTY, because the OR operator is used.

But I'm just guessing.

[Volodymyr]

@Pavel Junek Hi Pavel, I've tried two separate queries and the total amount of issues stayed the same.
project = CLPS AND issuetype = Opportunity AND status != Closed AND cf[16217] is EMPTY
project = CLPS AND issuetype = Opportunity AND status != Closed AND cf[16217] is not EMPTY