function readOnly(count){ }
Sign Up ›
Starting November 20, the site will be set to read-only. On December 4, 2023,
forum discussions will move to the Trailblazer Community.
Learn More

Browse by Topic
ShowAll Questionssorted byDate Posted
+ Start a Discussion
Parteek Kumar 5Parteek Kumar 5 

How to use custom pagination with visualforce page

HI,

I want to add custom pagination in visualforce page. i have 45000 records in object. but offset only support for 2000 record. i am not getting how to fix this issue.

Please help me guys...
 
JyothsnaJyothsna (Salesforce Developers) 
Hi Prateek,

You have two options for pagination inside of Visualforce pages, OFFSET pagination, and StandardSetController pagination. With OFFSET pagination you are limited to 2,000 records; however, with a StandardSetController, you can paginate up to 10,000. So, one thing you could do would be to refactor to use the StandardSetController pagination.
​
Another thing that you could do would be to add some filtering capability so that the user can get to the records they need. For example, if you would return more than 2,000 records, display a message saying something like "Showing 2,000 records but there could be more. Please use a filter to narrow down the results."

Hope this helps you!
Best Regards,
Jyothsna