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?
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.
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
I solved this this way. Say a multiple checkbox property has three options: A, B, and C. Create a smart list with n-1 groups:
