The overall requirement is to build a simple service that allows the consumers to search for application data based on some predefined parameters. Initially, the service activity was using a report definition to fetch the result set based on the search criteria passed in service request.
However, client wants the additional functionality wherein the service will allow pagination, i.e. consumer will be able to pass the page number and page size and the service should return the data subset accordingly.
For e.g. if there are a total of 100 records matching the search criteria, the consumer should be able to pass page size of '10' and when consumer passes page number '1', the service returns rows 1-10; when consumer passes page number '2', the service returns rows 11-20.
Is there any way of implementing this without using RDB- operations?
***Edited by Moderator Marissa to update categories***