Symptom
When trying to query the Delta from Workorder entity in Integration Center with Server Side Pagination feature enabled the following error message is received, "Error invoking query API: Unsupported feature: You cannot use the 'lastModifiedDateTime' filter in a navigation."
Environment
SuccessFactors BizX - all versions
Cause
Snapshot pagination of MDF objects present a limitation regarding the lastModifiedDate in Navigation being used in filter condition. This is the current behavior of this entity due to the complexity of last modified data filter for effective-dated entities.
Resolution
This can be minimized using sorting the business keys (primary keys) in $orderby / Advanced Sorting.
See Also
Find more information on the OData API Reference Guide - Section Snapshot-based Pagination
Find more information of $orderby on KBA 2151847
Keywords
Error invoking query API: Unsupported feature: You cannot use the 'lastModifiedDateTime' filter in a navigation; Integration Center; Server Side Pagination; MDF Entity; WorkOrder; , KBA , LOD-SF-INT , Integrations , LOD-SF-INT-INC , Integration Center , LOD-SF-INT-MDF , Metadata Framework API (MDF) , Problem