Sorting by status not working properly on a JQL Query

[Benjamin Rosen]

Hi,

I have a JIRA board where issues progress from In Review, Second Review, to Done. I also have a confluence table which shows all of these issues, with several columns including description and status.

I used JQL to sort this table "order by status ASC". This command is not working unfortunately. The issues are showing up in the order In review, Done, Second Review - instead of, In Review, Second Review, Done. Any idea why this could be happening? 

Thanks,

Ben 

[Brant Schroeder]

Benjamin,  

Unfortunately it is working correctly.  The sorting that is occurring is correct and has to do with how the statuses are ordered (sorted) within JIRA.  You will need to check the status order in JIRA and arrange it in the proper format in order to get it to display correctly in your JQL.  You can see the order and change it in JIRA by going to ADMIN (Gear in the upper right hand corner) > Issues > Statues.

[Yash Ruparel]

@Brant Schroeder - thank-you this was helpful!

[Yash Ruparel]

once we make the chances, it auto saves and updates?