In an interface we are showing grid with 4 columns and data is populated in it through query entity. So in query entity we are fetching all rows matching the search criteria with "local!paginginfo: a!pagingInfo(startIndex:1, batchSize: -1)". We are storing this query entity output in a cdt and using "ri!cdt.column name" to populate data in grid. But In Grid if we use "local!paginginfo: a!pagingInfo(startIndex:1, batchSize: 10)", to show 10 records per page, it is not returning data at all and if use "local!paginginfo: a!pagingInfo(startIndex:1, batchSize: length(ri!cdt.id))", it is returning all rows at a time. Please suggest how to fetch only 10 rows per page
OriginalPostID-200029
Discussion posts and replies are publicly visible
Hi Divya -
As a side consideration:Be careful using "batchSize: -1" in your queries.
-1 is essentially an unlimited batch size.This setting will probably work well in early design and testing.However, if the data store entity being queried ever becomes very large, the Query Rule Limits might go into force, leading to user-facing unexpected behavior.