SOQL Pagination for Salesforce API queries

Posted by Daniel Ballinger on Stack Overflow See other posts from Stack Overflow or by Daniel Ballinger
Published on 2009-10-02T01:34:27Z Indexed on 2010/06/01 1:23 UTC
Read the original article Hit count: 663

Filed under:

pagination

|

salesforce

|

soql

Is there an efficient way to page through results from a SOQL query without bringing all the query results back and then discarding the majority of them?

As an example, I'd like to be able to to page through the complete list of contacts showing 10 records at a time. I don't have the need to sort by any particular field.

© Stack Overflow or respective owner

Related posts about pagination

Planning Database as a Service Implementation Project

as seen on Oracle Blogs - Search for 'Oracle Blogs'
People, process and planning are the three key elements to success in a private cloud journey. Some common questions i hear from field/customers often relates to tasks involved in setting up Database-as-a-Service(DBaaS) using Oracle Enterprise Manager 12c from scratch and how these tasks are mapped… >>> More
help fixing pagination class

as seen on Stack Overflow - Search for 'Stack Overflow'
here is my pagination class. the data in the construct is just an another class that does db queries and other stuff. the problem that i am having is that i cant seem to get the data output to match the pagination printing and i cant seem to get the mysql_fetch_assoc() to query the data and print… >>> More
ASP.NET MVC pagination problem????

as seen on Stack Overflow - Search for 'Stack Overflow'
OK, This is starting to get mildly irritating. I tried to implement Twitter style paging using ASP.NET MVC and JQuery my problem is that when not using Request.IsAjaxRequest() (for users with javascript turned off) it works fine, obviously posting back the whole page. when I run the code for Request… >>> More
In Django-pagination Paginate does not working...

as seen on Stack Overflow - Search for 'Stack Overflow'
Hello. Python 2.6.2 django-pagination 1.0.5 Question: How to force pagination work correctly? The problem is that {% paginate %} does not work, but other {% load pagination_tags %} and {% autopaginate object_list 10 %} works! Error message appeared, when I add {% paginate %} into html page: TemplateSyntaxError… >>> More
Can rel="next" and rel="prev" can be ignored in blog listings

as seen on Pro Webmasters - Search for 'Pro Webmasters'
We have a blog - which is current spread to 9 pages, every page has a unique title - page 1, page 2, page 3 and so on. Also, as it's a blog, every page has unique 10 listing entry on one page. Is rel="prev" and rel="next" can be safely ignored as all these are listing and not content pages of article… >>> More

Related posts about salesforce

Bind a Wijmo Grid to Salesforce.com Through the Salesforce OData Connector

as seen on Geeks with Blogs - Search for 'Geeks with Blogs'
This article will explain how to connect to any RSSBus OData Connector with Wijmo's data grid using JSONP. While the example will use the Salesforce Connector, the same process can be followed for any of the RSSBus OData Connectors. Step 1: Download and install both the Salesforce… >>> More
Salesforce - Update/Upsert custom object entry

as seen on Stack Overflow - Search for 'Stack Overflow'
UPDATE: It's working as expected just needed to pass the correct Id, DUH!~ I have a custom object in salesforce, kind of like the comments section on a case for example. When you add a new comment it has a date/time stamp for that entry, I wanted to update the previous case comment date/time stamp… >>> More
Using the Salesforce PHP API to generate a User Profile Report

as seen on Stack Overflow - Search for 'Stack Overflow'
Hi All, Looking to do a security audit of all user permissions. I think I can use the Salesforce PHPToolkit 11 API to generate the report but new to Salesforce and a little confused on where to start. In Salesforce Setup Under: Administration Setup -> Manage Users -> Profiles -> Profile… >>> More
Salesforce/PHP - outbound messages (SOAP) - memory limit issue

as seen on Stack Overflow - Search for 'Stack Overflow'
I'm using Salesforce to send outbound messages (via SOAP) to another server. The server can process about 8 messages at a time, but will not send back the ACK file if the SOAP request contains more than 8 messages. SF can send up to 100 outbound messages in 1 SOAP request and I think this is causing… >>> More
Use Microsoft PowerPivot to Access Salesforce.com Through the OData Connector

as seen on Geeks with Blogs - Search for 'Geeks with Blogs'
This article will explain how to connect to any of our OData Connectors with Microsoft Excel's PowerPivot business intelligence tool. While the example will use the Salesforce Connector, the same process can be followed for any of the RSSBus OData Connectors. Step 1: Download… >>> More