You need to sign in to do that
Don't have an account?
charles vieillard
What SOQL query to get a boolean condition on contacts?
We need to import contacts for sales rep, but if we use the basic soql query, it is much too large.
As a matter of fact the sharing model allow every user to read and write on every contacts in Salesforce's client session. We cannot use the restriction to Read and Write records.
Then we need to restrict the following query.
SELECT '.implode(',', $contactFields).', Account.Name FROM Contact ORDER BY CreatedDate ASC
The right restriction or filter we need would be :
To get all contacts of the accounts where User is Account Owner OR member of the Account salesteam.
Could somebody give a hint on how to build the correct SOQL ?
Thanks in advance for your HELP.
As a matter of fact the sharing model allow every user to read and write on every contacts in Salesforce's client session. We cannot use the restriction to Read and Write records.
Then we need to restrict the following query.
SELECT '.implode(',', $contactFields).', Account.Name FROM Contact ORDER BY CreatedDate ASC
The right restriction or filter we need would be :
To get all contacts of the accounts where User is Account Owner OR member of the Account salesteam.
Could somebody give a hint on how to build the correct SOQL ?
Thanks in advance for your HELP.