Another Salesforce blog!!!

Salesforce, Apex

Considerations When Using OFFSET


I have just learned that maximum offset is 2,000 rows according to the documentation below:
http://www.salesforce.com/us/developer/docs/soql_sosl/Content/sforce_api_calls_soql_select_offset.htm

Which is annoying, since the standard query can return up to 50k records. Which means that you can hit the offset as soon as the 20th page (on a 100/page configuration) by using datatable.

Just keep in mind

Leave a Reply

Your email address will not be published.

*