How to re-order statuses

Still need help?

The Atlassian Community is here for you.

Ask the community

Platform Notice: Server and Data Center Only. This article only applies to Atlassian products on the server and data center platforms.

Symptoms

This is now available in the JIRA User Interface as of JIRA 6.3.8, as JRA-5189 - Getting issue details... STATUS has been implemented.

Before the release of JIRA 6.3.8, there was no way to change the Statuses order in JIRA.

Workaround

Always back up your data before performing any modification to the database. If possible, try your modifications on a test server.

Credit for this workaround goes to the comment contributors on JRA-5189 - Getting issue details... STATUS .

  1. Shut down 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 or Re-index JIRA to take effect.


Resolution

  • Upgrade to JIRA 6.3.8 or later, which includes the ability to re-order statuses in the user interface



Last modified on Mar 30, 2018

Was this helpful?

Yes
No
Provide feedback about this article
Powered by Confluence and Scroll Viewport.