JQL Advanced Filter for Priority and Duedate within a swimlane

Question

I am trying to do a filter query to show all issues ordered by priority and DueDate, however when I use this JQL

project = xy_Team AND component = Automation OR project = xz ORDER BY priority, duedate

It doesn't seem to work and will mixup the ranking of the swimlanes as well.

Within the Swimlane, the ranking of duedates and protists is also partly wrong. The time-critical due date is further down, e.g. 30.03.2022 is before 15.03.2022.

Thanks for assistance

Kari · Answer

Hi Redek,

thanks for your assistance. In the meantime i could handle the order with DESC.

Regarding the swimlane I still have an issue. The order of the swimale is changing after using the JQL code.

Do you have an idea for this as well?

Best,

Kari

Radek Dostál · Answer

The time-critical due date is further down, e.g. 30.03.2022 is before 15.03.2022.

That is expected. ORDER BY is descending by default (well depends on fields, but dates are generally desc, text fields asc). You could try 'ORDER BY priority, duedate ASC' to make it sort in ascending order.