SOLVED

Go to solution
Level 2

## 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 Rourke
1 ACCEPTED SOLUTION

Accepted Solutions
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))

6 REPLIES 6
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.

Level 2

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

Level 2

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

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.