Deleting Multiple Objects

This API deletes multiple objects in a data table with a single request. Consider the following example, it demonstrates an API call which deletes all objects in the Person data table where the value of the age property is greater than 20:

Objective-CSwift

MapDrivenDataStore *dataStore = [Backendless.shared.data ofTable:@"Person"];
[dataStore removeBulkWithWhereClause:@"age > 20" responseHandler:^(NSNumber *removed) {
    NSLog(@"%@ objects have been removed", removed);
} errorHandler:^(Fault *fault) {
    NSLog(@"Error: %@", fault.message);
}];

let dataStore = Backendless.shared.data.ofTable("Person")
dataStore.removeBulk(whereClause: "age > 20", responseHandler: { removed in
    print("\(removed) objects have been removed")
}, errorHandler: { fault in
    print("Error: \(fault.message ?? "")")
})

Available methods

Custom Class ApproachDictionary/Map Approach

Objective-CSwift

- (void) removeBulkWithWhereClause:(NSString * _Nullable)whereClause responseHandler:^(NSNumber * _Nonnull)responseHandler errorHandler:^(Fault * _Nonnull)errorHandler;

func removeBulk(whereClause: String?, responseHandler: ((NSNumber) -> Void)!, errorHandler: ((Fault) -> Void)!)

Objective-CSwift

- (void) removeBulkWithWhereClause:(NSString * _Nullable)whereClause responseHandler:^(NSNumber * _Nonnull)responseHandler errorHandler:^(Fault * _Nonnull)errorHandler;

func removeBulk(whereClause: String?, responseHandler: ((NSNumber) -> Void)!, errorHandler: ((Fault) -> Void)!)

where:

Argument	Description
whereClause	a condition for selecting objects in the data table which will be deleted.
responseHandler	a block (closure) to handle successful result of an asynchronous call.
errorHandler	a block (closure) to handle fault result of an asynchronous call.

Return Value

The API returns the number of objects deleted in the database as a result of the request.

Codeless Reference

where:

Argument	Description
table name	Name of the data table where objects will be deleted from.
where clause	A condition for selecting objects to be deleted in the data table. Refer to the Search With The Where Clause topic for more information.

Returns the number of deleted objects.

Consider the following records in the employees data table:

The example below is set to delete all values from the position column that match the where clause condition, (e.g. 'Manager'). In this case, the condition acts like a filter and deletes all values that match the criteria 'Manager'.

The result of this operation will look as shown below after the Codeless logic runs. As you can see, two records containing the 'Manager' value in the position column were deleted from the data table.

Also, the operation has returned the number 2, indicating the number of deleted objects in the employees data table.