Query pagination
ERQL syntax enables to retrieve a subset of objects, with a constant display time in list views, whatever the data volume. To do so, use the offset and fetch keys.
Examples:
Select Application order by [creation date] desc offset 1 fetch 1
retrieves the last created application
Select Application order by [creation date] desc offset 11 fetch 10
retrieves the 10 applications of the second page (with 10 objects by page)
You can also use this syntax to search for an object according to a max or min criteria value of a specific attribute.