How to use Filter to exclude mutliple projects?

Support
1

I guess there is a trick but I did not find it yet :slight_smile:

Having discovered “fitlers” and that one can be assigned for the overview, I am building a filter mainly excluding some projects. Some of my projects include a space in their name and that seems to break the query. I tried using quotes or double quotes without success.

What would the filter exclusind the project called My Project ?

2

ok, the issue is not what I thought it was and does not seem to be related to the spaces.

The following filter fails:
done = false && project != Shopping && project != Films

3

Does the same filter work if you use not in? Something like project not in Films, Shopping

4

Is “not” a valid operator ? It is not listed as such.
I kept testing and I think there is a bug. I did not spot the pattern though. Some filters that failed then started working.

I will test again with “not in” and hope it works as this is much better than gazillions project != …

5

My filter was: done = false && project not in Films, Shopping:

image
image544×198 9.41 KB

6
  • OK: done = false && project !=SVI && project != ToSell
  • OK: done = false && project !=SVI && project != Films
  • ERR: done = false && project !=SVI && project != Films && project != ToSell && project != Shopping
  • OK: done = false && project !=Shopping
7

What error do you get for the third query?

8

image
image564×144 11 KB

However Shopping in my case is not invalid and done = false && project !=Shopping works just fine.