Forums

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

jql query returns wrong issues,anything i am doing wrong here?

Deleted user September 2, 2021

1-> query for cf[<your-custom-field>]~[xxxxxx] returns correct Issues in jql
2-> I add  custom field value  xxxxxx to a random ticket , then remove it ( for eg. <project-Name>-2732)
3-> Now i run query for searching  xxxxx , issues returned also include <project-Name>-2732 which has <your-custom-field> as None.

1 answer

1 accepted

1 vote
Answer accepted
Bill Sheboy
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.
September 2, 2021

Hi @[deleted] -- Welcome to the Atlassian Community!

Would you please post your exact JQL you are using?

I note some inconsistencies in your question and so seeing the exact JQL may provide more context for the community to offer you suggestions.  Thanks!

Kind regards,
Bill

Deleted user September 2, 2021

hey @Bill Sheboy, thanks for the reply.

https://<jira-Instance>.atlassian.net/rest/api/latest/search?jql=cf[11773]~PE31 , this is the rest api i am hitting , and i hit the above jql(cf[<your-custom-field>]~[xxxxxx]) in advanced issue search in Filters tab in jira . 

Bill Sheboy
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.
September 2, 2021

Thanks for that information!

What is the type of your custom field, as I believe that operator only works for text fields?
https://support.atlassian.com/jira-software-cloud/docs/advanced-search-reference-jql-operators/#Advancedsearchingoperatorsreference-CONTAINS-CONTAINS--

You may also be encountering one of these defects:

Deleted user September 2, 2021

Thanks @Bill Sheboy , i am currently encountering the same issue 74027 but on single line text fields.

Bill Sheboy
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.
September 3, 2021

As the symptom you see is for a single line text field (rather than multiline), you may want to consider submitting a defect to Atlassian for investigation.  If you are on a paid license for Jira your site admin can submit a ticket here: https://support.atlassian.com/contact/#/

Suggest an answer

Log in or Sign up to answer
DEPLOYMENT TYPE
CLOUD
TAGS
AUG Leaders

Atlassian Community Events