nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Want my Kanban Board Issues sorted by due date per Column

Rich Winterstetter

Hi all,

I have a small problem and don't want to annoy support as I feel it is probably a lack of understanding on my part, so maybe you guys can help me out.

I want to display my tasks in the Kanban Board ranked by due date (meaning, the one with the most recent due date is on top etc.) for every column.

I already tried a quick filter "ORDER BY duedate ASC" which does precisely nothing and a separate Swimlane "ORDER BY duedate ASC" which also does not rearrange the tasks.

However the quick filter "type = "all" ORDER BY duedate ASC" ranks the tasks in the desired order, but only shows tasks of a certain task-type while leaving out all other task types.

We're running a Jira Cloud version if that is important for you guys.

Anyone who can help me? I'd appreciate it a lot! Thanks in Advance

Accepted answers

Andy Heinzer

Jira Software boards are governed by the board filter. This determines what issues appear and in what order.

By default Jira Software will try to always use the Rank field as a means to order these. At the moment you can't technically rank issues by another field other than a rank type field.

BUT, you can order the issues on the board to be displayed by another field. To do this, you would need to either edit the existing board's filter, or it might be easier to first create a new filter (such as just "Order by due date asc", then save this filter), and then create a new board based on that saved jql filter.

The major thing to note about doing this:

You won't be able to order the issues by their Rank, nor can you change the rank of issues just by dragging/dropping them on the backlog or active view. And you won't be able to change the Due Date just by dragging and dropping the issues.

But you can still execute transitions by dragging/dropping the issues into other columns, just as you would on a board using the rank field to order the issues.

This might not be the functionality you are looking for. If you were wanting to be able to change the Due date value just by dragging and dropping, like you would with rank on a rank ordered board, I don't think this is going to work. With a field type like date, there are many possible values and you probably want it to be an explicit date. Whereas the Rank field has a value, but the end user almost never needs to know what that actual value is. Since ranking in Jira can change that value during a rebalance, it's value is really only important in relation to other issues rank values.

Is this helpful? not helpful? Tell us more about your use case. Maybe we can find an alternative solution here.

All comments

Andy Heinzer

Jira Software boards are governed by the board filter. This determines what issues appear and in what order.

By default Jira Software will try to always use the Rank field as a means to order these. At the moment you can't technically rank issues by another field other than a rank type field.

The major thing to note about doing this:

But you can still execute transitions by dragging/dropping the issues into other columns, just as you would on a board using the rank field to order the issues.

Is this helpful? not helpful? Tell us more about your use case. Maybe we can find an alternative solution here.

Rich Winterstetter

Thanks, that helps me out a lot.

Andy Heinzer

Cool, glad to hear that helps. Let me know if you have any follow up concerns. If this answer solved your issue, please click the checkmark to the left of my answer to accept this answer.

Rhian Parker-Wicks

Hi @Andy Heinzer , I was wondering if you would be able to confirm the JQL code for this due date filter of epics, stories and sub tasks please? Many Thanks, Rhi

Connor Gamble

Hi @Andy Heinzer

I've changed my board to be ordered by due date as per the above, how do I then go about changing the filter to have the columns sorted by priority as a secondary step?

At the moment they're ordered like this:

Due Date: 25th October, Priority: Medium
Due Date: 25th October, Priority: Low
Due Date: 25th October, Priority: High

I would like them like this:

Due Date: 25th October, Priority: High
Due Date: 25th October, Priority: Medium
Due Date: 25th October, Priority: Low

Cheers,

Connor

Andy Heinzer

Hi Connor,

I think I understand what you are looking for here. In the previous examples the JQL filter is setup to use something like this:

project = XYZ AND status = Done ORDER BY DueDate DESC

But in your case, I believe that you would need to add an additional order by element, like this:

project = XYZ AND status = Done ORDER BY DueDate DESC, priority ASC

This should first sort the issues by duedate first, and then by priority in the manner you have described here.

I hope this helps.

Andy

Connor Gamble

Hi Andy,

That's exactly what I was looking for, thank you!

Connor

Tijs Tijert

Ok... we're slowly getting to some nifty sorting schemes. Now I would like to know if it is also possible to sort two status columns in different ways. So... status column done to be sorted based on date of completion but the column status = In Progress based on Priority. Can I do this in one filter or would I need to write a new filter for every status?

Tijs Tijert

Why nonsense?

I am giving my team tasks. The tasks have a duedate and a priority.
When the tasks are "In Progress" or "Not started yet" I want them to be ordered based on priority in my kanban board. But when the task is "Done" and subsequently moves to the last column in my Kanban board I want them there to be sorted based on Date of completion.
That way mt team will likely start higher priorit tasks first and I can check completed tasks based on the order in the last column.

Not possible?

Nic Brough -Adaptavist-

Why nonsense? Because it does not make any sense in the real world. Again, could you show me a list of the first five numbers from 0 that is in both alphabetic and numeric order? Please tell me how to do that and make sense?

If you want to look at a list in two different orders, that's not a problem, but you will need two separate views - the same question, but with two different "order by" rules in the two saved searches.

A board works off one single search (it's supposed to be consistent), so you will need two boards to support the different views you want.

Steve Smith_8f6f2p

I don't think this is "nonsense" either. I need this for the same reasons as stated by others. Backlog by priority, completed by date. What JIRA needs is Kanban templates instead of having to write complex queries. Data goes into the table, first it is sorted by column, then objects in each column are sorted by the user selected field. This is how it should work, and how most other software works when tables are created. Just because it wasn't built this way doesn't make the request stupid, it's means the software wasn't design to meet these user needs that's all. By the way, please address this, it's the natural way of working for teams.

Markus_COGNITIFF

This issue has existed for years. Take a look this plugin - I think it should do what you need - https://marketplace.atlassian.com/1221621

Full disclaimer, I represent the company behind the plugin.

Andy Heinzer

Hi @Markus_COGNITIFF

Thanks for your answer here.

However please review our Community guidelines for Marketplace vendors. While all the points of that guide are important to follow, your previous answer here specifically does not identify yourself as having a relationship with the vendor of the plugin you are recommending here. We request that you identify yourself as a partner, particularly when you are recommending your own product as a potential solution.

Cheers,

Andy

Welcome!

It looks like you're new here. Sign in or register to get started.

Quick Links

Find more posts tagged with

jira

jira-software

jira-cloud

kanban

quick-filter