How to order the statuses alphabetically in Jira statuses page
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-67549Getting issue details... STATUS
Summary
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
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);