SOLVED

Advanced Filters - using 'not contains' and 'is not' filters

Go to solution
Highlighted

Advanced Filters - using 'not contains' and 'is not' filters

Hello, 

 

I have TWO filters that include 'not contains' and 'is not' and want to make sure neither value appears in my smart list. 

 

Most of the members won't have both but I want to make sure that if they have one, they are excluded. 

 

Should I use (4 and 5) instead of (4 or 5)? 

 

Attached is a screenshot. Filters 4 and 5 are the ones in question. 

 

Shane_Rourke2_1-1586283978369.png

 

 

 

1 ACCEPTED SOLUTION

Accepted Solutions
Highlighted
Level 10 - Community Moderator

Re: Advanced Filters - using 'not contains' and 'is not' filters

It's everyday Boolean logic. We use it implicitly in real life, too.

 

Let's say I'm going to the grocery store and someone says "get me some produce that's not a vegetable and not orange".

 

Section IS Produce AND ((Type IS NOT Vegetable) AND (Color IS NOT Orange))

 

View solution in original post

6 REPLIES 6
Highlighted
Level 10 - Community Moderator

Re: Advanced Filters - using 'not contains' and 'is not' filters


Should I use (4 and 5) instead of (4 or 5)? 

Yes.

Highlighted

Re: Advanced Filters - using 'not contains' and 'is not' filters

Thanks, Sanford!

 

What's the reasoning? Is it because I am using negative filters? 

Highlighted
Level 10 - Community Moderator

Re: Advanced Filters - using 'not contains' and 'is not' filters

It's everyday Boolean logic. We use it implicitly in real life, too.

 

Let's say I'm going to the grocery store and someone says "get me some produce that's not a vegetable and not orange".

 

Section IS Produce AND ((Type IS NOT Vegetable) AND (Color IS NOT Orange))

 

View solution in original post

Highlighted

Re: Advanced Filters - using 'not contains' and 'is not' filters

Sorry, last question. 

 

Should the logic go:

 

1 and 2 and 3 and 4 and 5

OR

1 and 2 and 3 and (4 and 5)? 

Level 10 - Community Moderator

Re: Advanced Filters - using 'not contains' and 'is not' filters

If they're all AND, there's no reason to parenthesize.

Highlighted
Level 10 - Community Moderator

Re: Advanced Filters - using 'not contains' and 'is not' filters

@Shane_Rourke2 please mark one of my answers as the Solution when you get a chance.