SAP Knowledge Base Article - Preview

3069848 - Performance: Fiori OData query string ignores or removes or drops $top and $skip and loads the complete collection and ignores filter


  • Fiori application when deployed typically uses the $top of $skip query to filter out large data to help with performance
    • In this case when extending (customizing) a UI5 application with some known APIs (ex: Success Factors or others) and deploying it to the Cloud Platform, it appears that the $top and $skip parameters are dropped or ignored and causes a great deal of performance impact by loading the entirety of the data from the Odata services
  • What is causing the $top and $skip to be skipped or dropped?
  • Is the runtime removing this $top and $skip?



SAPUI5 1.8X or later


SAPUI5 1.0


"Fiori $top","Fiori $skip","SAPUI5 $top","SAPUI5 $skip","Performance UI5 Table","Peformance loading all OData","The entire collection being loaded in SAPUI5","Query String Parameters","UI5 Filter parameters","How to improve UI5 performance" , KBA , CA-UI5-TBL , SAP UI5 table, smart table, list and tree controls , CA-UI5-COR , Core and Runtime , 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.