SAP Knowledge Base Article - Public

3384292 - Unable to filter a boolean field via ODATA API

Symptom

Trying to query job application via ODATA API using this kind of  filter on a type="bool" field:
.../odata/v2/JobApplication ...  &$filter=my_boolean_Field eq false

the response does not return expected results even if testing on other boolean fields that syntax works fine.

Environment

SAP SuccessFactors Recruiting Management

Cause

Probably the boolean field used in the filter is a custom field and not standard field.

Clarifications on the design:
For custom boolean field, since we configure it as Text in Provisioning > Reportable custom field the system stored as Text in Database
As consequence the quotation marks around the word false are required

For standard filed, the quotation marks are optional.



Resolution

In  case of custom boolean field use this syntax:
&$filter=my_boolean_Field eq 'false'

instead of this one:
&$filter=my_boolean_Field eq false


Keywords

bool, ODATA, filter, boolean , KBA , LOD-SF-RCM-API , Webservices & APIs , Problem

Product

SAP SuccessFactors Recruiting all versions