Returning large data from query in small batch

create a query entity rule such as : a!queryEntity(entity: cons!entity, query: a!query(filters{whatever filters you want},
pagingInfo:ri!!pagingInfo
))

then in the main rule create local!pagingInfo(startIndex: 1, batchSize: 10)
Then call the query entity rule;
with(
local!query: rule!query(pagingInfo: local!pagingInfo),
then display it in grid
)
Do not do another todatasubset() on local!query.data...then your totalcount will only show 10 items in the grid instead of display 1-to of 7000 records.
This approach ensures that you are only querying 10 items at a time from the 7000 records. Another thing to note is if you have filters on that query rule, then if you have filtering through any text boxes or dropdown, do a!save(local!pagingInfo.startIndex, 1) on the saveInto of those fields, otherwise you will get error for startindex.

create a query entity rule such as : a!queryEntity(entity: cons!entity, query: a!query(filters{whatever filters you want},
pagingInfo:ri!!pagingInfo
))

then in the main rule create local!pagingInfo(startIndex: 1, batchSize: 10)
Then call the query entity rule;
with(
local!query: rule!query(pagingInfo: local!pagingInfo),
then display it in grid
)
Do not do another todatasubset() on local!query.data...then your totalcount will only show 10 items in the grid instead of display 1-to of 7000 records.
This approach ensures that you are only querying 10 items at a time from the 7000 records. Another thing to note is if you have filters on that query rule, then if you have filtering through any text boxes or dropdown, do a!save(local!pagingInfo.startIndex, 1) on the saveInto of those fields, otherwise you will get error for startindex.