Apex Code Development You need to sign in to do that
Don't have an account?
Sagar Maurya Using the 'Parameterized Search' on Contact, I am getting unexpected result
While using the 'Parameterized Search' on Contact, I am getting unexpected result. I am using below json to search records on contact based on 'Name' filter:
{
"q":"CAPITAL CROSS",
"fields" : ["Id","FirstName","LastName","Account.Name"],
"sobjects":[{"name": "Contact", "where":"RecordType.Name='Internal'"}],
"in":"NAME"
}
Note - There is only one contact with name as 'CAPITAL CROSS'. And this contact is associated with account named as 'Capital'.
Expected -
When I run the above json as System Admin profile, I get only one contact named as 'CAPITAL CROSS'
Unexpected-
When I run the above json from custom profile having Salesforce Platform user license, I get 'CAPITAL CROSS' contact and all the other contacts which are associated with the same account named 'Capital' in response. This should not happen as I am getting all the contacts which are not matching my search criteria.
Can anyone help me in understanding that what could be reason for this behaviour?
{
"q":"CAPITAL CROSS",
"fields" : ["Id","FirstName","LastName","Account.Name"],
"sobjects":[{"name": "Contact", "where":"RecordType.Name='Internal'"}],
"in":"NAME"
}
Note - There is only one contact with name as 'CAPITAL CROSS'. And this contact is associated with account named as 'Capital'.
Expected -
When I run the above json as System Admin profile, I get only one contact named as 'CAPITAL CROSS'
Unexpected-
When I run the above json from custom profile having Salesforce Platform user license, I get 'CAPITAL CROSS' contact and all the other contacts which are associated with the same account named 'Capital' in response. This should not happen as I am getting all the contacts which are not matching my search criteria.
Can anyone help me in understanding that what could be reason for this behaviour?
I tried a narrowed down repro of the issue you mentioned in my dev org:
Repro
1. Login to workbench
2. Select Rest explorer and make a post call
3:- Use request URL as follow :-
/services/data/v45.0/parameterizedSearch
Below is the request body for POST Call
{"q":"Tim Barr",
"fields":["Id","FirstName","LastName","Account.Name"],
"in": "NAME",
"sobjects": [{"name":"Contact"}]
}
Result: I see that only one account is returned.
searchRecords
0037F000001W17wQAC
attributes
Id: 0037F000001W17wQAC
FirstName: Tim
LastName: Barr
Account
attributes
Name: Grand Hotels & Resorts Ltd
Note: This account has 4 contacts but only the one associated account is returned for above post call.
This does not appear to be a Bug or issue of Salesforce Platform level. It appears to be your org specific.
same issue will find this information useful.
Thank you