Huge data with paging has been a big headache for the developer. There is a default paging option available with some data controls. These controls do manage paging automatically without writing so much code but provide poor performance. This default paging is handled at the page level (in the .Net environment) and consumes memory. Few known techniques have been impaired with these controls to enhance the performance. But they still give bad performance over custom-paging.
In this sample, you will see how to use the SQL Server OFFSET FETCH clauses to limit the number of rows returned by a query and apply to a Table Records and still keep all the OutSystems UI widgets.
Added the Anonymous permission to the Web Screen List ListWithFilters.