Documentation for JIRA 6.3 EAP developer (EAP) releases only. Not using this? See below:
(JIRA 6.2.x documentation | JIRA OnDemand documentation | earlier versions of JIRA)

Skip to end of metadata
Go to start of metadata

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.

Icon

This FAQ is to document down the workaround for JRA-5198, all credit goes to the contributors in JRA-5198

Icon

Direct Database Manipulation is outside the scope of Atlassian support - this document is for informational purposes only

Warning

Icon

Please Backup Database before implementing the below workaround

The Steps

  1. Shutdown JIRA
  2. Backup Database
  3. List down the current Statuses order using query below:

  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.

  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":

  8. Restart or Re-index JIRA to take effect.
  • No labels

4 Comments

  1. Anonymous

    Will this update all other workflows being used or do we run a risk of corrupting active workflows?

  2. thanks, but I don't have administrative access to run anything like that.

  3. Is this possible for JIRA online?

  4. Anonymous

    Same question as above. Really all i want is for the issue gadget to sort in something resembling a natural way. Having "in review", "ready for test" and others mixed seemingly randomly is really frustrating.