Sort order of issues in Backlog view

leewarren June 29, 2021

When viewing issues in the Backlog view, how do I change the sort order of shown issues? It seems like a silly question, but why not just have a grid header that lets me click and sort?

image_2021-06-29_134807.png

3 answers

2 accepted

2 votes
Answer accepted
Trudy Claspill
Community Leader
Community Leader
Community Leaders are connectors, ambassadors, and mentors. On the online community, they serve as thought leaders, product experts, and moderators.
June 29, 2021

Typically the sort order for the issues is by Rank and this is incorporated into the filter on which your board is displayed.

With sorting/ordering based on Rank you have the ability to drag and drop to re-order the issues, with the assumption that things that are "higher" in the list should be done before things that are "lower" in the list.

You cannot dynamically change the sort order of the issue on the board and change between different orderings through any button type feature on the board.

To change the ordering of issues, you need to change the ORDER BY clause in the board's filter.

Note if you change it to something other than Rank, you will no longer be able to drag and drop your issue to re-order them.

 

So, why do you want to change the sorting order of the issues? What problem are you trying to solve?

leewarren June 29, 2021

It seems quite obvious because this is an excepted pattern in most software, but let me explain: The user would want to sort for many reasons, to see which issues they created in chronologic order, to find related items that would show up if sorted alphabetically, to sort by priority (sometimes), to add another column and sort by something else.

Compounding this, when I do try moving stuff around, I get an error.image_2021-06-29_140916.png

Trudy Claspill
Community Leader
Community Leader
Community Leaders are connectors, ambassadors, and mentors. On the online community, they serve as thought leaders, product experts, and moderators.
June 29, 2021

The error you are getting is indicative that you have either specified some other ORDER BY clause in your board filter, which prohibits your ability to drag and drop to reprioritize issues by Rank, or your board filter has no ORDER BY clause and you have also not enabled the RANK option for the board.

To review these items, go to the Board settings (the ... button for the board) and go to the General screen. Here you will see the filter used by the board and whether or not Rank is enabled.

leewarren June 29, 2021

I fixed that, but now JIRA is not letting me move things at all, just highlight text and opening issues when I click on them.

Trudy Claspill
Community Leader
Community Leader
Community Leaders are connectors, ambassadors, and mentors. On the online community, they serve as thought leaders, product experts, and moderators.
June 29, 2021

Sorry, hit the Reply button too quickly...

I meant to paste this image

Screen Shot 2021-06-29 at 11.17.54 AM.png

 

Additionally, in Jira the Backlog screen is for relative prioritization of your work. If your users want to see the same data but sorted in other ways, they will need to do that through the Issue Search screen where they can create filters with the ORDER BY clauses of their choice.

You can incorporate Quick Filters into the board which would give you the ability to limit the display to a subset of the issues, but that does not give you the ability to change the sort order.

Like # people like this
0 votes
Answer accepted
Jack Brickey
Community Leader
Community Leader
Community Leaders are connectors, ambassadors, and mentors. On the online community, they serve as thought leaders, product experts, and moderators.
June 29, 2021

Unlike the results of an Advanced search where you get an ‘excel-like’ table presentation, the Backlog view does not present a sortable list by column heading. As Trudy points out sorting is done by “Order by” within the underlying filter. If you use Order by Rank then you can drag and drop issues within the list which evokes lexoranking of the issues.

leewarren June 29, 2021

Well, you and Trudy did answer my question, so I gratefully accept. Though the underlying design decision irks me a bit, because it makes the user experience more constrained IMHO in favor of a more abstract model that leaves users at one-click dead ends, rather than a more permissive one.

Like # people like this
Jack Brickey
Community Leader
Community Leader
Community Leaders are connectors, ambassadors, and mentors. On the online community, they serve as thought leaders, product experts, and moderators.
June 29, 2021

I don’t disagree here at all and see value in your ideas. I recommend using the feedback feature to let Atlassian know. Having said that I fully expect there are suggestions in Jira.Atlassian.com on this.

Andrew Busuttil
I'm New Here
I'm New Here
Those new to the Atlassian Community have posted less than three times. Give them a warm welcome!
February 22, 2022

Just ridiculous. To do something simple like sort based on create list for backlog is almost impossible. I find so many things frustrating with the usability of this software it drives me to distraction! 

Like # people like this
bladerunner2020
I'm New Here
I'm New Here
Those new to the Atlassian Community have posted less than three times. Give them a warm welcome!
October 17, 2022

In our case, when one person adds an issue it goes to top of backlog, while when another person adds an issue it goes to bottom. That drives me crazy...

Daniel Miller February 3, 2023

So a new ticket was added today to the backlog, and I need to find it. I didn't know what the exact title or priority is, but assumed it would be a 5-second operation to "sort by issue number". Instead I have to edit a filter??? Cmon guys, click the column header to sort is pretty much a universal standard, and it is embarrassing that we have to plaintively beg for months to get this implemented.

Like # people like this
Jack Brickey
Community Leader
Community Leader
Community Leaders are connectors, ambassadors, and mentors. On the online community, they serve as thought leaders, product experts, and moderators.
February 4, 2023

Hi @Daniel Miller , the backlog is typically used with Rank sorting for planning sprints. Depending on your project type you will be able to use List (business) or Issues (software) in the sidebar for sorting by columns. FWIW, new issues added to the backlog should appear at the bottom.

Daniel Miller February 6, 2023

OK, the "Issues" link on the left sidebar brings me to another interface that lets me sort by any field, including "Created" (date). I'd prefer the ability to sort (and maybe hide/view and reorder the columns) on the Backlog screen, as it provides a convenient way to quickly browse a large number of issues. But the workaround will serve, so thanks for the response.

In our group, priorities tend to shift around quite a bit given resource availability and feature demand (we build internal tools and need to provide a quick turnaround). So an Excel-like display would be the preferred GUI to locate the relevant issues (at least for me).

Thanks!

Like Jamie Specht likes this
Henry Staples November 8, 2023

Yeah, the nice things about the queries in Jira is the URL availability. We have a page of common queries (By ID, Desc), (by Priority, Open), etc. we run and then use the Backlog view for dragging items around during a Sprint (Iteration).

However ... I'd really like to occasionally sort the backlog by SubjectSummary. But that means changing the view which then means affecting how we use Ranking in the Sprints ... so what I am considering is writing something that would create an open issue view that sorts by subject and, then, possibly somehow setting the Rank from low to high as we go down the list. what would be the best way to do that? 

Trudy Claspill
Community Leader
Community Leader
Community Leaders are connectors, ambassadors, and mentors. On the online community, they serve as thought leaders, product experts, and moderators.
November 8, 2023

Hello @Henry Staples 

Can you clarify what you mean by "somehow setting the Rank"?

The Rank field contains an alphanumeric code set by Jira that only Jira can interpret to determine the relative rank of an issue. It is not possible for a person to directly set the value of the field to change the rank of an issue.

If you want a person to be able to set a rank-like value for each issue, you would need to add a custom field for that. And if you then use that in the ORDER BY clause of your board's filter, you will no longer be able to drag-and-drop issues within that specific board to change their Rank.

Like Danise Alano-Martin likes this
Henry Staples November 8, 2023

@Trudy Claspill 

Let's say my backlog has items ranked as 

App2: Section1: User would like to sort
App2: Section2: Add delete functionality
App1: Section1: Timeout is short

What I would like is, occasionally, re-sort the entire thing via Summary alphabetically so in the Backlog they're

App1: Section1: Timeout is short
App2: Section1: User would like to sort
App2: Section2: Add delete functionality

Then, we just go through the whole list and "Move to Top" of backlog some items of interest. Once we're done setting a Sprint, I just want whatever got done to the ranking in the Backlog to return to the alphabetically sorted default. I feel like it's some sort of batch thing that I would just need to run occasionally. 

Henry Staples November 8, 2023

"Re-sort Backlog by Summary ASC" ... "and doing that would change the Rankings so Ranking could be used moving forwards. It's an easy way to cleanup after we've had a planning session.

Trudy Claspill
Community Leader
Community Leader
Community Leaders are connectors, ambassadors, and mentors. On the online community, they serve as thought leaders, product experts, and moderators.
November 8, 2023

@Henry Staples 

I found a change request in Atlassian's backlog about this:

https://jira.atlassian.com/browse/JSWCLOUD-692

Henry Staples November 8, 2023

Yes, that captures it well enough. Oh, well, will look to other means for now. I added a comment over there. Thx.

0 votes
Monica Oliveira October 11, 2022

Tenho o mesmo problema relatado.

E lendo as respostas, não encontro a opção informada "...Para alterar a ordem das pendências, você precisa alterar a cláusula ORDER BY no filtro do quadro....".

Trudy Claspill
Community Leader
Community Leader
Community Leaders are connectors, ambassadors, and mentors. On the online community, they serve as thought leaders, product experts, and moderators.
October 11, 2022

Olá @Monica Oliveira ,

Bem-vindo à comunidade.

Você está trabalhando com um projeto gerenciado pela empresa ou um projeto gerenciado por equipe? Ele dirá na parte inferior do painel de navegação à esquerda.

A opção de alterar a ordem de classificação no filtro usado pelo quadro está disponível apenas com um projeto gerenciado pela empresa. Esta opção não está disponível para quadros anexados a projetos gerenciados por equipe.

Além disso, você deve ter permissões suficientes para modificar o filtro.

Monica Oliveira October 11, 2022

Obrigada pela prontidão.

Veja abaixo a imagem:

Sem título.png

 

O Backlog não tem ordem entendível.

Desejamos deixar na ordem decrescente de ticket.

Monica Oliveira October 11, 2022

Vi agora que é um projeto gerenciado por uma equipe.

Isto quer dizer que não tenho esta opção: "A opção de alterar a ordem de classificação no filtro usado pelo quadro"

Trudy Claspill
Community Leader
Community Leader
Community Leaders are connectors, ambassadors, and mentors. On the online community, they serve as thought leaders, product experts, and moderators.
October 11, 2022

Correto. Você não pode alterar o filtro do tabuleiro, então a ordem é por Rank. Você altera a ordem dos problemas na tela arrastando e soltando-os em diferentes posições na lista.

Para o benefício de outras pessoas que estão vendo esta postagem, observe que uma nova pergunta foi iniciada pelo pôster e está recebendo respostas aqui:

https://community.atlassian.com/t5/Jira-Software-questions/Backlog-order/qaq-p/2159505

Monica Oliveira October 11, 2022

Sim, isto quer dizer que, preciso ajustar os 176 itens do backlog na mão.

E a cada novo item que insiro, devo imediatamente mover para cima, senão fica no fim do backlog.

 

Farei isto, porque o que não tem remédio, remediado está.

Entretanto a funcionalidade de ordenar o backlog e o quadro seria providencial.

Suggest an answer

Log in or Sign up to answer
DEPLOYMENT TYPE
CLOUD
PRODUCT PLAN
FREE
PERMISSIONS LEVEL
Site Admin
TAGS
AUG Leaders

Atlassian Community Events