Unable to order statuses

[Megan Marquardt]

We have ~200 statuses, and I'd like to group together the status categories and ensure that To Do category is ordered before In Progress which is ordered before Done.

I'm using the up/down arrows on the Statuses admin configuration page (`/secure/admin/ViewStatuses.jspa`), and they are not working. I will click the up arrow for a status and it won't move the order. This seems to work for some status and not for others.

My use case is looking at tickets in a filter view, and wanting to sort by Status. We have these following statuses: Pending, To Do, In Progress, In Review, In QA, Resolved. Those statuses are in the status categories To Do, To Do, In Progress, In Progress, In Progress, Done respectively. I'd like to see ticket in the order I listed, but instead they are appearing in the order of In Progress, In QA, Resolved, In Review, To Do. This is not helpful for project managing a complex efforts with many workstreams and dependencies.

[John Funk]

Hi Megan - Welcome to the Atlassian Community!

Try modifying your filter to add:

ORDER BY statusCategory ASC

[Megan Marquardt]

Thank you John, that will certainly help. I now have ordering as follows:

`statusCategory ASC, status ASC` 

So all the status categories are grouped.

This doesn't solve my issue of ordering the statuses and the up/down not working. Now the statuses within the "In Progress" category are scattered. This order is To Do, In Progress, In QA, In Review, Resolved. In Review still needs to come before In QA.

[John Funk]

All ordering is alphabetically. So you could do what you did, but you can't control the order of the statues in the second sort except by changing the names of the statuses so that you could sort asc or desc alphabetically. 

Also, as soon as you do an order by other than Rank, then you lose the ability to move cads up and down to reorder. 

In general, sorting is very limited that way.