---
schema_version: "1"
id: 2147bd57b6c6471f44eae3ab7d57da8a56f962bd061f48ebd4611d0a83d236ed
title: OData 2.0 Query Options
collection: admin
version: current
locale: en-us
portal_url: https://docs.salesforce.com/admin/current/en-us/platform/264-0-0/odata_considerations_search.md
canonical_url: https://help.salesforce.com/s/articleView?id=platform.odata_considerations_search.htm&release=264.0.0&type=5
source_site: help.salesforce.com
content_type: documentation
content_hash: bda727764831aba158917979a5fbc0ab2cd8664d2627a19f3ee5ce63ed6ec397
description: By default, the search query string is used as the substringof value in the $filter system query option.
products:
  - Salesforce Platform
  - Security
release: "264"
---
# OData 2.0 Query Options

By default, the search query string is used as the `substringof` value in the `$filter` system query option.

### Required Editions

<table class="slds-table slds-table_bordered slds-max-medium-table_stacked slds-m-bottom_small edition">
      <colgroup>
        <col>
      </colgroup>
      <tbody>
        <tr class="">
          <td class="slds-cell-wrap" style="vertical-align:top;">Available in: both Salesforce Classic and Lightning Experience (not for high-data-volume
            external objects)</td>

        </tr>
        <tr class="">
          <td class="slds-cell-wrap" style="vertical-align:top;">
            <p>Available in: <strong>Developer</strong> Edition</p>
            <p style="margin-bottom:0;">Available for an extra cost
              in: <strong>Enterprise</strong>, <strong>Performance</strong>, and <strong>Unlimited</strong>
              Editions</p>
          </td>

        </tr>
      </tbody>
    </table>

In this example, the search query string is Acme.

```
http://services.example.org/my.svc/Shippers?
$select=CompanyName,Phone,ShipperID&$inlinecount=allpages&
$filter=substringof('Acme',CompanyName)+eq+true+
or+substringof('Acme',Phone)+eq+true&$top=25
```

## OData 2.0 Custom Query Option

We recommend that you set up the OData producer to support free text search expressions with the custom query option. You can then specify the name of the query string parameter in the Custom Query Option for Salesforce Search field on the external data source. In this example, the custom query parameter is `doSearch` and the search query string is Acme.

```
http://services.example.org/my.svc/Shippers?
$select=CompanyName,Phone,ShipperID&
$inlinecount=allpages&doSearch=Acme&$top=25
```

Learn more about OData URI conventions at [www.odata.org](http://www.odata.org).