SAP Knowledge Base Article - Public

3087941 - The order is not guaranteed when one-to-many field navigation is used - SAP SuccessFactors Integration Center - Filters and Fields

Symptom

You are receiving undesired results after you apply one filter or field in integration center integration.

Environment

  • SAP SuccessFactors HXM Suite
    • Integration Center

Resolution

The OData API response order for 1:M (one-to-many) entities can lead to undesired results in your Integration Center using filters or adding fields in the response.

Kindly check the cause item 2 of the KBA = 2925189 - Filters in Integration Center are not filtering correctly: wrong records are being returned

Kindly also check the same explained for IC and OData in this other KBA too = 2856036 - Fields and filters value 1:many are not appearing or are not the expected - SuccessFactors - Integration Center and OData

Keywords

Order, 1:M, one to Many, one-to-many, navigations, entities, entity, Integration Center, filter, fields, wrong results, undesired results, filtering, predictable, OData, IC, You selected a field for filtering that has a one-to-many relationship with its child entities. All the parent records will be returned even if only one of the child entities for that parent entity satisfies the filter condition, The order is not guaranteed when one-to-many field navigation is used. , KBA , LOD-SF-INT-INC-FWK , Integration Center UI Framework , How To

Product

SAP SuccessFactors HXM Suite all versions