Symptom
Different users (one admin and another non-admin) run a query and get different results. Admin user get more results than non-admin user.
Environment
SAP SuccessFactors Integration
- Odata API
Reproducing the Issue
Run a query with $top=xxxx and $orderby clause with non-admin user and admin user.
Cause
Expected behavior. For non-admin users, duplicated results is removed by platform.
Only this time the orderby clause make it happens more frequently in the first page of 1000 records.
Resolution
There are two ways to avoid the behavior:
- Use paging=snapshot approach (more details on Server Pagination)
- Don't use $orderby clause.
See Also
Keywords
query different results; query admin user; query non-admin user; orderby; , KBA , LOD-SF-INT , Integrations , LOD-SF-INT-API , API & Adhoc API Framework , Problem