SAP Knowledge Base Article - Preview

2959633 - Duplicated records are being returned when querying on expanded navigated fields using fromDate/toDate - OData API

Symptom

Considering there are 3 entity types: A, B and C. A has an 1->1 navigation "bNav" to B, B has an 1->many navigation "cNav" to C. A has 2 timeslice records a1, a2 for a code k. Both a1 and a2 are associated to a B record b. And record b associated to C record c1 and c2.
Then do query A?$expand=bNav/cNav&$filter=code eq 'k'&fromDate=... to query for both 2 records of A, the data under cNav will be duplicated.


Read more...

Environment

  • SAP SuccessFactors HXM Suite
    • OData API

Keywords

duplicated, records, results, duplicate, dupe, odata, api, call, query, select, expand, navigation, nav, release, b2011, sf, successfactors, success factors, time-based filter, fromdate, from date, todate, to date, effective-dated, effective dated, effective date, historical record, custom, nav, link, links , KBA , LOD-SF-INT-ODATA , OData API Framework , Problem

About this page

This is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP ONE Support launchpad (Login required).

Search for additional results

Visit SAP Support Portal's SAP Notes and KBA Search.