SOLVED

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

Go to solution
Shane_Rourke2
Level 4

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

 

 

 

Shane Rourke
1 ACCEPTED SOLUTION

Accepted Solutions
SanfordWhiteman
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
SanfordWhiteman
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.

Shane_Rourke2
Level 4

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

Thanks, Sanford!

 

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

Shane Rourke
SanfordWhiteman
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))

 

Shane_Rourke2
Level 4

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)? 

Shane Rourke
SanfordWhiteman
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.

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