2633494 - odata v2 version is not supporting filter option on the expanded entities

SAP Knowledge Base Article - Public

2633494 - odata v2 version is not supporting filter option on the expanded entities

Symptom

  • You are using OData API of successfactors which is of "v2" version(/odata/v2/)
  • You are using the expanded navigational entities and applying the filter
  • The filter is not respected

Environment

 Successfactors

Reproducing the Issue

  • Let us consider the navigation from SFOData.EmpJob entity into Event into picklistLabel
  • $expand=eventNav/picklistLabels
  • $filter=eventNav/picklistLabels/locale eq 'en_US' 
  • This will result in all the locale types instead of getting only the exact locale type 'en_US'

Cause

In Odata v2 service the filter option works only at root entity level. It does not work on expanded entities

Resolution

odata v4 version of the service will support filter on $expand entities too(Which is currently not supported for Successfactors odata api)

Keywords

  • filter not returning correct data
  • filter is not support in odata v2
  • Filter on entity is not working as expected
  • Filter from a navigated mdf custom entity doesn't work
, KBA , LOD-SF-INT-ODATA , OData API Framework , LOD-SF-INT , SF Integrations - EC Payroll, Boomi/ HCI, API , Problem

Product

SAP SuccessFactors HCM Core all versions