Forums

Articles
Create
cancel
Showing results for 
Search instead for 
Did you mean: 

JQL Advanced Filter for Priority and Duedate within a swimlane

Kari
Contributor
February 25, 2022

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 

1 answer

0 votes
Radek Dostál
Rising Star
Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Leaders.
February 25, 2022

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.

Kari
Contributor
March 2, 2022

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 

Suggest an answer

Log in or Sign up to answer