Custom 'ORDER BY' status in JIRA

jira jql
lovestocodez picture lovestocodez · Nov 20, 2015 · Viewed 10.7k times · Source

Hi I have the following query for my filter:

project = BOARD AND status in (Backlog, New, Design, Dev, "Sign Off", Blocked) ORDER BY status ASC

I have my board and am stating what statuses it should display and I though it would display it that way when I order it. But instead it orders it by "Backlog, New, Blocked, Design, Sign Off, Dev). Which is wrong, it should be ordering by Backlog, New, Design, Dev, Sign Off, Blocked.

I've scoured their documentaiton and it says the the GUI option for this was added in 6.0, but I don't see it? The only other way i saw was to do it on the backend? Thoughts?

Answer

JamieB picture JamieB · Nov 20, 2015

Ordering by status should order the results in the order of status as defined in Administration > Issues > Statuses. You can re-order the statuses from that admin page.

The statuses admin page can be found at;

https://$JIRA_URL/secure/admin/ViewStatuses.jspa

Related questions

JIRA JQL searching by date - is there a way of getting Today() (Date) instead of Now() (DateTime)

I am trying to create some Issue Filters in JIRA based on CreateDate. The only date/time function I can find is Now() and searches relative to that, i.e. "-1d", "-4d" etc. The only problem with this …

Read More
JIRA: Searching for all issues with a given link type

Is there a way to query for all issues with a particular link type? For example, let there be a dependency link where an issue can "depends on" another issue. Is there a query to find all issues that depend …

Read More
How do I query Jira to search for all issues that have been resolved within a length of time from when it was created?

For example, let's say I need to find all issues that were resolved within 1 week's time. I need something like: resolved - created < '1w' Another example: Let's say I have 3 issues: 1) created 2 days ago, resolved 1 day ago. 2) created 5 …

Read More