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