Issue with the Quick Filters in board

Question

Hi, I am experiencing a problem with using quick filters in my board.

The main JQL filter query does not include an ordering, for example:  "project = AAA AND status != Closed AND 'Supported Project' in (CCC, DDD) AND team = TEST"

I apply ordering in my quick filters, such as "issuetype = 'FFF' ORDER BY duedate ASC"

However, when I select this filter in my board, the ordering does not work correctly.

Thank you for your help!

Utkarsh Agarwal · Accepted Answer

Hi,

The issue you're encountering is a common limitation of Jira boards. When using quick filters, Jira appends the quick filter query to the main board filter, but it does not allow multiple ORDER BY clauses. Only the ordering defined in the main board filter query is applied.

To fix this, you'll need to move the ordering logic to the main board filter query since that's the only way to control the issue ordering on the board. Here's how you can do it:

* Edit your main board filter query to include the ordering: 
project = AAA AND status != Closed AND 'Supported Project' in (CCC, DDD) AND team = TEST ORDER BY duedate ASC

* Update your quick filter to remove the ORDER BY clause and focus only on filtering the issues:
issuetype = 'FFF'

Unfortunately, Jira doesn't support different ORDER BY clauses per quick filter, so the main filter's ordering will always apply to the board. If you need different ordering for specific views, you'll need to explore other approaches like separate boards or dashboards.

I hope this helps! Let me know if you need further clarification.

Ashish Bijlwan_zogaqs · Accepted Answer

Hi @Mierzejewski Marcin

Welcome to Atlassian Community!

As of now, ORDER BY clause used in a quick filter query doesn't work because the board's saved filter decides the ordering of issues. Quick filters are used to filter subsets of the matching issues, the order clause is not relevant because the issues have already been selected and ordered.

Thank you,
Ashish