-
What is the Difference between database.query() and database.getQueryLocator() in Salesforce?
Hi All,
What is the Difference between database.query() and database.getQueryLocator() in Salesforce?
Thanks
-
4 Replies
-
Hi Vikas,
database.query in Salesforce allows you to make a dynamic SOQL query at runtime. You can build up a string and then use that as a query string at run time in the database.query statement to make a SOQL call that is determined at run time. In Batch Apex, if you use Database.query(), it supports 50,000 records only.
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 (allowing things such as pagination). In Batch Apex, if you use Database.getQueryLocator(), it supports upto 50 million records.
Hope this helps you.
Thanks
-
Hi Pranav ,
Thanks for describing the difference between database.query() and database.getQueryLocator()
-
This reply was modified 7 years, 3 months ago by
Forcetalks.
-
This reply was modified 7 years, 3 months ago by
-
Hi,
1. Database.query() retrives 50K records where as Database.getQueryLocator() retrives 50 million records from Database.
2. Database.query() is used to construct dynamic query instead of using SOQL query where as Database.getQueryLocator() is the return type of start method of a Batch class.Hope this helps!
-
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.
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);Thanks
Log In to reply.
Popular Salesforce Blogs
Searching Account Name Via Search Key Through Salesforce Visualforce Page
Introduction Visualforce is a web development framework that enables developers to build sophisticated, custom user interfaces for mobile and desktop apps that can be hosted…
Algoworks Launches AWOM - A Salesforce App for Opportunity Management
Easier and efficient opportunities management in Salesforce CRM has been the unanswered prayer for many managers and sales organization alike, ever since the launch of…
Salesforce Predictions 2020: What does the Future Hold for Salesforce?
Salesforce, the market leader in CRM, has created a storm in the world of sales and marketing of products and services catering to a diverse…