How to order the statuses alphabetically in Jira statuses page
Platform Notice: Data Center Only - This article only applies to Atlassian products on the Data Center platform.
Note that this KB was created for the Data Center version of the product. Data Center KBs 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
Direct manipulation of the database is not supported as described in Atlassian Support Offerings, therefore Atlassian Support won't be able to assist with issues eventually caused by the steps described in this KB article; proceed at your own risk.
We recommend either using the UI to change the order of statuses, or voting for this open suggestion: JRASERVER-67549 - Sort STATUSES alphabetically
Currently ordering the statuses in the Administration - > Issues - > Statuses requires manually moving the status up and down. This becomes cumbersome when there are a large number of statuses.
Solution
The following query can be used to order the sequence of the statuses in the database. Since it is database manipulation it is highly recommended to be used at your own discretion. Issues occurring from such table data manipulation are not supported. You may want to take a backup of the table or the database before proceeding with the solution
Postgres
1
UPDATE issuestatus SET sequence = (select rnum from (select id, sequence,pname,row_number() over (order by statuscategory, pname) as rnum from issuestatus) temp where issuestatus.id = temp.id);Was this helpful?