+ Start a Discussion
Rahul Gupta 194Rahul Gupta 194 

offset error of 2000 rows

Hi ,

I am getting error that offset cannot return more than 2000 rows.
Any work around for this.how to get this resolved.

Best Regards
Paul S.Paul S.
Rahul - are you using a LIMIT clause?
Rahul Gupta 194Rahul Gupta 194
i want to fetch all records i dont want Limit thing @paul
Paul S.Paul S.
Ah - I see. What is it you're trying to do with the records in the list? Start some operation at row 2001, etc.?
Rahul Gupta 194Rahul Gupta 194
Hi Paul ,

I am showing the list on recrds in Table with the help of pagination.
In pagination when clicking on Lastpage i am getting this Error

Paul S.Paul S.
I'd suggest StandardSetController (assuming this is for a Vf page), but that's limited to 10,000 records.  Can you post the code you have that's leading to the error?