Contains Function

Query function that evaluates whether the string contains the specified string.


Parameters allow for data to be passed to the query function.

Name Type Nullable Unicode Description
Edm.String False False

The string to evaluate.

Edm.String False False

The value of the string.

Syntax Example



Only use this function with columns that are enabled for full-text indexing. In a Microsoft Dynamics 365 default installation, only the columns of the KBArticle (article) entity are enabled for full-text indexing.

If you use this with a column that doesn't support full-text indexing, you will get the following error:

HTTP/1.1 400 Bad Request
Content-Type: application/json; odata.metadata=minimal
OData-Version: 4.0

    "error": {
        "code": "0x80041120",
        "message": "Unknown Condition Operator: Contains. FetchXml does not support it"

Use the OData contains function instead.

See also