Forums

Articles
Create
cancel
Showing results for 
Search instead for 
Did you mean: 

Jira filter results with "!=" or EMPTY

Lakshmi CH
Rising Star
Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Leaders.
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 CH
Rising Star
Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Leaders.
November 25, 2024

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

0 votes
Rigo
Contributor
November 22, 2024

@Lakshmi CH "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 CH
Rising Star
Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Leaders.
November 22, 2024

Hi @Rigo ,

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

Rigo
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 CH
Rising Star
Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Leaders.
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