JQL fails with "Field 'field_name' is not searchable, it is only sortable" message
Platform Notice: Data Center - This article applies to Atlassian products on the Data Center platform.
Note that this knowledge base article was created for the Data Center version of the product. Data Center knowledge base articles for non-Data Center-specific features may also work for Server versions of the product, however they have not been tested. Support for Server* products ended on February 15th 2024. If you are running a Server product, you can visit the Atlassian Server end of support announcement to review your migration options.
*Except Fisheye and Crucible
Symptoms
When executing a JQL on Jira using fields as conditions, the following error is displayed:
Diagnosis
The field displayed in the error does not have a "Search Template" associated with it:
Cause
JQLs need "Search Templates" to bring results based on field values.
Resolution
1) Go to Administration (⚙ icon) > Issues > Custom fields
2) Search for the affected field, then click on ... > Edit
3) Choose an available "Search Template" for the related field, then click on "Update"
A re-index might be required to bring accurate JQL results using the field above.