Savable complex boolean filters for any object type (AND and OR) | Voters

Savable complex boolean filters for any object type (AND and OR)

in progress

Bruce Cannon

We need the ability to create filter views using combinations of AND, OR and NOT, that act on not only task name text, but also spaces, lists, folders, labels, etc.
For example, each department (space) might have its own ideas or submissions section (list or folder).  Those who plan dev priority would like to see a list view of just certain lists or folders across their org.
Or any custom selection, for that matter.  Implying that the filter should allow for a simple "hide this item" in the view.
This new request was requested by @zeb-1 in the originating idea that got closed: 
https://clickup.canny.io/feature-requests/p/advanced-filters-or-conditions "filters that allow for complex combinations of AND and OR logic across all the various attributes of tasks and projects"
Below are additional requests that could be folded under the same filter requirement:
https://clickup.canny.io/feature-requests/p/filterable-labels-for-folderslists  "the ability to easily see a full list of web/creative projects currently being worked on."
https://clickup.canny.io/feature-requests/p/filter-by-list-name  "Filter by List name to get all Tasks across all Folders that are in Lists with a particular name."
https://clickup.canny.io/feature-requests/p/filter-by-project-or-by-list-label-or-view-all-tasks-in-a-portfolio  "Sometimes you need to see all tasks belonging to, say, high priority projects; or documentation lists for every project in progress."
https://clickup.canny.io/feature-requests/p/filter-for-both-andor-filters-at-the-same-time "((Due Date is Today or Earlier) OR (Start Date is Today or Earlier)) AND Location..."
https://clickup.canny.io/feature-requests/p/combine-filters-with-boolean-formulas "powerful filters such as "(overdue OR due in the next 7 days) AND (Not tag = to-do-at-home)""
https://clickup.canny.io/feature-requests/p/option-to-display-or-not-the-folderslists-in-gantt-view "some folder/lists are not part the of the gantt view"

November 15, 2019

This needs to be true also for Automation Triggers!

Not being able to select multiple triggers makes the duplication of automations and creations insane.

William Strong

I see this is in progress but not sure how long it has been like this. Having each line in a filter be individually selectable to be either AND or OR would greatly improve functionality. My specific example is to have a filter where the user is Me Mode AND due date is Today or Earlier OR Next 7 Days would allow me to create powerful dashboards for my team to create a single pane of glass view of their day or week and how they are progressing.

Searchie

HI, Is there any update?

I have issues making compact filter. I would like to make a list of tasks that are overdue or due the next 14 days. Why ca't I add an OR nested filter if the rest is AND?

Mackenzie Santos

I see that this feature request is "in progress", but I wonder when it's expected to roll out? It would be incredibly helpful to be able to use both AND and OR in the same filter, or apply multiple filters to one view. Right now we are stuck having an ENORMOUS amount of top level views that could be consolidated with the use of both AND & OR in one filter.

Ľudka Štubňová

Please, I also need a combination of and and or condition in filters. It would be so helpful.

Adam

Here's an example use case I'm trying to implement for a List View but can't: (Start Date IS Today & Earlier OR Start Date Is Not Set) AND (tags IS NOT do-over-weekend)

Devon Moran

Merged in a post:

When using filters give the and/or option for every line

Lauren

May 2, 2023

Justin Levine

I got close to migrating from another to-do list app, but found the filters in ClickUp sorely weak. If you aren't able to place your "parentheses" wherever you want, you're forced to jump through all sorts of hoops to get what you want, and even then I don't know if it's always possible.
It seems like if your "outside" boolean method is AND, then they must all be ANDs. And if you have a boolean method in one of the groups, then everything in the group has to match it.
It's pretty weak, especially considering how customizable everything is.

Jan Dvořák

Justin Levine: I agree it is not easy to use - but as use of AND and OR at the same time was missing for like 2-3 years (=this is still improvement), you probably want another tool.

Ethan Whitted

Justin Levine: how are you able to create those nested AND/OR statements with "inner" and "outer" statements? I cannot find that functionality at all when I add filters to Dashboard cards in ClickUp? (I am paying for the Unlimited plan, is this a paid feature or something?)

Ethan Whitted

Oh that's very sad....

Randy Manaog

Any update on this? Is there an estimated time on when this is going to be available?

Jan Dvořák

Randy Manaog: Just making sure - what exactly you think is missing? IIRC these filters are still not on dashboards but in views they are on web (hover over +Add filter and +Add group appears).

Ginny Wu

Has this feature request been around for 2-3 years? Adding a more robust filtering capability seems like a feature that is critical to many customers (myself included). It's silly that I'm forced to use 'AND' for all my filters when that's not what I want or need.

→