Volt MX Foundry console User Guide: Application-level APIs > VMXFoundry.OfflineObjects.executeSelectQuery

VMXFoundry.OfflineObjects.executeSelectQuery

The application-level API, executeSelectQuery allows the user to execute any select query on device database. The API executes the query provided as an argument on the device database and returns the response in successCallback.

The failureCallback is invoked in case of errors such as invalid query and so on.

Note: executeSelectQuery should be preferred only if the object-level read API is not able to serve the purpose such as join based select queries or complex SQL queries.

Note: executeSelectQuery supports only read or select queries. The API does not support create or update or delete operations on the device database.

Volt MX Iris (JavaScript)

Note: Not supported for Mobile Web, and Desktop Web channels.

Signature

VMXFoundry.OfflineObjects.executeSelectQuery(query, successCallback, failureCallback)

Parameters

Return Type

void

Example

function successCallback(response) {
//response contains records returned from device db for query executed.
}

function failureCallback(error) {
voltmx.print("executeSelectQuery failed with error:" + error.code);
}
var query = "Select \* from Employee where EmployeeID=5";
VMXFoundry.OfflineObjects.executeSelectQuery(query, successCallback, failureCallback);

Android (Java)

Signature

void <OfflineObjects>.executeSelectQuery(String query, final VMXCallback callback)

Parameters

Return Type

void

Example

VoltMXClient sdk = new VoltMXClient();
IVoltMXApplicationSync appSync = sdk.getOfflineObjects();
String query = "Select \* from Employee where EmployeeID=5";
appSync.executeSelectQuery(query, new VMXCallback() {
@Override
public void onSuccess(Object object) {
//response contains records returned from device db for query executed.
}
@Override
public void onFailure(Object error) {
OfflineObjectsException e = (OfflineObjectsException) error;
Log.d("executeSelectQuery", "executeSelectQuery failed with error:" + e.getMessage() + "callstack: " + e.getStackTrace());
}
});

iOS (Objective C)

Signature

(void) <OfflineObjects>.executeSelectQuery:(NSString \*)query
onSuccess:(VMXSuccessCompletionHandler)onSuccess
onFailure:(VMXFailureCompletionHandler)onFailure

Parameters

Return Type

void

Example

VMXClient _ sdk = [VMXClient sharedClient];
OfflineObjects _ applicationSync = [sdk getOfflineObjects];
NSString _ query = @"Select _ from Employee where EmployeeID=5"
VMXSuccessCompletionHandler onSuccess = ^ void(id object) {
NSLog(@"executeSelectQuery successful");
};

VMXFailureCompletionHandler onFailure = ^ void(id object) {
NSLog(@"executeSelectQuery failed");
};
[applicationSync executeSelectQuery: query
onSuccess: onSuccess
onFailure: onFailure
];