Filter Search Results Using Multidropdown Values

I have a field on User that references an option set ‘Interests’ where users can select interests from a dropdown such as cats, dogs, gaming… etc

I have a field on a Campaign object tha alsot looks upto the same option Interests

How do I filter campaigns that contain the same interests as the interests the user has selected on their profile?

I currently have a constraint where ‘Campaign Interests contains Current Users Interests’ but I get the error message ‘search for campaigns: value should be Interests but right now it is a list of Interests’

You’ll need to use an advanced filter for this, with either the ‘:contains list’ or the ‘:intersect with’ operator, depending on exactly what you want to do…

Ahh, the ‘:intersect with’ operator worked perfectly - thanks Adam

1 Like

This topic was automatically closed after 70 days. New replies are no longer allowed.