nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

'ORDER BY status DESC' Is there any other ways of ordering in JQL?

Nannaakan

Hi,

I wanted to order a column. I know I can use DESC or ASC, but is there any other way to order. Can I give my own preference in ordering:

Eg. Order like --> Status --> First Done, Second - In Testing, Third - Rejected etc.

I am trying to match SQL query similar to this but could not. Do you have a guide or ability for this in JQL.

Accepted answers

Sam Hall_h1otcf

Your only option in JQL is to order status by DESC or ASC. There is information on using the 'ORDER BY' keyword here.

However, you can set the order of the statuses will be listed using the Statuses admin page, which can be found via Administration > Issues > Statuses. The URL to get there will be:

https://<YOUR_JIRA_URL>/secure/admin/ViewStatuses.jspa

On this screen you can use the little arrows to change the order of the statuses:

This will change the order they show in on the search screen.

For example, if you move "Done" to the top on the Statuses admin page, it will show first on the search screen when you do JQL like:

order by status ASC

Hope this helps a bit.

Sam

status-order.jpg

All comments

Sam Hall_h1otcf

Your only option in JQL is to order status by DESC or ASC. There is information on using the 'ORDER BY' keyword here.

However, you can set the order of the statuses will be listed using the Statuses admin page, which can be found via Administration > Issues > Statuses. The URL to get there will be:

https://<YOUR_JIRA_URL>/secure/admin/ViewStatuses.jspa

On this screen you can use the little arrows to change the order of the statuses:

This will change the order they show in on the search screen.

For example, if you move "Done" to the top on the Statuses admin page, it will show first on the search screen when you do JQL like:

order by status ASC

Hope this helps a bit.

Sam

status-order.jpg

Rosa M Fossi

Thanks Sam Hall!

Question: Is there no other way to update those? What if you have 54 statuses, and you need to move #38 to #1?
Do I really have to click the up arrow 37 times and wait for the page to reload each time?

Nic Brough -Adaptavist-

In later versions, you can drag the dotted metal panel into the right place, rather than have to click 37 times, although you're still going to get a page refresh on each move.

Rosa M Fossi

Hi Nic, as far as version, we are JIRA cloud. I also found out if I press the up-arrow 6-8 times, it registers most of those clicks and moves up 6-8 slots. That made it a little more bearable, but I still spent over an hour moving statuses around.

unknown

Hello Sam Hall,

Thanks for the above answer. We have lots of projects in our JIRA self-hosted instance and the same statuses used by multiple projects/workflows. If I do the above changes for one project, will it impact to others or is there any other way to make the changes for a specific project.

Sam Hall_h1otcf

HI Bishnu - the status order in the configuration page is global. The order you pick there will apply to JQL search results regardless of project.

Martin Cleaver

And you can't order by StatusCategory, which would also have been useful

Usamah zagaar

Yes, exactly, are these Jira creators are using their product? You would think these features would be included out of the box. Very Strange and not well thought out. And where are the JIRA support team responding to this question/feature? Let me guess, ignore loyal customers and see who votes on the most wanted new feature. Unacceptable support model for new features. These common-sense types of features should be out of the box not voted on by users to be included in the future releases.

Welcome!

It looks like you're new here. Sign in or register to get started.

Quick Links

Find more posts tagged with

jira

cloud

jira-cloud

jira-core