-
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
From Transactions to Relationships: How Salesforce Builds Customer Loyalty in Financial Services
In times of cutthroat competition, the financial industry holding on to loyal customers is a rare sight to find. One reason for this is that…
Invoke Apex Class From JavaScript Button in Salesforce
Introduction In this blog, we will learn how to call an apex class from a custom button or the Javascript button from the object detail…
Stuck on the Salesforce Security Review Process?
The attack vector and evidence of vulnerability associated with each item is listed below with a description of the vulnerability. Remediation steps and additional educational…
Popular Salesforce Videos
Salesforce Consent Management
Consent Management: Track Customer Consent and Honor Opt-Out Requests. Track your customers' approval for how your company interacts with them. To help you assess your…
Picklist fields in Salesforce Flow
In this video, we will talk about how to create picklist fields in Salesforce Screen flow. Below is the timestamp for your reference. Input Elements…
Salesforce Document Automation
Salesforce recently announced the release of an Intelligent Document Automation tool aimed at allowing healthcare and life sciences companies to digitize document-management processes. The tool,…
