As per the pega 7 behaviour ,when we are displaying large set of data in a grid by the report definition/pagelist, it is always fetch the data from database and store it in a clipboard memory first then segment wise we display data through pagination.
Here what is the purpose of pagination activity?Will it limit the clipboard data meaning it will fetch only n number of records first and upon clicking the next icon again it will bring another set of data.
Specifying a pagination activity is using a custom activity that populates the clipboard from a Page List in a page size that you define. Because the activity limits clipboard size, this option is useful when retrieving large amounts of data from an external Web service or database. You can also use this activity to control sorting and filtering behavior.
I'm on Pega 8.3 and I'm trying to find which steps need to be performed in the activity in order to retrieve X amounts of records between each page i.e For every page I need to display and retrieve only 20 records from the database, then when the user goes to the next page retrieve the next 20 records, can this be achieved? I'm sourcing my table from a Data page that runs a report definition.