SAP Knowledge Base Article - Public

3384292 - Unable to filter a boolean field via ODATA API


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.


SAP SuccessFactors Recruiting Management


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.


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


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


SAP SuccessFactors Recruiting all versions