By default, the search query string is used as the contains value in the $filter system
query option.
Required Editions
| Available in: both Salesforce Classic and Lightning Experience (not for high-data-volume external objects) |
|
Available in: Developer Edition Available for an extra cost in: Enterprise, Performance, and Unlimited Editions |
In the following example, the search query string is Acme.
http://services.example.org/v4.svc/Shippers?
$select=CompanyName,Phone,ShipperID&$count=true&
$filter=contains(CompanyName,'Acme') eq true
or contains(Phone,'Acme') eq true$top=25&OData 4.0 and 4.01 Custom Query Option
We recommend that you set up the OData producer to support free text search
expressions with the $search system query
option. You can then select Use Free-Text Search Expressions on
the external data source.
http://services.example.org/v4.svc/Shippers?
$select=CompanyName,Phone,ShipperID&$count=true&
$search=Acme&$top=25