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.

What is the use of database getQueryLocator?

getQuery() Returns the query used to instantiate the Database. QueryLocator object. This is useful when testing the start method.

What is the difference between database QueryLocator and iterable in Salesforce?

QueryLocator is used when the scope is directly taken from a SOQL. QueryLocator 50 Million can be returned records. Iterable<sObject>: Governor limits will be enforced.

What is database stateful?

Stateful in the class definition, you can maintain state across these transactions. When using Database. Stateful , only instance member variables retain their values between transactions. Static member variables don’t retain their values and are reset between transactions.

Why do we use database query Salesforce?

Dynamic SOQL enables you to create more flexible applications. For example, you can create a search based on input from an end user or update records with varying field names. To create a dynamic SOQL query at run time, use the database query method, in one of the following ways.

What is the difference between database query () and database getQueryLocator?

query() retrives 50K records where as Database. getQueryLocator() retrives 50 million records from 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.

What is database getQueryLocator and what are its advantages?

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).

What is stateless and stateful in Salesforce?

Batch Apex is stateless by default. That means for each execution of your execute method, you receive a fresh copy of your object. If your batch process needs information that is shared across transactions, one approach is to make the Batch Apex class itself stateful by implementing the Stateful interface.

What is Database stateful Salesforce?

63. The only time you need Database. Stateful is when the execute method modifies a class variable in a way meant to be used across multiple execute methods or in the finish method. The majority of batches you will ever write will not need Database.

What is Database BatchableContext in Salesforce?

BatchableContext’ can be used along with the instance method ‘getJobID’ to retrieve the current batch job Id within the batch class. This can be used in combination with ‘AsyncApexJob’ to obtain additional information about the batch job. Database. executeBatch returns the current job ID when invoking batch Apex.

Article first time published on

What is iterator in batch class?

Apex batch classes can return an iterator to process large volume of data that are not directly queried from database/sobjects. These iterators can be classes implementing Iterable interface or standard apex data strucutres like list.

What is iterator in Salesforce?

An iterator traverses through every item in a collection. For example, in a while loop in Apex, you define a condition for exiting the loop, and you must provide some means of traversing the collection, that is, an iterator. Iterators can also be used if you have multiple SELECT statements. …

What are governing limits in Salesforce?

Simply put, Salesforce Governor Limits are usage caps enforced by Salesforce to ensure efficient processing. They allow for multiple users of the platform without impeding performance.

What is getQueryLocator?

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).

What is query in Salesforce?

What Is a SOQL Query? SOQL stands for Salesforce Object Query Language. You can use SOQL to read information stored in your org’s database. SOQL is syntactically similar to SQL (Structured Query Language). You can write and execute a SOQL query in Apex code or in the Developer Console’s Query Editor.

What are queries in a database?

A query can either be a request for data results from your database or for action on the data, or for both. A query can give you an answer to a simple question, perform calculations, combine data from different tables, add, change, or delete data from a database.

How do you use Escapeslequotes?

To prevent SOSL injection, use the escapeSingleQuotes method. This method adds the escape character (\) to all single quotation marks in a string that is passed in from a user. The method ensures that all single quotation marks are treated as enclosing strings, instead of database commands.

What is the difference between query locator and iterator?

It depends on your need , if you want to run batch on records that can be filtered by SOQL then QueryLocator is preferable, but if records that you want to bee processed by batch can not be filtered by SOQL then you will have to use iteratable.

What is SOSL in Salesforce?

Salesforce Object Search Language (SOSL) is a Salesforce search language that is used to perform text searches in records. Use SOSL to search fields across multiple standard and custom object records in Salesforce. SOSL is similar to Apache Lucene.

What is database query return apex?

query() retrives 50K records where as Database. getQueryLocator() retrives 50 million records from Database.

What are governor limits in Apex and Salesforce?

OverviewGovernor LimitMax. number of class and trigger code units in Apex deployment5000Batch size of Apex trigger200Batch size for loop list200Max. record number returned for a Batch Apex query in Database.QueryLocator50 000 000

What is database Batchablecontext BC?

Represents the parameter type of a batch job method and contains the batch job ID. This interface is implemented internally by Apex.

What is the difference between Insert & database insert?

Insert Includes an optional allorNone parameters that defaults to true. Database. Insert when used in the bulk operation, in case of an error, the remaining records will be inserted. Only the records throwing an error will not be inserted.

What is asynchronous apex in Salesforce?

Asynchronous Apex. In a nutshell, asynchronous Apex is used to run processes in a separate thread, at a later time. An asynchronous process is a process or function that executes a task “in the background” without the user having to wait for the task to finish.

What is difference between with sharing and without sharing in Salesforce?

Use With Sharing when the User has access to the records being updated via Role, Sharing Rules, Sales Teams – any sort of sharing really. Without sharing keyword: Ensures that the sharing rules of the current user are not enforced.

Is database stateful or stateless?

Stateless and Stateful Container Management DB is stateful, i.e., it has persistent storage attached to it.

What are the different annotations in Salesforce?

• @AuraEnabled.
• @Deprecated.
• @Future.
• @InvocableMethod.
• @InvocableVariable.
• @IsTest.
• @JsonAccess.
• @NamespaceAccessible.

What is job chaining in Salesforce?

No limit is enforced on the depth of chained jobs, which means that you can chain one job to another job and repeat this process with each new child job to link it to a new child job.

Can we call Queueable method from batch class?

Interviewer: Can I call Queueable from a batch? Interviewee: Yes, But you’re limited to just one System. enqueueJob call per execute in the Database. Batchable class.

What is Apex Flex queue in Salesforce?

The Apex Flex Queue page lists all batch jobs that are in Holding status. You can view information about the job, such as the job ID, submission date, and Apex class. By default, jobs are numbered in the order submitted, starting with position 1, which corresponds to the job that was submitted first.

What is Apex in Salesforce?

Apex is a development platform for building software as a service (SaaS) applications on top of Salesforce.com’s customer relationship management (CRM) functionality. Apex allows developers to access Salesforce.com’s back-end database and client-server interfaces to create third-party SaaS applications.