Full support for IN operator in the Filter statements

Although we already support the entire SOQL language in the filter statements, the IN operator has been supported, to filter on multiple fields.

Where Country IN (‘USA’, ‘Canada’, ‘UK’, ‘France’)

But the IN operator can also be used in more advanced queries, like if you want to select a segment of Contacts which relates to another Object.

How to?
Step 1: Getting a list of ContactId’s
Select ContactID from CampaignMember where Campaign.Name = ‘Dreamforce 2017’
Step 2: Put this list into the IN statment
Id IN (Select ContactID from CampaignMember where Campaign.Name = ‘Dreamforce 2017’)

This technique can now be used for similar situations, where you want to match contacts which are associated with e.g. a particular JobOffer, Opportunities etc.

In the Filter field it would look like this (Selecting all Contacts from USA who has been part of at least one Campaign):


IN_Filter

Don’t hesitate to reach out to our support team if you run into any questions.

Sharing is caring!