SAP Knowledge Base Article - Public

3282760 - OData Filter "Contains" is not working in C4C

Symptom

You are trying to search via OData by using the OData filter "contains" but it returns error.

Environment

 SAP Cloud For Customer

Reproducing the Issue

  1. You call the URL e.g https://myXXXXXX.crm.ondemand.com/sap/c4c/odata/v1/c4codataapi/BusinessPartnerRelationshipCollection?$filter=contains("NameOfField,'Value').
  2. Returns error: Invalid function 'contains' found.
     

Cause

OData is based on OData V2, so in v2 contains is not supported. Hence is not supported in our framework also.
Refer here for supported string functions in OData V2.

https://www.odata.org/documentation/odata-version-2-0/uri-conventions/

Resolution

This is currently not supported.

Keywords

Contains, OData, Call, Search, Filter, Version , KBA , LOD-CRM-INT-API , OData API (C4C Only) , Problem

Product

SAP Cloud for Customer add-ins all versions ; SAP Cloud for Customer core applications all versions