Documentation for JIRA 4.4. Documentation for other versions of JIRA is available too.

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

  1. Shutdown 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

    Open

    1

    In Progress

    2

    Reopened

    3

    Resolved

    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

    Open

    10

    In Progress

    20

    Reopened

    30

    Resolved

    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.
  • No labels



See our Getting Help page for details.



Raise an issue for our developers.



See answers from the community.



Tweet, blog and update our documentation.

Except where otherwise noted, content in this space is licensed under a Creative Commons Attribution 2.5 Australia License.