How can I filter contacts by a multiple checkboxes-type property using boolean operators?

SOLVE
Highlighted
New Contributor

I have a contact property for membership type that is a multiple checkboxes field.  Some contacts are type X, some contacts are type Y, some contacts are both type X and Y.

 

Can I filter contacts using Boolean operators to create a view that contains contacts of type X only, excluding contacts that are type X and Y?

 

 

Reply
0 Upvotes
1 Accepted solution

Accepted Solutions
Highlighted
Community Thought Leader | Diamond Partner

Hi @gerardo137

 

You can't do this in a filter because you can only use a property once and the 'is any of' condition would return both groups. 

 

If you have Marketing Basic or better, you can do this in a list though - since you can use properties twice in lists and the 'contains' rule checks for exact multi-select contents, not all that include the selected value. 

 

Hope that helps.

Phil Vallender | Inbound marketing for B2B technology companies
2 Replies 2
Highlighted
Community Thought Leader | Diamond Partner

Hi @gerardo137

 

You can't do this in a filter because you can only use a property once and the 'is any of' condition would return both groups. 

 

If you have Marketing Basic or better, you can do this in a list though - since you can use properties twice in lists and the 'contains' rule checks for exact multi-select contents, not all that include the selected value. 

 

Hope that helps.

Phil Vallender | Inbound marketing for B2B technology companies
Highlighted
Occasional Contributor

Is there an operator equivalent to "DOES NOT CONTAIN"? I have a property that needs to be used in a list with multiple filters where it should look something like this:

filter1:

string property contains ("abc;xyz") 

filter 2: 

string property does not contain ("123; uv")

 

I am setting them programmatically via the api and haven't quite figured out the appropriate operator to use. 

 

TIA

 

Reply
0 Upvotes