Forums

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

JQL is not returning the result set properly

Shaik Moid Ahmed October 5, 2020

When i run the JQL in Jira i am not getting the expected result. Can someone please check and help in resolving the issue.

 

The below JQL is not returning the data properly. Even though the Owner field has value.

key = XXX-XX and Owner is not EMPTY

 

2 answers

0 votes
Nic Brough -Adaptavist-
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.
October 5, 2020

To start to debug this:

  • Identify a single issue to work with - one where the owner field is clearly not empty when you look at the issue in the issue view
  • Run another search that will include this issue for some other reason along with another couple of issues.  Add the "owner" field to the issue navigator to check if it appears for that issue
  • Re-index the project and run your search again, does it appear now?

If the re-index fixes it, you'll need to look into what you've done to break the index.  If the re-index does not fix it, you'll need to look at the type of field and its searcher to see what is wrong there

Shaik Moid Ahmed October 5, 2020

Hi Nic

Even though there is value in Owner field its treating as Empty.

Thanks for suggestion. query.png

Shaik Moid Ahmed October 5, 2020

Hi Nic,

 

Please suggest. 

Nic Brough -Adaptavist-
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.
October 5, 2020

What type of field is it, and what is the searcher for it?

Shaik Moid Ahmed October 5, 2020

It is a User pickerUser Picker.png

Nic Brough -Adaptavist-
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.
October 5, 2020

And the second half of the question?

Shaik Moid Ahmed October 5, 2020

The field is Filtering data and fetching the User Filtering: All active users are allowed

Shaik Moid Ahmed October 6, 2020

Hi Nic, 

Can you please suggest on further steps.

Nic Brough -Adaptavist-
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.
October 6, 2020

Could you please tell us what the searcher for the field is?

0 votes
Niranjan
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.
October 5, 2020

Hi,

What is the field type of owner? User picker? Check if there are more than one custom fields with the name "owner" and you are using the field that is associated with the project.

Shaik Moid Ahmed October 5, 2020

Hi Niranjan,

 

Thanks for replying. Owner is User Picker (single user) field and we have only one field with the name Owner. I do see the field on Screen. Even when i select the value its not getting reflected. 

Niranjan
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.
October 5, 2020

Do you see the owner field value on the issue? If so you can try a project re-index and check if that can fix the issue.

Suggest an answer

Log in or Sign up to answer