remove $skip & $top parameters ?

[shama_parween]

Hello Expert,

Whenever a oData request is made, by default UI5 adds the parameter $skip=0 & $top=100. Is there a way to override this ?

Kindly advice.

[maheshpalavalli · Accepted solution]

It will only happen if the control supports it.

for e.g., if you use m.table or m.List or ui.table, it has some feature called threshold & growing.

If growing property is set to true then on scoll/onclick of load it will get the data based on the threshold you set. Lets say if the threshold is 10, it will fetch the first 10 records and then after scrolling it will fetch from 11 - 20 (10 more records) and how it does it? it uses the top & skip of entityset.

So you can give a maximum of 1000 or 2000 threshold or according to your requirement else you can set growing to false.

SAP UI5 recomends to use the growing and threshold to improve the performance. you can read it in the description there and in guidelines as well. So better use the growing & threshold

https://ui5.sap.com/#/api/sap.m.Table

BR,
Mahesh

[former_member724290 · Accepted solution]

Hi Mahesh!

Please, tell me which component not support growing?

How to display OData result without params $top and $skip?

My OData entity not support $top, $skip and $cout params. During request I have error "Not Implemented".

BR,

Andrey

[maheshpalavalli · Accepted solution]

and_andrey, not implemented will come if entityset method is not implemented, if you are not returning or using count params, it will not cause any errors.

[former_member724290 · Accepted solution]

I am not calling the count method myself. It is called by default when using the table element. Is it possible to use a loop in a view?

[former_member505084]

Hello Shama Parween

May be the below link can help you to get your answer.

https://blogs.sap.com/2014/11/19/sapui5-pagination-in-sapmtable-using-skip-and-top-values-of-odata-s...

Thanks