SAP Knowledge Base Article - Public

2745638 - How to Query Odata With Filter Containing "+" Character


You are filtering an Odata query with a value that contains "+", however the query is not filtering accordingly.


  • SAP Business ByDesign.
  • SAP Cloud for Customer.

Reproducing the Issue

You are using any filter in an Odata query that contains a "+". Example: $filter=Phone eq '+1 123-456-7890'


The character "+" is a reserved delimiter, so this will be omitted or replaced as a space in URI, hence "+" symbol cannot be used in $filter value.


Instead you can use an equivalent encoded character for "+" which is "%2B". Example: $filter=Phone eq '%2B1 123-456-7890'


odata; query; filter; +; , KBA , LOD-CRM-INT-API , OData API (C4C Only) , How To


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