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.

The Steps

1. Jira をシャットダウンします。
2. Backup Database
3. List down the current Statuses order using query below:

   SELECT pname,SEQUENCE FROM issuestatus order by SEQUENCE;
   

4. You will get result like below:

   pname	SEQUENCE
   オープン	1
   進行中	2
   再オープン	3
   解決済み	4
   Closed	5

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;
   

6. Repeat step above for other statuses, you will get result like below:

   pname	SEQUENCE
   オープン	10
   進行中	20
   再オープン	30
   解決済み	40
   Closed	50

7. 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";
   

8. Restart JIRA to take effect.