Skip to main content

Questions tagged [querylocator]

Represents the record set returned by Database.getQueryLocator and used with Batch Apex.

11 questions with no upvoted or accepted answers
Filter by
Sorted by
Tagged with
10 votes
1 answer
304 views

Read access denied: getQueryLocator(soql) vs. query(soql)

I am attempting to add pagination, and I followed this great article by Jeff Douglas. I am an admin so when I run the page it runs great, I can navigate forwards, back. When I log in as a user my ...
Steve MunLeeuw's user avatar
3 votes
0 answers
112 views

Execute Method in Batchable Class does not execute on all records returned in Start method Querylocator

I am seeing a very similar issue to the one discussed in this question, which was due to a bug in Spring '17. The Querylocator returned by the Start method returns 9,989 records, which I can verify ...
kenslewis's user avatar
  • 328
2 votes
2 answers
472 views

Batch Class Error: Start did not return a valid iterable object

I have a simple piece of batch code that iterates over all Location__c records that don't already have Folders. It then calls a method to create the missing folders. public with sharing class ...
Kevin's user avatar
  • 21
2 votes
0 answers
799 views

How can I work with both QueryLocator and List<SObject> in a single batch class (not a single instance)?

I've been working on a chainable batch class. The constructor can take in either a service & query or a service & list of records. In almost all cases, the service/query are passed in. In ...
myrddincat's user avatar
1 vote
0 answers
390 views

INVALID_QUERY_LOCATOR on queryMore on node js

I m getting INVALID_QUERY_LOCATOR error on using queryMore operation using the Enterprise WSDL on node js. Below is the code client.query({queryString:"Select Id,Name FROM Account ORDER BY Name"},...
AjSyles's user avatar
  • 41
1 vote
0 answers
688 views

Database.querylocater on external object in batch class not returning any rows

I am writing a batch class on external object. Here I am using database.getQuerylocator in start method as the result will contain more thank 50k records. Batch class code: global class <...
Muskan Gupta's user avatar
1 vote
0 answers
188 views

QueryLocator timeout problem?

I have a StandardSetController that I navigate through pages... from a VF page. However, if I let the web page sit for around 15 min or so (not sure about the time) and then try and click the next or ...
Nick's user avatar
  • 7,030
1 vote
0 answers
77 views

Get count of open Query Locators

For debugging porpuses, we would like to get the count of the open "QueryLocators" for an organisation.Is this possible somehow? Thanks
noBillSide's user avatar
0 votes
1 answer
29 views

How can I make my <account> variable filterType equal to the first account returned in a StandardSetController Query?

how would this work with a dynamic search page I have a visual force search page and I have used the stadardsetcontroller for pagination. The initial query during page load is working for me. ...
Tyler's user avatar
  • 91
0 votes
1 answer
131 views

Batch Apex ignores records even without subquery in start()

Basically the querylocator returns about 200000 records at the start, I can see it in logs, also there are not any errors or limits warnings. The size of each job matters because the smaller it is,...
J.Dillinger's user avatar
-1 votes
1 answer
129 views

Inner SOQL query API Call

I am using a SOQL query that uses an inner query that returns the parent details along with all child details as one json record as API response. I would like to know how can nexturl be used when a ...
Harsh's user avatar
  • 1