queryMore()

Syntax

QueryResult = connection.queryMore( QueryLocator QueryLocator);

Usage

Use this call to process query() calls that retrieve a large number of records (by default, more than 500) in the result set. The query() call retrieves the first 500 records and creates a server-side cursor that is represented in the queryLocator object. The queryMore() call processes subsequent records in up to 500-record chunks, resets the server-side cursor, and returns a newly generated QueryLocator. To iterate through records in the result set, you generally call queryMore() repeatedly until all records in the result set have been processed (the Done flag is true). You can change the maximum number of records returned to up to 2,000. See Changing the Batch Size in Queries for more information.

Note

A queryMore()call on a parent object invalidates all child cursors in the previous result set. If you need the results from the child, you must use queryMore() on those results before using queryMore() on the parent results.

You can't use queryMore() if a query includes a GROUP BY clause. See GROUP BY and queryMore().

Sample Code—Java

public void queryRecords() {
  QueryResult qResult = null;
  try {
    String soqlQuery = "SELECT FirstName, LastName FROM Contact";
    qResult = connection.query(soqlQuery);
    boolean done = false;
    if (qResult.getSize() > 0) {
      System.out.println("Logged-in user can see " + 
          qResult.getRecords().length + 
          " contact records."
      );
      while (! done) {
        SObject[] records = qResult.getRecords();
        for ( int i = 0; i < records.length; ++i ) {
          Contact con = (Contact) records[i];
          String fName = con.getFirstName();
          String lName = con.getLastName();
          if (fName == null) {
            System.out.println("Contact " + (i + 1) + 
                ": " + lName
            );
          } else {
            System.out.println("Contact " + (i + 1) + ": " + 
                fName + " " + lName
            );
          }
        }
        if (qResult.isDone()) {
          done = true;
        } else {
          qResult = 
              connection.queryMore(qResult.getQueryLocator());
        }
      }
    } else {
      System.out.println("No records found.");
    }
      System.out.println("\nQuery succesfully executed.");
  } catch (ConnectionException ce) {
    ce.printStackTrace();
  }
}

Sample Code—C#

using System;
using System.Collections.Generic;
using System.Text;
using System.Web.Services.Protocols;
using Walkthrough.sforce;

namespace SFDCWsdl
{
    public class SFDCWsdlTest
    {
        private SforceService binding;

        private static readonly string Username = "ENTERUSERNAME";
        private static readonly string Password = "ENTERPASSWORD";

        /// <summary> 
    
        /// Create the binding and login 
    
        /// </summary> 
    
        private SFDCWsdlTest()
        {
            this.binding = new SforceService();
            LoginResult lr = binding.login(SFDCWsdlTest.Username, SFDCWsdlTest.Password);
            this.binding.Url = lr.serverUrl;
            this.binding.SessionHeaderValue = new SessionHeader();
            this.binding.SessionHeaderValue.sessionId = lr.sessionId;
        }

        public void QuerySample()
        {
            QueryResult qr = null;

            binding.QueryOptionsValue = new QueryOptions();
            binding.QueryOptionsValue.batchSize = 250;
            binding.QueryOptionsValue.batchSizeSpecified = true;


            qr = binding.query("select FirstName, LastName from Contact");

            bool bContinue = true;
            int loopCounter = 0;
            while (bContinue)
            {
                Console.WriteLine("\nResults Set " + Convert.ToString(loopCounter++)
                           + " - ");
                //process the query results 
    
                for (int i = 0; i < qr.records.Length; i++)
                {
                    Contact con = (Contact)qr.records[i];
                    string fName = con.FirstName;
                    string lName = con.LastName;
                    
                    if (fName == null)
                        Console.WriteLine("Contact " + (i + 1) + ": " + lName);
                    else
                        Console.WriteLine("Contact " + (i + 1) + ": " + fName
                                   + " " + lName);
                }
                //handle the loop + 1 problem by checking the most recent queryResult 
    
                if (qr.done)
                    bContinue = false;
                else
                    qr = binding.queryMore(qr.queryLocator);
            }
            Console.WriteLine("\nQuery successfully executed.");
            Console.Write("\nHit return to continue...");
            Console.ReadLine();
        }

        [STAThread]
        static void Main(string[] args)
        {
            SFDCWsdlTest sfdcWsdlTest = new SFDCWsdlTest();
            sfdcWsdlTest.QuerySample();
        }
    }
}

Arguments

Name	Type	Description
queryLocator	QueryLocator	Represents the server-side cursor that tracks the current processing location in the query result set.

Response

QueryResult

Faults

InvalidQueryLocatorFault

UnexpectedErrorFault