Showing results for 
Search instead for 
Did you mean: 
Sign up Log in

It's not the same without you

Join the community to find out what other Atlassian users are discussing, debating and creating.

Atlassian Community Hero Image Collage

Sorting Kanban Backlog with Rank and Priority

Need some help or suggestion  to help sort our backlog.

We are  using a couple of different methods to manage the flow of work:

We use a Kanban board for ongoing team work

We use the Kanban Backlog (where we have over 300 tickets) (using Rank to sort)

We also use Structure to break down smaller projects and set due dates and priorities.

We were using Priority and due dates to sort the Kanban board and backlog, but it wasnt working well with tickets where we had 10 or so with the same priority. So we have moved to Rank, but that requires 100% manual intervention.

Is there any way we can sort issues by Priority, then tweak by Rank, using Structure for example, and having that Rank flow through to the Backlog?




1 answer

1 vote
Fazila Ashraf Community Leader Mar 25, 2018

Hi @Tanya Fraser

Could you modify you board's filter and update the ORDER BY clause as below?:

ORDER BY priority , Rank ASC

That would list the tickets in kanban board to be ordered by priority first and then with the 'RANK' value.

However, modifying the query as above will disable 'Ranking' in the board. You will not be able to arrange the rank inside the board by drag drop.


thank you for your response. It doesnt work for us - we need to be able to rank.

We use the Kanban boards for ongoing work for a team of 10, so there is constantly work created and in progress and being resolved. A revolving board. 

We want to be able to go in and rank, ideally without newly created tickets ending at the bottom of a list of 300 in the backlog. 

I understand that ranking doesn't work the way we need it to (be able to rank amongst a priority setting), but am hoping that someone has discovered a workaround!

Fazila Ashraf Community Leader Mar 25, 2018

oh ok.. i thought you were ok to do the ranking in the structure board rather than in the kanban board and hence the above suggestion..

Suggest an answer

Log in or Sign up to answer
Community showcase
Published in Jira Software

How to create Jira issus from Excel file?

When to use CSV importer When managing your processes in Jira, there are many occasions where you need to create a lot of tasks. Creating them one by one will cost you a lot of time and effort and i...

4,431 views 22 32
Read article

Community Events

Connect with like-minded Atlassian users at free events near you!

Find an event

Connect with like-minded Atlassian users at free events near you!

Unfortunately there are no Community Events near you at the moment.

Host an event

You're one step closer to meeting fellow Atlassian users at your local event. Learn more about Community Events

Events near you