-
What is database.getQuerylocator in Salesforce?
What is database.getQuerylocator in Salesforce?
-
3 Replies
-
Hello Avnish,
Database.getQueryLocator returns a Query Locator that runs your selected SOQL query returning list that can be iterated over in bathc apex or used for displaying large sets in VF (allowing things such as pagination).
The query locator can return upto 50 million records and should be used in instances where you want to bactha a high volume of data up (pagination or batch apex). The database.query method should be used in instances where you are wanting to do a dynamic runtime SOQL query for your code.
Hope that helps.
Thanks.
-
Hi,
Database.QueryLocator object when you are using a simple query (SELECT) to generate the scope of objects used in the batch job. If you use a querylocator object, the governor limit for the total number of records retrieved by SOQL queries is bypassed but we can retrieve up to 10,000 records.
To add more -
Database.query():
We can retrieve up to 50,000 records.
If VF page has read-only attribute, use Database.getQueryLocator().
In Batch Apex, if we use Database.query(), it supports 50,000 records only.String fieldName = ‘Name,Phone’;
String dynQuery = ‘select Id ‘ + fieldName + ‘ From Account’;
Database.query(dynQuery);Hope this helps.
-
Database.getQueryLocator in Salesforce returns a Query Locator that runs your selected SOQL query returning list that can be iterated over in batch apex or used for displaying large sets in VF
Thanks
Log In to reply.
Popular Salesforce Blogs
How to Import Reports From Salesforce Sales Cloud Into Marketing Cloud Using Imports
In Salesforce Marketing cloud we can import data into the marketing cloud in two ways using imports : Objects and Reports Here I will explain…
To Lead or not to Lead, that is the question! | Salesforce Guide
Back when things were normal and we were able to go on-site and talk with our clients, there were a significant number of them who…
Why Should Organizations Consider Outsourcing Their Salesforce Development?
As a top-rated CRM, Salesforce can be leveraged by businesses to increase their sales and productivity. Besides helping organizations manage their business processes, the cloud-based…
Popular Salesforce Videos
Customize Salesforce in a Flash with Lightning
This video shows you how to use Lightning App Builder to make page customizations without any code. This enables admins to tailor Lightning Experience for…
Salesforce Security – An Encryption Guide For The Paranoid
If you are using Salesforce, you would be having a lot of data stored in Salesforce objects. Some of it would even be sensitive enough…
Hands-on Experience in Salesforce
How to get Hands-on experience in Salesforce? Watch this video to learn all about it.
