const val DEFAULT_PAGE_NUM: Int

Pagination and Ordering

Provide simple ability to specify an offset within a result set and the number of results to return from that offset (eg. page size) together with (optional) sorting criteria at column level.

Note: it is the responsibility of the calling client to manage page windows.

For advanced pagination it is recommended you utilise standard JPA query frameworks such as Spring Data's JPARepository which extends the PagingAndSortingRepository interface to provide paging and sorting capability: