Sort Order for Board View

[Neil Kugelman]

On my Board view, I have several columns of different categories. Currently the cards in the columns display in chronological order (I believe): Oldest on top.

I'd like to sort the cards: Newest on top (ie reversed) How can I do this?

Also, is it possible to have different sort orders for each of the columns?

I searched the community forum but I couldn't find an answer.

Thanks

Neil

[Bill Sheboy · Accepted solution]

Hi @Neil Kugelman -- Welcome to the Atlassian Community!

A Jira board is a view of the issues in the project, selected using a Jira Query Language (JQL) filter.  The board also has different Status values mapped to the columns shown on the board.

The filter usually has an ORDER BY clause to sort the issues.  Issues on the board are shown in that order, regardless of which column they are in.

Thus if your filter is something like this: 

project = myProjectName ORDER BY created ASC

The oldest ones would be first.  To switch to the newest ones first, change the query to: 

project = myProjectName ORDER BY created DESC

There is only one board filter impacting sort, and so you cannot have different orders for the different columns.

Also please note: some features of Jira only work when the filter is set to ORDER BY Rank ASC.  For example, the drag-and-drop ordering of the backlog.  When you change the sort order that feature no long works.

Kind regards,
Bill

[Neil Kugelman]

Bill

Thanks for the reply.

I didn't create this board and I don't see where I can add or edit the JQL filter. The only filters I see are fixed filters with drop-downs (Assigned to Me, Due this Week, Assignee, Issue type, Labels, Priority).

Where can I edit the JQL script?

Thanks

Neil 

[Bill Sheboy]

Let's first confirm: is this a company-managed project or a team-managed project?  You can see that information at the bottom of the left-expand area.

If this is a company-managed project, you must be a project admin to change the filter.  That can be accessed from the top right of the view, under the ... menu > board settings > general > Edit Filter Query.

[Neil Kugelman]

Bill 

I am an Admin and this is a "Team managed project". I don't see this option under the "..." menu.

Neil

[Bill Sheboy]

Thanks for that information; so the short answer is changing the order is not possible.

For team-managed projects, I do not believe it is possible yet to set a board filter.  The default is currently ORDER BY Rank ASC so that drag-and-drop prioritization works.

[Neil Kugelman]

Bill

OK. Thanks for the quick responses.

Neil 

[Gregory James]

I'm in a company managed project and the "..." menu doesn't have Edit Filter Query in it, I'm site admin.

[Bill Sheboy]

Hi @Gregory James 

From the board's ... menu, select Board Settings > General and you will find the option to edit the filter.

Kind regards,
Bill