nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

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?

Accepted answers

Volodymyr

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.

All comments

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

Volodymyr

Welcome!

It looks like you're new here. Sign in or register to get started.

Quick Links

Find more posts tagged with

server

jira-software

jira-software-server