How to re-order statuses
There is currently no way to change Statuses order in JIRA, the only workaround is to manipulate JIRA database, please follow JRA-5198 and vote on this feature.
This FAQ is to document down the workaround for JRA-5198, all credit goes to the contributors in JRA-5198
Direct Database Manipulation is outside the scope of Atlassian support - this document is for informational purposes only
Warning
Please Backup Database before implementing the below workaround
The Steps
- Shutdown JIRA
- Backup Database
List down the current Statuses order using query below:
SELECT pname,SEQUENCE FROM issuestatus order by SEQUENCE;You will get result like below:
pname
SEQUENCE
Open
1
In Progress
2
Reopened
3
Resolved
4
Closed
5
Update the current status sequence numbers to 10, 20, 30 instead of 1,2,3 so it's easier to modify later.
update issuestatus set SEQUENCE =10 where SEQUENCE='1';Repeat step above for other statuses, you will get result like below:
pname
SEQUENCE
Open
10
In Progress
20
Reopened
30
Resolved
40
Closed
50
Finally, Update the table with the sequence you want, for example change Status "Reopened" show after status "Resolved":
update issuestatus set SEQUENCE =45 where pname="Reopened";- Restart or Re-index JIRA to take effect.