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 credits 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 implement 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 JIRA to take effect.