Contains Function

  • Reference
Namespace:
Microsoft.Dynamics.CRM

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

Parameters

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

Name Type Nullable Unicode Description
PropertyName
 Edm.String False False

The string to evaluate.
PropertyValue
 Edm.String False False

The value of the string.

Syntax Example

?$filter=Microsoft.Dynamics.CRM.Contains(PropertyName=@p1,PropertyValue=@p2)&@p1='name'&@p2='value'

Remarks

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