Filtering Contacts using SQL predicate
Summary
Filtering Contacts using SQL predicateContent
There is a custom multi-select Fixed choice list field on Contact.
The values in this field and Territory name are the same.
Example,
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,
1