You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

Filtering Contacts using SQL predicate

Received Response
edited Jun 24, 2021 2:45PM in Sales 4 comments


Filtering Contacts using SQL predicate


There is a custom multi-select Fixed choice list field on Contact.
The values in this field and Territory name are the same.
Contact Type : A, B, C
Territory name : A, B, C
I want to write a SQL predicate, to filter the Contact records for user.
When a user logs in , navigates to contact object and search a record the SQL predicate should check,
The logged in user is in which Territory team and if the Territory name matches the Contact type field value then show the record.

Any suggestions on how this predicate should be,

Howdy, Stranger!

Log In

To view full details, sign in.


Don't have an account? Click here to get started!