Loading
Important Advisory: iOS Update Impacting CG Mobile ApplicationRead More
Extend Salesforce with Clicks, Not Code
OData 4.0 and 4.01 Query Options

You are here:

  1. Salesforce Help
  2. Docs
  3. Extend Salesforce with Clicks, Not Code

OData 4.0 and 4.01 Query Options

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
 
Loading
Salesforce Help | Article