Filter with Multiple Values - is this 'AND' or 'OR'? | Community
Skip to main content
James_Glavin
Level 4
May 26, 2017
Solved

Filter with Multiple Values - is this 'AND' or 'OR'?

  • May 26, 2017
  • 1 reply
  • 2497 views

Hi there!

In creating a smart list/campaign, if I use the filter "Member of List: Person *NOT* in ..." and I select multiple values, am I creating an AND logic or OR, among those values? So if a person is on one of those lists but not another, will they be included or excluded?

Thanks!

James

This post is no longer active and is closed to new replies. Need help? Start a new post to ask your question.
Best answer by Casey_Grimes2

It is among those values (OR logic), so if you do something like:

Member of List is not in: (3) Apples; Peaches; Pears

It doesn't matter if they are in Apples, Peaches, or Pears; they won't be included. If you want to only remove people who are part of all three, you'd do

Member of List is not in Apples

Member of List is not in Peaches

Member of List is not in Pears

Whenever you have the ability to specify more than one value in a Marketo filter, it's always operating off OR logic.

1 reply

Casey_Grimes2
Casey_Grimes2Accepted solution
Level 10
May 26, 2017

It is among those values (OR logic), so if you do something like:

Member of List is not in: (3) Apples; Peaches; Pears

It doesn't matter if they are in Apples, Peaches, or Pears; they won't be included. If you want to only remove people who are part of all three, you'd do

Member of List is not in Apples

Member of List is not in Peaches

Member of List is not in Pears

Whenever you have the ability to specify more than one value in a Marketo filter, it's always operating off OR logic.

James_Glavin
Level 4
May 26, 2017

Thanks so much!