Jira filter results with "!=" or EMPTY

Lakshmi S
Contributor
November 22, 2024

Hi Team

We have a field labeled "Technical Product Owner" with a checkbox that can be marked as "Yes." However, when we try to filter the results, we get incorrect outcomes. We have over 1,000 tickets with the "Yes" checkbox unchecked, but only about 100 tickets are being displayed. Is there a way to obtain the correct results for tickets where the checkbox is unchecked?


......... AND  "Technical Product Owner" != Yes
Or
............ AND "Technical Product Owner" is EMPTY

TPO.png

2 answers

0 votes
Lakshmi S
Contributor
November 25, 2024

I have reindexed the Jira project, and now the filter shows accurate results.

0 votes
Rodrigo Angulo
Contributor
November 22, 2024

@Lakshmi S "Technical Product Owner" is EMPTY should be correct. Are you looking at the results in a dashboard that is limited to 100 max results? Are you looking in the all issues filter page? Can you share your full JQL statement?

Lakshmi S
Contributor
November 22, 2024

Hi @Rodrigo Angulo ,

We are looking all issues in filter page.

Here is the jql query. It should display 1000+ tickets, but showing 100+ only tickets.

project = TEST AND "Technical Product Owner" = EMPTY

Rodrigo Angulo
Contributor
November 22, 2024

I noticed you mentioned = EMPTY but try to use this: 

"Technical Product Owner" is EMPTY

you can try to specify the request type you are working specifically as well. There could also be issue security potentially affecting your search results.

Lakshmi S
Contributor
November 22, 2024

The project doesn't have any security levels, and it has only one issue type.

Suggest an answer

Log in or Sign up to answer