OfflineObjectService Class

Provides methods that perform operations acting on the sync database, including basic CRUD, metadata, and binary-related functions. An instance of OfflineObjectService is returned by the getObjectService Method when the second parameter specifies {"access":"offline"}.

Methods

The following methods are used by the OfflineObjectService class and its instantiations.

create Method

Creates an object offline in the sync database.

Syntax

 create(options, successCallback, failureCallback);

Parameters

Parameter	Description
options	JSON object with the mandatory parameter "dataObject", which must be an instance of the kony.sdk.dto.DataObject Class
successCallback	Function invoked when the operation succeeds, with the primary key of the created object
failureCallback	Function invoked when the operation fails, with cause of failure

Example

 function create() { 
    var objSvc = kony.sdk.getCurrentInstance().getObjectService("serviceName", {
        "access": "offline"
    }); 
    var dataObject = new kony.sdk.dto.DataObject("ObjectName"); 
    dataObject.addField("field1", "value1"); 
    var options = {
        "dataObject": dataObject
    }; 
    objSvc.create(options,     function(res) {
        alert("Record created");
    },     function(err) {
        alert("Error in record creation");
    }  );
}

NOTE: When using object services for SAP, the general norm is to have character field values stored in upper case. However, if you need to pass in mixed/lower case values for an SAP field, ensure that this field is designated as mixed case in the SAP Add-in LDB workbench.

update Method

Updates an object offline in the sync database (local store).

Syntax

 update(options, successCallback, failureCallback);

Parameters

Parameter	Description
options	JSON object with the mandatory parameter "dataObject", which must be an instance of the kony.sdk.dto.DataObject Class
successCallback	Function invoked when the operation succeeds, with the number of records updated
failureCallback	Function invoked when the operation fails, with cause of failure

Example

 function update() { 
    var objSvc = kony.sdk.getCurrentInstance().getObjectService("serviceName", {
        "access": "offline"
    }); 
    var dataObject = new kony.sdk.dto.DataObject("ObjectName"); 
    dataObject.addField("field1", "value1"); 
    dataObject.addField("primaryKeyField", "value"); 
    var options = {
        "dataObject": dataObject
    }; 
    objSvc.update(options,     function(res) {
        alert("Record updated");
    },     function(err) {
        alert("Error in record update");
    }  );
}

delete Method

Deletes an object offline in the sync database.

Syntax

 deleteRecord(options, successCallback, failureCallback);

Parameters

Parameter	Description
options	JSON object with the mandatory parameter "dataObject", which must be an instance of the kony.sdk.dto.DataObject Class
successCallback	Function invoked when the operation succeeds, with the number of records deleted
failureCallback	Function invoked when the operation fails, with cause of failure

Example

 function deleteRecord() { 
    var objSvc = kony.sdk.getCurrentInstance().getObjectService("serviceName", {
        "access": "offline"
    }); 
    var dataObject = new kony.sdk.dto.DataObject("ObjectName"); 
    dataObject.addField("field1", "value1"); 
    dataObject.addField("primaryKeyField", "value"); 
    var options = {
        "dataObject": dataObject
    }; 
    objSvc.deleteRecord(options,     function(res) {
        alert("Record deleted");
    },     function(err) {
        alert("Error in record deletion");
    }  );
}

getMetadataOfAllObjects Method

Gets the metadata associated with the objects defined in the service from the local store.

Syntax

 getMetadataOfAllObjects(options, successCallback, failureCallback);

Parameters

Parameter	Description
options	JSON object with the optional parameter "getFromServer"
successCallback	Function invoked when the operation succeeds, with the number of records updated
failureCallback	Function invoked when the operation fails, with cause of failure

Example

 function getMetadata() { 
    var objSvc = kony.sdk.getCurrentInstance().getObjectService("serviceName", {
        "access": "offline"
    });  
    objSvc.getMetadataOfAllObjects({},     function(res) {
        alert("Metadata::" + res);
    },     function(err) {
        alert("Error in metadata::" + err);
    }  );
}

getMetadataOfObject Method

Gets the metadata associated with an object defined in the service from the local store.

Syntax

 getMetadataOfObject(objectName, options, successCallback, failureCallback);

Parameters

Parameter	Description
objectName	The name of the desired object as defined in the service
options	JSON object with the optional parameter "getFromServer"
successCallback	Function invoked when the operation succeeds, with the number of records returned
failureCallback	Function invoked when the operation fails, with cause of failure

Example

 function getMetadata() { 
    var objSvc = kony.sdk.getCurrentInstance().getObjectService("serviceName", {
        "access": "offline"
    });  
    objSvc.getMetadataOfObject("objectName", {},     function(res) {
        alert("Metadata::" + res);
    },     function(err) {
        alert("error in metadata::" + err);
    }  );
}

executeSelectQuery Method

Executes a Select query on the sync database.

Syntax

 executeSelectQuery(queryString, successCallback, failureCallback);

Parameters

Parameter	Description
queryString	SQL Select query string
successCallback	Function invoked when the operation succeeds, with the number of records operated on
failureCallback	Function invoked when the operation fails, with cause of failure

Example

 function executeSelectQuery() { 
    var objSvc = kony.sdk.getCurrentInstance().getObjectService("serviceName", {
        "access": "offline"
    });  
    var queryString = "select * from table";  
    objSvc.executeSelectQuery(queryString,     function(res) {
        alert("Metadata::" + res);
    },     function(err) {
        alert("Error in metadata::" + err);
    }  );
}

getBinaryContent Method

Gets binary content from the sync database.

Syntax

 getBinaryContent(options, successCallback, failureCallback);

Parameters

Parameter	Description
options	JSON object with the mandatory parameter "dataObject", which is an instance of the kony.sdk.dto.DataObject Class
successCallback	Function invoked when the operation succeeds, with the number of records gotten
failureCallback	Function invoked when the operation fails, with cause of failure

Example

 function getBinaryContent() { 
    var objSvc = kony.sdk.getCurrentInstance().getObjectService("serviceName", {
        "access": "offline"
    });  
    var dataObject = new kony.sdk.dto.DataObject("media");  
    //primary key details to get media object  
    dataObject.addField("name", "4005174-002");  
    var options = {};  
    options.dataObject = dataObject;  
    //binary column name to get the binary data  
    options.binaryAttrName = "data";  
    options.responsetype = "base64string/filepath";  
    //filepath is default if it is not set by developer  
    objSvc.getBinaryContent(options, successcallback, errorcallback);  

    function successcallback(response) {    
        //response will contain base64string or filepath    
        //  based on responsetype   
        //value provided by the developer.   
        var content = response.records[0].data;  
    }  

    function errorcallback(err) {
        Alert(err);
    }
}