Issue with the Quick Filters in board

[Mierzejewski Marcin]

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!

[Ashish Bijlwan · Accepted solution]

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

[Utkarsh Agarwal · Accepted solution]

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:

1. 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
   
   

2. 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.

[Mierzejewski Marcin]

Do you know of any Jira plugins to help me resolve this issue?

[Mierzejewski Marcin]

@Ashish Bijlwan @Utkarsh Agarwal 
Thank you for your responses. I was unaware of the limitations of Jira. I need to consider what changes are necessary.