Print this page

Why does "OFFSET" keyword return me 1000 records even if I use limit 1100

Knowledge Article Number 000175418
Description In a dynamic SOQL query,  If I use OFFSET keyword with limit 1100, it returns only 1000 records, however my database contains much more records which should be returned by the query .

When  I remove the keyword "OFFSET" query works as expected (whether I use limit or not).
Resolution Salesforce Product development Team has confirmed that it is working as designed .
When using offsets, the SOQL query only returns the first batch of records. For LTA (long text area which is treated as BLOB), the batch size is 1000, and otherwise it is 50001).

promote demote