Database Class

Usage

delete is analogous to the delete() statement in the SOAP API.

Each executed delete method counts against the governor limit for DML statements.

delete(recordsToDelete, allOrNone)

Deletes a list of existing sObject records, such as individual accounts or contacts, from your organization’s data.

Signature

public static Database.DeleteResult[] delete(SObject[] recordsToDelete, Boolean allOrNone)

Parameters

recordsToDelete: Type: sObject[]
allOrNone: Type: Boolean; The optional allOrNone parameter specifies whether the operation allows partial success. If you specify false for this parameter and a record fails, the remainder of the DML operation can still succeed. This method returns a result object that can be used to verify which records succeeded, which failed, and why. If the parameter is not set or is set true, an exception is thrown if the method is not successful.

Return Value

Type: Database.DeleteResult[]

Usage

delete is analogous to the delete() statement in the SOAP API.

Each executed delete method counts against the governor limit for DML statements.

Example

The following example deletes an account named 'DotCom':

1Account[] doomedAccts = [SELECT Id, Name FROM Account WHERE Name = 'DotCom']; 
2Database.DeleteResult[] DR_Dels = Database.delete(doomedAccts);

delete(recordID, allOrNone)

Deletes existing sObject records, such as individual accounts or contacts, from your organization’s data.

Signature

public static Database.DeleteResult delete(ID recordID, Boolean allOrNone)

Parameters

recordID: Type: ID
allOrNone: Type: Boolean; The optional allOrNone parameter specifies whether the operation allows partial success. If you specify false for this parameter and a record fails, the remainder of the DML operation can still succeed. This method returns a result object that can be used to verify which records succeeded, which failed, and why. If the parameter is not set or is set true, an exception is thrown if the method is not successful.

Return Value

Usage

delete is analogous to the delete() statement in the SOAP API.

Each executed delete method counts against the governor limit for DML statements.

delete(recordIDs, allOrNone)

Deletes a list of existing sObject records, such as individual accounts or contacts, from your organization’s data.

Signature

public static Database.DeleteResult[] delete(ID[] recordIDs, Boolean allOrNone)

Parameters

recordIDs: Type: ID[]
allOrNone: Type: Boolean; The optional allOrNone parameter specifies whether the operation allows partial success. If you specify false for this parameter and a record fails, the remainder of the DML operation can still succeed. This method returns a result object that can be used to verify which records succeeded, which failed, and why. If the parameter is not set or is set true, an exception is thrown if the method is not successful.

Return Value

Type: Database.DeleteResult[]

Usage

delete is analogous to the delete() statement in the SOAP API.

Each executed delete method counts against the governor limit for DML statements.

deleteAsync(sobjects, callback)

Initiates requests to delete the external data that corresponds to the specified external object records. The request is executed asynchronously, as a background operation, and is sent to the external system that's defined by the external object's associated external data source. Allows referencing a callback class whose processDelete method is called for each record after deletion.

Signature

public static List<Database.DeleteResult> deleteAsync(List<SObject> sobjects, DataSource.AsyncDeleteCallback callback)

Parameters

sobjects: Type: List<SObject>; List of external object records to delete.
callback: Type: DataSource.AsyncDeleteCallback; The callback that contains the state in the originating context and an action (the processDelete method) that is executed after the insert operation is completed. Use the action callback to update org data according to the operation’s results. The callback object must extend DataSource.AsyncDeleteCallback.

Return Value

Type: List<Database.DeleteResult>

Status results for the delete operation. Each result corresponds to a record processed by this asynchronous operation and is associated with a unique identifier (asyncLocator). The asyncLocator value is included in the errors array of the result. You can retrieve this identifier with Database.getAsyncLocator(). Retrieve the final result with Database.getAsyncDeleteResult().

deleteAsync(sobject, callback)

Initiates a request to delete the external data that corresponds to the specified external object record. The request is executed asynchronously, as a background operation, and is sent to the external system that's defined by the external object's associated external data source. Allows referencing a callback class whose processDelete method is called after deletion.

Signature

public static Database.DeleteResult deleteAsync(SObject sobject, DataSource.AsyncDeleteCallback callback)

Parameters

sobject: Type: SObject; The external object record to delete.
callback: Type: DataSource.AsyncDeleteCallback; The callback that contains the state in the originating context and an action (the processDelete method) that is executed after the insert operation is completed. Use the action callback to update org data according to the operation’s results. The callback object must extend DataSource.AsyncDeleteCallback.

Return Value

Status result for the delete operation. The result corresponds to the record processed by this asynchronous operation and is associated with a unique identifier (asyncLocator). The asyncLocator value is included in the errors array of the result. You can retrieve this identifier with Database.getAsyncLocator(). Retrieve the final result with Database.getAsyncDeleteResult().

deleteAsync(sobjects)

Initiates requests to delete the external data that corresponds to the specified external object records. The requests are executed asynchronously, as background operations, and are sent to the external systems that are defined by the external objects' associated external data sources.

Signature

public static List<Database.DeleteResult> deleteAsync(List<SObject> sobjects)

Parameters

sobjects: Type: List<SObject>; List of external object records to delete.

Return Value

Type: List<Database.DeleteResult>

Status results for the delete operation. Each result corresponds to a record processed by this asynchronous operation and is associated with a unique identifier (asyncLocator). The asyncLocator value is included in the errors array of the result. You can retrieve this identifier with Database.getAsyncLocator(). Retrieve the final result with Database.getAsyncDeleteResult().

deleteAsync(sobject)

Initiates a request to delete the external data that corresponds to the specified external object record. The request is executed asynchronously, as a background operation, and is sent to the external system that's defined by the external object's associated external data source.

Signature

public static Database.DeleteResult deleteAsync(SObject sobject)

Parameters

sobject: Type: SObject; The external object record to delete.

Return Value

Status result for the delete operation. The result corresponds to the record processed by this asynchronous operation and is associated with a unique identifier (asyncLocator). The asyncLocator value is included in the errors array of the result. You can retrieve this identifier with Database.getAsyncLocator(). Retrieve the final result with Database.getAsyncDeleteResult().

deleteImmediate(sobjects)

Initiates requests to delete the external data that corresponds to the specified external object records. The requests are executed synchronously and are sent to the external systems that are defined by the external objects' associated external data sources. If the Apex transaction contains pending changes, the synchronous operations can't be completed and throw exceptions.

Signature

public static List<Database.DeleteResult> deleteImmediate(List<SObject> sobjects)

Parameters

sobjects: Type: List<SObject>; List of external object records to delete.

Return Value

Type: List<Database.DeleteResult>

Status results for the delete operation.

Usage

The batch limit for big objects using deleteImmediate() is 2,000 records at a time.

deleteImmediate(sobject)

Initiates a request to delete the external data that corresponds to the specified external object record. The request is executed synchronously and is sent to the external system that's defined by the external object's associated external data source. If the Apex transaction contains pending changes, the synchronous operation can't be completed and throws an exception.

Signature

public static Database.DeleteResult deleteImmediate(SObject sobject)

Parameters

sobject: Type: SObject; The external object record to delete.

Return Value

Status result for the delete operation.

emptyRecycleBin(recordIds)

Permanently deletes the specified records from the Recycle Bin.

Signature

public static Database.EmptyRecycleBinResult[] emptyRecycleBin(ID [] recordIds)

Parameters

recordIds: Type: ID[]

Return Value

Type: Database.EmptyRecycleBinResult[]

Usage

Note the following:

After records are deleted using this method, they cannot be undeleted.
Only 10,000 records can be specified for deletion.
Logged in users can delete any record that they can query in their Recycle Bin, or the recycle bins of any subordinates. If logged in users have “Modify All Data” permission, they can query and delete records from any Recycle Bin in the organization.
Cascade delete record IDs should not be included in the list of IDs; otherwise an error occurs. For example, if an account record is deleted, all related contacts, opportunities, contracts, and so on are also deleted. Only include the Id of the top-level account. All related records are automatically removed.
Deleted items are added to the number of items processed by a DML statement, and the method call is added to the total number of DML statements issued. Each executed emptyRecycleBin method counts against the governor limit for DML statements.

emptyRecycleBin(obj)

Permanently deletes the specified sObject from the Recycle Bin.

Signature

public static Database.EmptyRecycleBinResult emptyRecycleBin(sObject obj)

Parameters

obj: Type: sObject

Return Value

Type: Database.EmptyRecycleBinResult

Usage

Note the following:

After an sObject is deleted using this method, it cannot be undeleted.
Only 10,000 sObjects can be specified for deletion.
The logged-in user can delete any sObject (that can be queried) in their Recycle Bin, or the recycle bins of any subordinates. If the logged-in user has “Modify All Data” permission, they can query and delete sObjects from any Recycle Bin in the organization.
Do not include an sObject that was deleted due to a cascade delete; otherwise an error occurs. For example, if an account is deleted, all related contacts, opportunities, contracts, and so on are also deleted. Only include sObjects of the top-level account. All related sObjects are automatically removed.
Deleted items are added to the number of items processed by a DML statement, and the method call is added to the total number of DML statements issued. Each executed emptyRecycleBin method counts against the governor limit for DML statements.

emptyRecycleBin(listOfSObjects)

Permanently deletes the specified sObjects from the Recycle Bin.

Signature

public static Database.EmptyRecycleBinResult[] emptyRecycleBin(sObject[] listOfSObjects)

Parameters

listOfSObjects: Type: sObject[]

Return Value

Type: Database.EmptyRecycleBinResult[]

Usage

Note the following:

After an sObject is deleted using this method, it cannot be undeleted.
Only 10,000 sObjects can be specified for deletion.
The logged-in user can delete any sObject (that can be queried) in their Recycle Bin, or the recycle bins of any subordinates. If the logged-in user has “Modify All Data” permission, they can query and delete sObjects from any Recycle Bin in the organization.
Do not include an sObject that was deleted due to a cascade delete; otherwise an error occurs. For example, if an account is deleted, all related contacts, opportunities, contracts, and so on are also deleted. Only include sObjects of the top-level account. All related sObjects are automatically removed.
Deleted items are added to the number of items processed by a DML statement, and the method call is added to the total number of DML statements issued. Each executed emptyRecycleBin method counts against the governor limit for DML statements.

executeBatch(batchClassObject)

Submits a batch Apex job for execution corresponding to the specified class.

Signature

public static ID executeBatch(Object batchClassObject)

Parameters

batchClassObject: Type: Object; An instance of a class that implements the Database.Batchable interface.

Return Value

Type: ID

The ID of the new batch job (AsyncApexJob).

If the executeBatch call fails to acquire an Apex flex queue lock, the call returns an empty ID, "000000000000000", instead of throwing an exception.

Usage

When calling this method, Salesforce chunks the records returned by the start method of the batch class into batches of 200, and then passes each batch to the execute method. Apex governor limits are reset for each execution of execute.

For more information, see Using Batch Apex.

executeBatch(batchClassObject, scope)

Submits a batch Apex job for execution using the specified class and scope.

Signature

public static ID executeBatch(Object batchClassObject, Integer scope)

Parameters

batchClassObject: Type: Object; An instance of a class that implements the Database.Batchable interface.
scope: Type: Integer; Number of records to be passed into the execute method for batch processing.

Return Value

Type: ID

The ID of the new batch job (AsyncApexJob).

If the executeBatch call fails to acquire an Apex flex queue lock, the call returns an empty ID, "000000000000000", instead of throwing an exception.

Usage

The value for scope must be greater than 0.

If the start method of the batch class returns a Database.QueryLocator, the scope parameter of Database.executeBatch can have a maximum value of 2,000. If set to a higher value, Salesforce chunks the records returned by the QueryLocator into smaller batches of up to 200 records. If the start method of the batch class returns an iterable, the scope parameter value has no upper limit; however, if you use a very high number, you could run into other limits.

Apex governor limits are reset for each execution of execute.

For more information, see Using Batch Apex.

getAsyncDeleteResult(deleteResult)

Retrieves the status of an asynchronous delete operation that’s identified by a Database.DeleteResult object.

Signature

public static Database.DeleteResult getAsyncDeleteResult(Database.DeleteResult deleteResult)

Parameters

deleteResult: Type: Database.DeleteResult; The result record for the delete operation being retrieved.

Return Value

The result of a completed asynchronous delete of a record or records.

getAsyncDeleteResult(asyncLocator)

Retrieves the result of an asynchronous delete operation based on the result’s unique identifier.

Signature

public static Database.DeleteResult getAsyncDeleteResult(String asyncLocator)

Parameters

asyncLocator: Type: String; The unique identifier associated with the result of an asynchronous operation.

Return Value

The result of a completed asynchronous delete of a record or records.

getAsyncLocator(result)

Returns the asyncLocator associated with the result of a specified asynchronous insert, update, or delete operation.

Signature

public static String getAsyncLocator(Object result)

Parameters

result: Type: Object; The saved result of an asynchronous insert, update, or delete operation. The result object can be of type Database.SaveResult or Database.DeleteResult.

Return Value

Type: String

The unique identifier associated with the result of the specified operation.

getAsyncSaveResult(saveResult)

Returns the status of an asynchronous insert or update operation that’s identified by a Database.SaveResult object.

Signature

public static Database.SaveResult getAsyncSaveResult(Database.SaveResult saveResult)

Parameters

saveResult: Type: Database.SaveResult; The result record for the insert or update operation being retrieved.

Return Value

Database.SaveResult

The result of a completed asynchronous operation on a record or records.

getAsyncSaveResult(asyncLocator)

Returns the status of an asynchronous insert or update operation based on the unique identifier associated with each modification.

Signature

public static Database.SaveResult getAsyncSaveResult(String asyncLocator)

Parameters

asyncLocator: Type: String; The unique identifier associated with the result of an asynchronous operation.

Return Value

Database.SaveResult

The result of a completed asynchronous operation on a record or records.

getDeleted(sObjectType, startDate, endDate)

Returns the list of individual records that have been deleted for an sObject type within the specified start and end dates and times and that are still in the Recycle Bin.

Signature

public static Database.GetDeletedResult getDeleted(String sObjectType, Datetime startDate, Datetime endDate)

Parameters

sObjectType: Type: String; The sObjectType argument is the sObject type name for which to get the deleted records, such as account or merchandise__c.
startDate: Type: Datetime; Start date and time of the deleted records time window.
endDate: Type: Datetime; End date and time of the deleted records time window.

Return Value

Type: Database.GetDeletedResult

Usage

Because the Recycle Bin holds records up to 15 days, results are returned for no more than 15 days previous to the day the call is executed (or earlier if an administrator has purged the Recycle Bin).

Example

1Database.GetDeletedResult r =
2 Database.getDeleted(
3  'Merchandise__c',
4  Datetime.now().addHours(-1),
5  Datetime.now());

getQueryLocator(listofQueries)

Creates a QueryLocator object used in batch Apex or Visualforce.

Signature

public static Database. QueryLocator getQueryLocator(sObject [] listOfQueries)

Parameters

listOfQueries: Type: sObject []

Return Value

Type: Database.QueryLocator

Usage

You can't use getQueryLocator with any query that contains an aggregate function.

Each executed getQueryLocator method counts against the governor limit of 10,000 total records retrieved and the total number of SOQL queries issued.

For more information, see Understanding Apex Managed Sharing, and IdeaStandardSetController Class.

getQueryLocator(query)

Creates a QueryLocator object used in batch Apex or Visualforce.

Signature

public static Database.QueryLocator getQueryLocator(String query)

Parameters

query: Type: String

Return Value

Type: Database.QueryLocator

Usage

You can't use getQueryLocator with any query that contains an aggregate function.

Each executed getQueryLocator method counts against the governor limit of 10,000 total records retrieved and the total number of SOQL queries issued.

For more information, see Understanding Apex Managed Sharing, and StandardSetController Class.

getUpdated(sobjectType, startDate, endDate)

Returns the list of individual records that have been updated for an sObject type within the specified start and end dates and times.

Signature

public static Database.GetUpdatedResult getUpdated(String sobjectType, Datetime startDate, Datetime endDate)

Parameters

sobjectType: Type: String; The sObjectType argument is the sObject type name for which to get the updated records, such as account or merchandise__c.
startDate: Type: Datetime; The startDate argument is the start date and time of the updated records time window.
endDate: Type: Datetime; The endDate argument is the end date and time of the updated records time window.

Return Value

Type: Database.GetUpdatedResult

Usage

The date range for the returned results is no more than 30 days previous to the day the call is executed.

Example

1Database.GetUpdatedResult r =
2 Database.getUpdated(
3  'Merchandise__c',
4  Datetime.now().addHours(-1),
5  Datetime.now());

insert(recordToInsert, allOrNone)

Adds an sObject, such as an individual account or contact, to your organization's data.

Signature

public static Database.SaveResult insert(sObject recordToInsert, Boolean allOrNone)

Parameters

recordToInsert: Type: sObject
allOrNone: Type: Boolean; The optional allOrNone parameter specifies whether the operation allows partial success. If you specify false for this parameter and a record fails, the remainder of the DML operation can still succeed. This method returns a result object that can be used to verify which records succeeded, which failed, and why. If the parameter is not set or is set true, an exception is thrown if the method is not successful.

Return Value

Usage

insert is analogous to the INSERT statement in SQL.

Apex classes and triggers saved (compiled) using API version 15.0 and higher produce a runtime error if you assign a String value that is too long for the field.

Each executed insert method counts against the governor limit for DML statements.

insert(recordsToInsert, allOrNone)

Adds one or more sObjects, such as individual accounts or contacts, to your organization’s data.

Signature

public static Database.SaveResult[] insert(sObject[] recordsToInsert, Boolean allOrNone)

Parameters

recordsToInsert: Type: sObject []
allOrNone: Type: Boolean; The optional allOrNone parameter specifies whether the operation allows partial success. If you specify false for this parameter and a record fails, the remainder of the DML operation can still succeed. This method returns a result object that can be used to verify which records succeeded, which failed, and why. If the parameter is not set or is set true, an exception is thrown if the method is not successful.

Return Value

Usage

insert is analogous to the INSERT statement in SQL.

Apex classes and triggers saved (compiled) using API version 15.0 and higher produce a runtime error if you assign a String value that is too long for the field.

Each executed insert method counts against the governor limit for DML statements.

Example

Example:

The following example inserts two accounts:

1Account a = new Account(name = 'Acme1');
2Database.SaveResult[] lsr = Database.insert(
3    new Account[]{a, new Account(Name = 'Acme2')},
4    false);

insert(recordToInsert, dmlOptions)

Adds an sObject, such as an individual account or contact, to your organization's data.

Signature

public static Database.SaveResult insert(sObject recordToInsert, Database.DMLOptions dmlOptions)

Parameters

recordToInsert: Type: sObject
dmlOptions: Type: Database.DMLOptions; The optional dmlOptions parameter specifies additional data for the transaction, such as assignment rule information or rollback behavior when errors occur during record insertions.

Return Value

Usage

insert is analogous to the INSERT statement in SQL.

Apex classes and triggers saved (compiled) using API version 15.0 and higher produce a runtime error if you assign a String value that is too long for the field.

Each executed insert method counts against the governor limit for DML statements.

insert(recordsToInsert, dmlOptions)

Adds one or more sObjects, such as individual accounts or contacts, to your organization's data.

Signature

public static Database.SaveResult insert(sObject[] recordsToInsert, Database.DMLOptions dmlOptions)

Parameters

recordsToInsert: Type: sObject[]
dmlOptions: Type: Database.DMLOptions; The optional dmlOptions parameter specifies additional data for the transaction, such as assignment rule information or rollback behavior when errors occur during record insertions.

Return Value

Usage

insert is analogous to the INSERT statement in SQL.

Apex classes and triggers saved (compiled) using API version 15.0 and higher produce a runtime error if you assign a String value that is too long for the field.

Each executed insert method counts against the governor limit for DML statements.

insertAsync(sobjects, callback)

Initiates requests to add external object data to the relevant external systems. The requests are executed asynchronously, as background operations, and are sent to the external systems that are defined by the external objects' associated external data sources. Allows referencing a callback class whose processSave method is called for each record after the remote operations are completed.

Signature

public static List<Database.SaveResult> insertAsync(List<SObject> sobjects, DataSource.AsyncSaveCallback callback)

Parameters

sobjects: Type: List<SObject>; List of external object records to insert.
callback: Type: DataSource.AsyncSaveCallback; The callback object that contains the state in the originating context and an action (the processSave method) that executes after the insert operation is completed. Use the action callback to update org data according to the operation’s results. The callback object must extend DataSource.AsyncSaveCallback.

Return Value

Type: List<Database.SaveResult>

Status results for the insert operation. Each result corresponds to a record processed by this asynchronous operation and is associated with a unique identifier (asyncLocator). The asyncLocator value is included in the errors array of the result. You can retrieve this identifier with Database.getAsyncLocator(). Retrieve the final result with Database.getAsyncSaveResult().

Usage

Database.insertAsync() methods can’t be executed in the context of a portal user, even when the portal user is a community member. To add external object records via Apex, use Database.insertImmediate() methods.

insertAsync(sobject, callback)

Initiates a request to add external object data to the relevant external system. The request is executed asynchronously, as a background operation, and is sent to the external system that's defined by the external object's associated external data source. Allows referencing a callback class whose processSave method is called after the remote operation is completed.

Signature

public static Database.SaveResult insertAsync(SObject sobject, DataSource.AsyncSaveCallback callback)

Parameters

sobject: Type: SObject; The external object record to insert.
callback: Type: DataSource.AsyncSaveCallback; The callback object that contains the state in the originating context and an action (the processSave method) that executes after the insert operation is completed. Use the action callback to update org data according to the operation’s results. The callback object must extend DataSource.AsyncSaveCallback.

Return Value

Status result for the insert operation. The result corresponds to the record processed by this asynchronous operation and is associated with a unique identifier (asyncLocator). The asyncLocator value is included in the errors array of the result. You can retrieve this identifier with Database.getAsyncLocator(). Retrieve the final result with Database.getAsyncSaveResult().

Usage

Database.insertAsync() methods can’t be executed in the context of a portal user, even when the portal user is a community member. To add external object records via Apex, use Database.insertImmediate() methods.

insertAsync(sobjects)

Initiates requests to add external object data to the relevant external systems. The requests are executed asynchronously, as background operations, and are sent to the external systems that are defined by the external objects' associated external data sources.

Signature

public static List<Database.SaveResult> insertAsync(List<SObject> sobjects)

Parameters

sobjects: Type: List<SObject>; List of external object records to insert.

Return Value

Type: List<Database.SaveResult>

Status results for the insert operation. Each result corresponds to a record processed by this asynchronous operation and is associated with a unique identifier (asyncLocator). The asyncLocator value is included in the errors array of the result. You can retrieve this identifier with Database.getAsyncLocator(). Retrieve the final result with Database.getAsyncSaveResult().

Usage

Database.insertAsync() methods can’t be executed in the context of a portal user, even when the portal user is a community member. To add external object records via Apex, use Database.insertImmediate() methods.

insertAsync(sobject)

Initiates a request to add external object data to the relevant external system. The request is executed asynchronously, as a background operation, and is sent to the external system that's defined by the external object's associated external data source.

Signature

public static Database.SaveResult insertAsync(SObject sobject)

Parameters

sobject: Type: SObject; The external object record to insert.

Return Value

Status result for the insert operation. The result corresponds to the record processed by this asynchronous operation and is associated with a unique identifier (asyncLocator). The asyncLocator value is included in the errors array of the result. You can retrieve this identifier with Database.getAsyncLocator(). Retrieve the final result with Database.getAsyncSaveResult().

Usage

Database.insertAsync() methods can’t be executed in the context of a portal user, even when the portal user is a community member. To add external object records via Apex, use Database.insertImmediate() methods.

insertImmediate(sobjects)

Initiates requests to add external object data to the relevant external systems. The requests are executed synchronously and are sent to the external systems that are defined by the external objects' associated external data sources. If the Apex transaction contains pending changes, the synchronous operations can't be completed and throw exceptions.

Signature

public static List<Database.SaveResult> insertImmediate(List<SObject> sobjects)

Parameters

sobjects: Type: List<SObject>; List of external object records to insert.

Return Value

Type: List<Database.SaveResult>

Status results for the insert operation.

insertImmediate(sobject)

Initiates a request to add external object data to the relevant external system. The request is executed synchronously and is sent to the external system that's defined by the external object's associated external data source. If the Apex transaction contains pending changes, the synchronous operation can't be completed and throws an exception.

Signature

public static Database.SaveResult insertImmediate(SObject sobject)

Parameters

sobject: Type: SObject; The external object record to insert.

Return Value

Status result for the insert operation.

merge(masterRecord, duplicateId)

Merges the specified duplicate record into the master sObject record of the same type, deleting the duplicate, and reparenting any related records. Merges only accounts, contacts, or leads.

Signature

public static Database.MergeResult merge(sObject masterRecord, Id duplicateId)

Parameters

masterRecord: Type: sObject; The master sObject record the duplicate record is merged into.
duplicateId: Type: ID; The ID of the record to merge with the master. This record must be of the same sObject type as the master.

Return Value

Usage

Each executed merge method counts against the governor limit for DML statements.

merge(masterRecord, duplicateRecord)

Merges the specified duplicate sObject record into the master sObject of the same type, deleting the duplicate, and reparenting any related records.

Signature

public static Database.MergeResult merge(sObject masterRecord, sObject duplicateRecord)

Parameters

masterRecord: Type: sObject; The master sObject record the duplicate record is merged into.
duplicateRecord: Type: sObject; The sObject record to merge with the master. This sObject must be of the same type as the master.

Return Value

Usage

Each executed merge method counts against the governor limit for DML statements.

merge(masterRecord, duplicateIds)

Merges up to two records of the same sObject type into the master sObject record, deleting the others, and reparenting any related records.

Signature

public static List<Database.MergeResult> merge(sObject masterRecord, List<Id> duplicateIds)

Parameters

masterRecord: Type: SObject; The master sObject record the other records are merged into.
duplicateIds: Type: List<Id>; A list of IDs of up to two records to merge with the master. These records must be of the same sObject type as the master.

Return Value

Usage

Each executed merge method counts against the governor limit for DML statements.

merge(masterRecord, duplicateRecords)

Merges up to two records of the same object type into the master sObject record, deleting the others, and reparenting any related records.

Signature

public static List<Database.MergeResult> merge(sObject masterRecord, List<SObject> duplicateRecords)

Parameters

masterRecord: Type: SObject; The master sObject record the other sObjects are merged into.
duplicateRecords: Type: List<SObject>; A list of up to two sObject records to merge with the master. These sObjects must be of the same type as the master.

Return Value

Usage

Each executed merge method counts against the governor limit for DML statements.

merge(masterRecord, duplicateId, allOrNone)

Merges the specified duplicate record into the master sObject record of the same type, optionally returning errors, if any, deleting the duplicate, and reparenting any related records. Merges only accounts, contacts, or leads.

Signature

public static Database.MergeResult merge(sObject masterRecord, Id duplicateId, Boolean allOrNone)

Parameters

masterRecord: Type: sObject; The master sObject record the duplicate record is merged into.
duplicate: Type: ID; The ID of the record to merge with the master. This record must be of the same sObject type as the master.
allOrNone: Type: Boolean; Set to false to return any errors encountered in this operation as part of the returned result. If set to true, this method throws an exception if the operation fails. The default is true.

Return Value

Usage

Each executed merge method counts against the governor limit for DML statements.

merge(masterRecord, duplicateRecord, allOrNone)

Merges the specified duplicate sObject record into the master sObject of the same type, optionally returning errors, if any, deleting the duplicate, and reparenting any related records.

Signature

public static Database.MergeResult merge(sObject masterRecord, sObject duplicateRecord, Boolean allOrNone)

Parameters

masterRecord: Type: sObject; The master sObject record the duplicate record is merged into.
duplicateRecord: Type: sObject; The sObject record to merge with the master. This sObject must be of the same type as the master.
allOrNone: Type: Boolean; Set to false to return any errors encountered in this operation as part of the returned result. If set to true, this method throws an exception if the operation fails. The default is true.

Return Value

Usage

Each executed merge method counts against the governor limit for DML statements.

merge(masterRecord, duplicateIds, allOrNone)

Merges up to two records of the same sObject type into the master sObject record, optionally returning errors, if any, deleting the duplicates, and reparenting any related records.

Signature

public static List<Database.MergeResult> merge(sObject masterRecord, List<Id> duplicateIds, Boolean allOrNone)

Parameters

masterRecord: Type: SObject; The master sObject record the other records are merged into.
duplicateIds: Type: List<Id>; A list of IDs of up to two records to merge with the master. These records must be of the same sObject type as the master.
allOrNone: Type: Boolean; Set to false to return any errors encountered in this operation as part of the returned result. If set to true, this method throws an exception if the operation fails. The default is true.

Return Value

Usage

Each executed merge method counts against the governor limit for DML statements.

merge(masterRecord, duplicateRecords, allOrNone)

Merges up to two records of the same object type into the master sObject record, optionally returning errors, if any, deleting the duplicates, and reparenting any related records.

Signature

public static List<Database.MergeResult> merge(sObject masterRecord, List<SObject> duplicateRecords, Boolean allOrNone)

Parameters

masterRecord: Type: sObject; The master sObject record the other sObjects are merged into.
duplicateRecords: Type: List<SObject>; A list of up to two sObject records to merge with the master. These sObjects must be of the same type as the master.
allOrNone: Type: Boolean; Set to false to return any errors encountered in this operation as part of the returned result. If set to true, this method throws an exception if the operation fails. The default is true.

Return Value

Usage

Each executed merge method counts against the governor limit for DML statements.

query(queryString)

Creates a dynamic SOQL query at runtime.

Signature

public static sObject[] query(String queryString)

Parameters

queryString: Type: String

Return Value

Type: sObject[]

Usage

This method can be used wherever a static SOQL query can be used, such as in regular assignment statements and for loops. Unlike inline SOQL, fields in bind variables are not supported.

For more information, see Dynamic SOQL.

Each executed query method counts against the governor limit for SOQL queries.

rollback(databaseSavepoint)

Restores the database to the state specified by the savepoint variable. Any emails submitted since the last savepoint are also rolled back and not sent.

Signature

public static Void rollback(System.Savepoint databaseSavepoint)

Parameters

databaseSavepoint: Type: System.Savepoint

Return Value

Type: Void

Usage

Note the following:

Static variables are not reverted during a rollback. If you try to run the trigger again, the static variables retain the values from the first run.
Each rollback counts against the governor limit for DML statements. You will receive a runtime error if you try to rollback the database additional times.
The ID on an sObject inserted after setting a savepoint is not cleared after a rollback. Create an sObject to insert after a rollback. Attempting to insert the sObject using the variable created before the rollback fails because the sObject variable has an ID. Updating or upserting the sObject using the same variable also fails because the sObject is not in the database and, thus, cannot be updated.

For an example, see Transaction Control.

setSavepoint()

Returns a savepoint variable that can be stored as a local variable, then used with the rollback method to restore the database to that point.

Signature

public static System.Savepoint setSavepoint()

Return Value

Type: System.Savepoint

Usage

Note the following:

If you set more than one savepoint, then roll back to a savepoint that is not the last savepoint you generated, the later savepoint variables become invalid. For example, if you generated savepoint SP1 first, savepoint SP2 after that, and then you rolled back to SP1, the variable SP2 would no longer be valid. You will receive a runtime error if you try to use it.
References to savepoints cannot cross trigger invocations because each trigger invocation is a new trigger context. If you declare a savepoint as a static variable then try to use it across trigger contexts, you will receive a run-time error.
Each savepoint you set counts against the governor limit for DML statements.

For an example, see Transaction Control.

undelete(recordToUndelete, allOrNone)

Restores an existing sObject record, such as an individual account or contact, from your organization's Recycle Bin.

Signature

public static Database.UndeleteResult undelete(sObject recordToUndelete, Boolean allOrNone)

Parameters

recordToUndelete: Type: sObject
allOrNone: Type: Boolean; The optional allOrNone parameter specifies whether the operation allows partial success. If you specify false for this parameter and a record fails, the remainder of the DML operation can still succeed. This method returns a result object that can be used to verify which records succeeded, which failed, and why. If the parameter is not set or is set true, an exception is thrown if the method is not successful.

Return Value

Type: Database.UndeleteResult

Usage

undelete is analogous to the UNDELETE statement in SQL.

Each executed undelete method counts against the governor limit for DML statements.

undelete(recordsToUndelete, allOrNone)

Restores one or more existing sObject records, such as individual accounts or contacts, from your organization’s Recycle Bin.

Signature

public static Database.UndeleteResult[] undelete(sObject[] recordsToUndelete, Boolean allOrNone)

Parameters

recordsToUndelete: Type: sObject []
allOrNone: Type: Boolean; The optional allOrNone parameter specifies whether the operation allows partial success. If you specify false for this parameter and a record fails, the remainder of the DML operation can still succeed. This method returns a result object that can be used to verify which records succeeded, which failed, and why. If the parameter is not set or is set true, an exception is thrown if the method is not successful.

Return Value

Type: Database.UndeleteResult[]

Usage

undelete is analogous to the UNDELETE statement in SQL.

Each executed undelete method counts against the governor limit for DML statements.

Example

The following example restores all accounts named 'Universal Containers'. The ALL ROWS keyword queries all rows for both top-level and aggregate relationships, including deleted records and archived activities.

1Account[] savedAccts = [SELECT Id, Name FROM Account 
2                                                                   WHERE Name = 'Universal Containers' ALL ROWS];
3Database.UndeleteResult[] UDR_Dels = Database.undelete(savedAccts);

undelete(recordID, allOrNone)

Restores an existing sObject record, such as an individual account or contact, from your organization's Recycle Bin.

Signature

public static Database.UndeleteResult undelete(ID recordID, Boolean allOrNone)

Parameters

recordID: Type: ID
allOrNone: Type: Boolean; The optional allOrNone parameter specifies whether the operation allows partial success. If you specify false for this parameter and a record fails, the remainder of the DML operation can still succeed. This method returns a result object that can be used to verify which records succeeded, which failed, and why. If the parameter is not set or is set true, an exception is thrown if the method is not successful.

Return Value

Type: Database.UndeleteResult

Usage

undelete is analogous to the UNDELETE statement in SQL.

Each executed undelete method counts against the governor limit for DML statements.

undelete(recordIDs, allOrNone)

Restores one or more existing sObject records, such as individual accounts or contacts, from your organization’s Recycle Bin.

Signature

public static Database.UndeleteResult[] undelete(ID[] recordIDs, Boolean allOrNone)

Parameters

RecordIDs: Type: ID[]
allOrNone: Type: Boolean; The optional allOrNone parameter specifies whether the operation allows partial success. If you specify false for this parameter and a record fails, the remainder of the DML operation can still succeed. This method returns a result object that can be used to verify which records succeeded, which failed, and why. If the parameter is not set or is set true, an exception is thrown if the method is not successful.

Return Value

Type: Database.UndeleteResult[]

Usage

undelete is analogous to the UNDELETE statement in SQL.

Each executed undelete method counts against the governor limit for DML statements.

update(recordToUpdate, allOrNone)

Modifies an existing sObject record, such as an individual account or contact, in your organization's data.

Signature

public static Database.SaveResult update(sObject recordToUpdate, Boolean allOrNone)

Parameters

recordToUpdate: Type: sObject
allOrNone: Type: Boolean; The optional allOrNone parameter specifies whether the operation allows partial success. If you specify false for this parameter and a record fails, the remainder of the DML operation can still succeed. This method returns a result object that can be used to verify which records succeeded, which failed, and why. If the parameter is not set or is set true, an exception is thrown if the method is not successful.

Return Value

Usage

update is analogous to the UPDATE statement in SQL.

Apex classes and triggers saved (compiled) using API version 15.0 and higher produce a runtime error if you assign a String value that is too long for the field.

Each executed update method counts against the governor limit for DML statements.

Example

The following example updates the BillingCity field on a single account.

1Account a = new Account(Name='SFDC');
2insert(a);
3
4Account myAcct =
5  [SELECT Id, Name, BillingCity
6   FROM Account WHERE Id = :a.Id];
7myAcct.BillingCity = 'San Francisco';
8
9Database.SaveResult SR =
10  Database.update(myAcct);

update(recordsToUpdate, allOrNone)

Modifies one or more existing sObject records, such as individual accounts or contactsinvoice statements, in your organization’s data.

Signature

public static Database.SaveResult[] update(sObject[] recordsToUpdate, Boolean allOrNone)

Parameters

recordsToUpdate: Type: sObject []
allOrNone: Type: Boolean; The optional allOrNone parameter specifies whether the operation allows partial success. If you specify false for this parameter and a record fails, the remainder of the DML operation can still succeed. This method returns a result object that can be used to verify which records succeeded, which failed, and why. If the parameter is not set or is set true, an exception is thrown if the method is not successful.

Return Value

Usage

update is analogous to the UPDATE statement in SQL.

Each executed update method counts against the governor limit for DML statements.

update(recordToUpdate, dmlOptions)

Modifies an existing sObject record, such as an individual account or contact, in your organization's data.

Signature

public static Database.SaveResult update(sObject recordToUpdate, Database.DmlOptions dmlOptions)

Parameters

recordToUpdate: Type: sObject
dmlOptions: Type: Database.DMLOptions; The optional dmlOptions parameter specifies additional data for the transaction, such as assignment rule information or rollback behavior when errors occur during record insertions.

Return Value

Usage

update is analogous to the UPDATE statement in SQL.

Apex classes and triggers saved (compiled) using API version 15.0 and higher produce a runtime error if you assign a String value that is too long for the field.

Each executed update method counts against the governor limit for DML statements.

update(recordsToUpdate, dmlOptions)

Modifies one or more existing sObject records, such as individual accounts or contactsinvoice statements, in your organization’s data.

Signature

public static Database.SaveResult[] update(sObject[] recordsToUpdate, Database.DMLOptions dmlOptions)

Parameters

recordsToUpdate: Type: sObject []
dmlOptions: Type: Database.DMLOptions; The optional dmlOptions parameter specifies additional data for the transaction, such as assignment rule information or rollback behavior when errors occur during record insertions.

Return Value

Usage

update is analogous to the UPDATE statement in SQL.

Apex classes and triggers saved (compiled) using API version 15.0 and higher produce a runtime error if you assign a String value that is too long for the field.

Each executed update method counts against the governor limit for DML statements.

upsert(recordToUpsert, externalIdField, allOrNone)

Creates a new sObject record or updates an existing sObject record within a single statement, using a specified field to determine the presence of existing objects, or the ID field if no field is specified.

Signature

public static Database.UpsertResult upsert(sObject recordToUpsert, Schema.SObjectField externalIDField, Boolean allOrNone)

Parameters

recordToUpsert: Type: sObject
externalIdField: Type: Schema.SObjectField; The externalIdField is of type Schema.SObjectField, that is, a field token. Find the token for the field by using the fields special method. For example, Schema.SObjectField f = Account.Fields.MyExternalId. The externalIdField parameter is the field that upsert() uses to match sObjects with existing records. This field can be a custom field marked as external ID, or a standard field with the idLookup attribute.
allOrNone: Type: Boolean; The optional allOrNone parameter specifies whether the operation allows partial success. If you specify false for this parameter and a record fails, the remainder of the DML operation can still succeed. This method returns a result object that can be used to verify which records succeeded, which failed, and why. If the parameter is not set or is set true, an exception is thrown if the method is not successful.

Return Value

Type: Database.UpsertResult

Usage

Apex classes and triggers saved (compiled) using API version 15.0 and higher produce a runtime error if you assign a String value that is too long for the field.

Each executed upsert method counts against the governor limit for DML statements.

For more information on how the upsert operation works, see the upsert() statement.

upsert(recordsToUpsert, externalIdField, allOrNone)

Creates new sObject records or updates existing sObject records within a single statement, using a specified field to determine the presence of existing objects, or the ID field if no field is specified.

Signature

public static Database.UpsertResult[] upsert(sObject[] recordsToUpsert, Schema.SObjectField externalIdField, Boolean allOrNone)

Parameters

recordsToUpsert: Type: sObject []
externalIdField: Type: Schema.SObjectField; The externalIdField is of type Schema.SObjectField, that is, a field token. Find the token for the field by using the fields special method. For example, Schema.SObjectField f = Account.Fields.MyExternalId. The externalIdField parameter is the field that upsert() uses to match sObjects with existing records. This field can be a custom field marked as external ID, or a standard field with the idLookup attribute.
allOrNone: Type: Boolean; The optional allOrNone parameter specifies whether the operation allows partial success. If you specify false for this parameter and a record fails, the remainder of the DML operation can still succeed. This method returns a result object that can be used to verify which records succeeded, which failed, and why. If the parameter is not set or is set true, an exception is thrown if the method is not successful.

Return Value

Type: Database.UpsertResult[]

Usage

Apex classes and triggers saved (compiled) using API version 15.0 and higher produce a runtime error if you assign a String value that is too long for the field.

Each executed upsert method counts against the governor limit for DML statements.

For more information on how the upsert operation works, see the upsert() statement.

updateAsync(sobjects, callback)

Initiates requests to update external object data on the relevant external systems. The requests are executed asynchronously, as background operations, and are sent to the external systems that are defined by the external objects' associated external data sources. Allows referencing a callback class whose processSave method is called for each record after the remote operations are completed.

Signature

public static List<Database.SaveResult> updateAsync(List<SObject> sobjects, DataSource.AsyncSaveCallback callback)

Parameters

sobjects: Type: List<SObject>; List of external object records to modify.
callback: Type: DataSource.AsyncSaveCallback; The callback object that contains the state in the originating context and an action (the processSave method) that executes after the insert operation is completed. Use the action callback to update org data according to the operation’s results. The callback object must extend DataSource.AsyncSaveCallback.

Return Value

Type: List<Database.SaveResult>

Status results for the update operation. Each result corresponds to a record processed by this asynchronous operation and is associated with a unique identifier (asyncLocator). The asyncLocator value is included in the errors array of the result. You can retrieve this identifier with Database.getAsyncLocator(). Retrieve the final result with Database.getAsyncSaveResult().

updateAsync(sobject, callback)

Initiates a request to update external object data on the relevant external system. The request is executed asynchronously, as a background operation, and is sent to the external system that's defined by the external object's associated external data source. Allows referencing a callback class whose processSave method is called after the remote operation is completed.

Signature

public static Database.SaveResult updateAsync(SObject sobject, DataSource.AsyncSaveCallback callback)

Parameters

sobject: Type: SObject; External object record to modify.
callback: Type: DataSource.AsyncSaveCallback; The callback object that contains the state in the originating context and an action (the processSave method) that executes after the insert operation is completed. Use the action callback to update org data according to the operation’s results. The callback object must extend DataSource.AsyncSaveCallback.

Return Value

Status result for the insert operation. The result corresponds to a record processed by this asynchronous operation and is associated with a unique identifier (asyncLocator). The asyncLocator value is included in the errors array of the result. You can retrieve this identifier with Database.getAsyncLocator(). Retrieve the final result with Database.getAsyncSaveResult().

updateAsync(sobjects)

Initiates requests to update external object data on the relevant external systems. The requests are executed asynchronously, as background operations, and are sent to the external systems that are defined by the external objects' associated external data sources.

Signature

public static List<Database.SaveResult> updateAsync(List<SObject> sobjects)

Parameters

sobjects: Type: List<SObject>; List of external object records to modify.

Return Value

Type: List<Database.SaveResult>

Status results for the update operation. Each result corresponds to a record processed by this asynchronous operation and is associated with a unique identifier (asyncLocator). The asyncLocator value is included in the errors array of the result. You can retrieve this identifier with Database.getAsyncLocator(). Retrieve the final result with Database.getAsyncSaveResult().

updateAsync(sobject)

Initiates a request to update external object data on the relevant external system. The request is executed asynchronously, as a background operation, and is sent to the external system that's defined by the external object's associated external data source.

Signature

public static Database.SaveResult updateAsync(SObject sobject)

Parameters

sobject: Type: SObject; External object record to modify.

Return Value

Status result for the insert operation. The result corresponds to a record processed by this asynchronous operation and is associated with a unique identifier (asyncLocator). The asyncLocator value is included in the errors array of the result. You can retrieve this identifier with Database.getAsyncLocator(). Retrieve the final result with Database.getAsyncSaveResult().

updateImmediate(sobjects)

Initiates requests to update external object data on the relevant external systems. The requests are executed synchronously and are sent to the external systems that are defined by the external objects' associated external data sources. If the Apex transaction contains pending changes, the synchronous operations can't be completed and throw exceptions.

Signature

public static List<Database.SaveResult> updateImmediate(List<SObject> sobjects)

Parameters

sobjects: Type: List<SObject>; List of external object records to modify.

Return Value

Type: List<Database.SaveResult>

Status results for the update operation.

updateImmediate(sobject)

Initiates a request to update external object data on the relevant external system. The request is executed synchronously and is sent to the external system that's defined by the external object's associated external data source. If the Apex transaction contains pending changes, the synchronous operation can't be completed and throws an exception.

Signature

public static Database.SaveResult updateImmediate(SObject sobject)

Parameters

sobject: Type: SObject; External object record to modify.

Return Value