Forums

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

Why does my JQL return a value for tickets not in the query?

Jeremy Price
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.
January 10, 2019

I have a simple query of cf[10301] is not EMPTY ORDER BY cf[10301] DESC. Which is my custom field that is titled "Acceptance Criteria". As you can see I have it set to only show tickets that have a value in that field. However when I sort them as you can see in the screen shot it has a few tickets that don't have a value in them and it still shows up. Not sure what I need to do to prevent this from returning incorrect data. 

Snag_67bdbe3.png

 

2 answers

0 votes
Payne
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.
January 10, 2019

Perhaps the few that appear empty actually contain a space character.

0 votes
Alexey Matveev
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.
January 10, 2019

Hello,

Make sure that the cf[10301] is the Acceptance criteria field.

Suggest an answer

Log in or Sign up to answer