---
schema_version: "1"
id: 761c0d31ae8fc96b403b09faecf1e1bd82ce962f7724c030ed59a4f1f9dcebd5
title: SOSL Limits on External Object Search Results
collection: developer
version: current
locale: en-us
portal_url: https://docs.salesforce.com/developer/current/en-us/platform/salesforce-soql-sosl/guides/soql-sosl/sforce-api-calls-sosl-limits-external-objects.md
canonical_url: https://developer.salesforce.com/docs/platform/salesforce-soql-sosl/guide/sforce-api-calls-sosl-limits-external-objects.html
source_site: developer.salesforce.com
content_type: documentation
content_hash: 0538a01c020488dab9122331e66c2d4bbe3ed7036f92240058399e1424ea7498
products:
  - SOQL and SOSL Reference
  - Platform Developer Content
---

# SOSL Limits on External Object Search Results

SOSL applies specific limits to external objects in search results.

- To include an external object in SOSL and Salesforce searches, enable search on both the external object and the external data source. However, syncing always overwrites the external object’s search status to match the search status of the external data source.
- Only text, text area, and long text area fields on external objects can be searched. If an external object has no searchable fields, searches on that object return no records.
- External objects don’t support the following.

  - `INCLUDES` operator
  - `LIKE` operator
  - `EXCLUDES` operator
  - `toLabel()` function

- External objects also don’t support Salesforce Knowledge-specific clauses, including the following.

  - `UPDATE TRACKING` clause
  - `UPDATE VIEWSTAT` clause
  - `WITH DATA CATEGORY` clause

- External objects must be specified explicitly in a `RETURNING` clause to be returned in search results. For example:

  ```soql
  FIND {MyProspect} RETURNING MyExternalObject, MyOtherExternalObject
  ```

- Text strings must be 100 or fewer characters.

The following limits apply only to the OData 2.0 and 4.0 adapters for Salesforce Connect.

- The OData adapters for Salesforce Connect don’t support logical operators in a `FIND` clause. We send the entire search query string to the external system as a case-sensitive single phrase after removing all ASCII punctuation characters except hyphens (-). For example, `FIND {MyProspect OR “John Smith”}` searches for the exact phrase “MyProspect OR John Smith”.

The following limits apply only to custom adapters for Salesforce Connect.

- The `convertCurrency()` function isn’t supported in SOSL queries of external objects.
- `WITH` clauses aren’t supported in SOSL queries of external objects.