mattermost-community / focalboard

Focalboard is an open source, self-hosted alternative to Trello, Notion, and Asana.
https://www.focalboard.com
Other
22.08k stars 1.99k forks source link

Feature Idea: Support compound filter statements #1631

Open chenilim opened 3 years ago

chenilim commented 3 years ago

Summary

There are cases when compound filters are useful, mainly to handle OR clauses.

How important this is to me and why

Importance: Low

Example compound filters:

  1. Status = In Progress AND (Priority = 1 OR Severity = 1)
  2. Priority = 1 AND (Owner = Joe OR Owner = Matt)

Filing this issue to track. It's relatively low priority for now, but please chime in if you have a stronger need for this. Other use examples would be helpful too. Thanks.

jarkinber commented 1 year ago

Hi @chenilim - I would very much appreciate this as a feature, as I'm getting to the point where I have rather complex inter-property relationships that would be good to be able to have specific logic for when filtering within views.

From what I can tell, the default relationship between filters when you select multiple is 'AND' - even being able to select between AND/OR would be a huge improvement and could be a rather simple way to implement quasi-compound statements - there would however be no precedence, so not truly compound (ie [value1 AND (value2 OR value3)] ).

Example of what is already possible: 'Status' = 'Issue Raised' AND 'Raised by' = 'Development'

Example of a simple implementation of my request for filtering within views: 'Raise with' = 'Design' OR 'Raise with' = 'Engineering'