robbyrob42 / forceworkbench

Automatically exported from code.google.com/p/forceworkbench
BSD 3-Clause "New" or "Revised" License
0 stars 0 forks source link

add SOQL Pagination support to query builder #584

Closed GoogleCodeExporter closed 9 years ago

GoogleCodeExporter commented 9 years ago
SOQL Pagination—Generally Available
SOQL Pagination enables you to specify the starting row of the result set your 
SOQL query returns. You use SOQL Pagination
via the SOQL OFFSET clause. Using SOQL OFFSET is helpful for paging through 
large result sets when you need to
quickly jump to a particular subset of the entire results. As the offset 
calculation is done on the server and only the result subset
is returned, using OFFSET is more efficient than retrieving the full result set 
and then filtering the results locally. For example,
this SOQL query returns a result set that skips the first 10 rows:
SELECT Name
FROM Merchandise__c
WHERE Price__c > 5.0
ORDER BY Name
LIMIT 100
OFFSET 10
The maximum offset is 2,000 rows. Requesting an offset greater than 2,000 will 
result in a NUMBER_OUTSIDE_VALID_RANGE
error.

Original issue reported on code.google.com by ryan.bra...@gmail.com on 5 Aug 2012 at 12:22

GoogleCodeExporter commented 9 years ago
this can easy be done manually

Original comment by ryan.bra...@gmail.com on 5 Aug 2012 at 5:24

GoogleCodeExporter commented 9 years ago
**NOTICE**
All issues for Workbench in the Google Code project "forceworkbench" have been 
migrated to the GitHub project "ryanbrainard/forceworkbench":

https://github.com/ryanbrainard/forceworkbench

Issue numbers have been retained between the two services so migrated issues 
can be easily found on GitHub (e.g. Issue #123 on Google Code is still Issue 
#123 on GitHub). If you wish to receive future updates about an open issue, you 
will need to re-follow the issue on GitHub.

Original comment by ryan.bra...@gmail.com on 27 Jan 2013 at 5:30