"Is" operator on a multi-select field, returns 0 when more than one value is selected

(1) Share

Report

Posted on by FA-30041613-0

I am trying to create a segment based on a multi-select field. I am trying to pull in contacts with accounts that have a specific combination of values for this field.

For example, the field is called /Type/ and it is a multi-select field with {A, B, C, and D} as the values. I would like to pull contacts w/ accounts that have A and C values (in other words A,C as the value).

I am trying the following clause: Type /Is/ {A, B}

However the segment returns zero members. I have more than 1 contacts/accounts that fall into this category, and I am able to pull those into a query using Advanced Find.

Does the /Is/ operator not work with same as /Equals/?

Thanks for any help you can provide.

I have the same question (0)

All responses (1)

Answers (1)

Verified answer

Fiona_Tiernan 388 Moderator on at

Like (2)

Report

Hi Farah,

If you were wanting to pull Contacts that had both A and C values, I would achieve your segment with the below query (this screenshot is from the Real Time area - please let me know if you are using Outbound instead):

Ensure that you are using the AND / OR criteria correctly - let me know how you get on.

If this answer has helped you, please consider marking it as verified.

Kind regards.
Fiona

Was this reply helpful? Yes No