How do I group Jira search results in order?

Question

I've got a search that returns a list of issues and I would like to sort them by their status (open, blocked, done) and by their date.  I've tried 'order by status" but that results in an alpha search where i'd like the order controlled to be open, blocked, done.

Thanks!

Payne · Answer

Hi Alan,

This answer pertains to Jira Server; I assume it's the same for Cloud, but it may not be.

Statuses sort by the order in which they appear on the statuses page - https://<JIRA_DOMAIN>/secure/admin/ViewStatuses.jspa

They can be rearranged (painfully, one position at a time), by clicking the up/down arrows.

Mike Rathwell · Answer

Ah yes, @Alan Laird  you have come up hard against the old "JQL isn't "SQL" thing here. I've not yet found a good way to do this in Jira (and hopefully a helpful reader here can point BOTH of us along that way).

What I've done, for reporting purposes, is actually display these in Confluence by using a Jira macro embedded in the Table Filter and Charts macro, then did a pivot on the values I wanted grouped together (in your case, open, blocked, and done). Not optimal but does get there after a fashion.