Pagination Using Iterator Limit

Question

I have to paginate total of 4000-5000 records with 20 records per page. I am using a wrapper class type List. This list would be displayed on a pageblocktable.

I CANT use OFFSET because offset has a limit of paginating 2000 records on total.

StandardsetController has limit of 10000 records. However, using standardsetcontroller, we CANT persist the value of checkbox when we click "NEXT" page.

I am planning to use Iterator for this job. Can anyone tell me what is the limit of records i can paginate when i implement Iterator?

Answer 1

One solution would be to query and hold ALL records in a List in your controller. Then from this list take a range of records and populate them into your wrapper for displaying on the page. This way all checked records would be saved in your controller only wrapper.

The downside to this would be you'd have to keep track of everything in the controller.

Answer 2

EDIT:

Well my previous answer only works for limited number of records.So i searched it a little and i found this nice answer by sfdcfox.

check this out: Workaround for Offset 2000 limit on SOQL Query

Previous answer:

As Ratan has already pointed out...You have to use limit and offset together in the query.

For eg.

SELECT Name
FROM Merchandise__c
WHERE Price__c > 5.0
ORDER BY Name
LIMIT 100
OFFSET 10

Refer this for more info: https://developer.salesforce.com/docs/atlas.en-us.soql_sosl.meta/soql_sosl/sforce_api_calls_soql_select_offset.htm