Hi all,

I need to implement pagination to display records from a database table that contains approximately 1 million (10 lakh) entries.

My Requirement:

• Display 20 records per page in a UI grid.

• When a user clicks on Next page or selects a specific page number, only that set of 20 records should be fetched from the database and loaded into the clipboard.

• The expectation is that OFFSET / FETCH (LIMIT) logic should be applied behind the scenes, so that Pega fetches data page-by-page, not the entire dataset at once.

Current Issue:

• Even after enabling options like "Allow querying any column" or "Enable pagination", Pega still fetches all the records from the DB into the clipboard.

• This causes performance issues and defeats the purpose of pagination.

expecting senario,  I want to limit the records fetched from the DB using pagination (OFFSET / FETCH) and load only 20 records per request — not the full result set.

My question.

• What is the correct approach in Pega (Infinity version) to handle this?

• Can this be achieved using a Data Page with Report Definition or do I need to use Connect SQL?

• How can I pass and use parameters like PageSize and PageNumber in a Report Definition or Connect SQL query?

Looking for a scalable and performance-friendly solution to handle large volume pagination. Thanks, Karthik MG