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
警告
Please Backup Database before implementing the below workaround
The Steps
- 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
オープン
1
進行中
2
再オープン
3
解決済み
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
オープン
10
進行中
20
再オープン
30
解決済み
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.