How to sort backlog by created or update date descending

[Kris]

I want to sort the backlog so the latest issues are up top. I've read several answers here and I've tried adding my own filter queries like

ORDER BY updatedDate DESC

ORDER BY createdDate DESC

but these do not have any effect.

How do I achieve this? It would really make the backlog a lot more functional for me.

[Trudy Claspill]

Hello @Kris 

Welcome to the Atlassian community.

Those don't work because createdDate and updatedDate are not valid fields. The field names are created and updated.

However if you change the board filter to order by anything other than Rank then you will not be able to drag-and-drop the issues to reorder them.

[Kris]

Thank you for your reply.

The fields are valid according to the documentation, they are aliases for created/updated: https://support.atlassian.com/jira-service-management-cloud/docs/jql-fields/

Either way I did also try created/updated already and they didn't work either.

I don't mind being unable to reorder the issues in the backlog. Right now it looks like they are sorted by created date ascending and I would like to reverse that, disabling the ability to have a custom order is fine.

[Trudy Claspill]

Hello @Kris 

What type of project are you using? Get the project information from the Type column on the View All Projects page under the Projects menu.

Are you changing the Filter that the board uses to select issues, or are you creating a Quick/Custom Filter for the board?

What is the evidence that the filter is not working? Can you provide a screen image and add notes to it to indicate the date for each issue for the field you are trying to use for sorting?

[Kris]

Thank you for your reply.

Project type is "Team-managed software".

I'm using a "custom filter" that I saved and then apply by clicking the checkbox.

The field I want to use (created/createdDate) does not appear in the view. I want to have this sorting on the "backlog" view, not the "issues" view.

The "issues" view has customizable fields and there I can sort it by date created. But I would like to keep using the "backlog" view for other reasons (the backlog groups tickets by board/backlog and the performance of the "backlog" view is good, while the performance when scrolling on the "issues" view is really not good).

The evidence I have is that the order of tickets never changes. The filter system on the backlog view seems unable to apply the ORDER BY statement. I have not marked anything on the screenshot since the field does not appear there like I said, but you can see the filter I saved, where I applied the queries mentioned in the OP.

[Trudy Claspill]

Hello Kris,

Thank you for that additional information.

Custom Filters cannot be used to change the ordering of the issues. Custom filters are used only to reduce the issues that are displayed to the subset of total issues available for display in the board.

The underlying board Filter dictates the sort order of the issues.

Unfortunately for Team Managed projects it is not possible to change the underlying board Filter. That filter is hard-coded to order the issues by Rank. You will not be able to change that for the Board or Backlog views.

[Trudy Claspill]

Hello @Kris 

Did my response provide you with an answer to your questions? If so, please consider clicking on the Accept Answer button to mark your Question as Solved.