You signed in with another tab or window. Reload to refresh your session.You signed out in another tab or window. Reload to refresh your session.You switched accounts on another tab or window. Reload to refresh your session.Dismiss alert
My client has a custom field Contact_Type__c which is a multi select picklist. When doing a query, the field returns a string with "A;B;D" indicating the field has been selected with A, B, and D (but not C).
When doing an eloquent query, I can do a standard $query->where('Contact_Type__c','A') but the only records returned are the ones with only A selected. If they have more than one selected, the record is not returned. A "like" statement does not work either, with a hard error about it being a multi select picklist field.
Research found the correct SOQL way to do this is an "Includes" statement as described in this Salesforce KB article.
Example: Select Id, Name, Contact_Type__c from Contact where Contact_Type__c includes ('Coach')
Is there any support for this is the package?
Thanks
The text was updated successfully, but these errors were encountered:
My client has a custom field Contact_Type__c which is a multi select picklist. When doing a query, the field returns a string with "A;B;D" indicating the field has been selected with A, B, and D (but not C).
When doing an eloquent query, I can do a standard
$query->where('Contact_Type__c','A')
but the only records returned are the ones with only A selected. If they have more than one selected, the record is not returned. A "like" statement does not work either, with a hard error about it being a multi select picklist field.Research found the correct SOQL way to do this is an "Includes" statement as described in this Salesforce KB article.
Example:
Select Id, Name, Contact_Type__c from Contact where Contact_Type__c includes ('Coach')
Is there any support for this is the package?
Thanks
The text was updated successfully, but these errors were encountered: