JQL Search Query is not displaying ASC/DESC order properly on custom field
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
Summary
When searching for custom field number values in ascending order, the sorting appears incorrect.
Environment
Jira Software Data Center on 8.0.0 and any higher version.
Cause
The Search Template value for the affected "Number Field" type custom field is set to "Free text searcher":
Solution
1. Go to ⚙ > Issues > Custom fields.
2. Find the respective field and Edit.
3. Set the Search Template value to Number Searcher if it is a "Number Field" type custom field.
