kony Namespace

Converts rawbytes (returned by the camera or the encryption API) to a base64 encoded string.

Syntax

kony.convertToBase64 (rawbytes);

Input Parameters

Example

var base64 = "MIICKTCCAZKgAwIBAgIESrI6bzANBgkqhkiG9w0BAQUFADBZMQswCQYDVQQGEwJp
bjELMAkGA1UECBMCYXAxDDAKBgNVBAcTA2h5ZDENMAsGA1UEChMEa29ueTENMAsGA1UECxMEa29ue
TERMA8GA1UEAxMIcGF0dGFiaGkwHhcNMDkwOTE3MTMzMjMxWhcNMDkxMjE2MTMzMjMxWjBZMQswCQ
YDVQQGEwJpbjELMAkGA1UECBMCYXAxDDAKBgNVBAcTA2h5ZDENMAsGA1UEChMEa29ueTENMAsGA1U
ECxMEa29ueTERMA8GA1UEAxMIcGF0dGFiaGkwgZ8wDQYJKoZIhvcNAQEBBQADgY0AMIGJAoGBAIGP
dqCQCtFgsy1sM494o1F07aN+UXgsilTuKsNRExOb03RGrg2WpAI8PqMXD1XzGZAg+qC9iQexpWHUj
XgCYCbYrETvB3wNAToOrRE6mhZ0iaJij/0tLZACocLiTnvmzZU1B/xowvlioD3zsEs5N5n0U0fIsv
W/22MZ6WtZuAZTAgMBAAEwDQYJKoZIhvcNAQEFBQADgYEAXfOB1Mhx2R9ameeZz0hvCzYYSGcWsWN
ZaM7lMdBHFPzASYcVrmLj7JlLpuMm679A2p2JwXBsfetmhKse1ixqVeWdbe/FUfESU+8Krdvkcknv
ZaDqXYFxQAaVjTwWOn+zcDHf7LjjDohgDsMOJWXHkVQj2jooXqiktrBrpccm864=";
var rawBytes = kony.convertToRawBytes(base64);		
var newbase64 = kony.convertToBase64(rawBytes);

Return Values

The encoded base64 string that was converted from the provided rawbytes. This converted encoded base64 string can be displayed on the screen to the user whenever required as this string is readable. If the conversion could not be performed, this function returns null.

Exceptions

An error is thrown if the input type is invalid or follows an unexpected structure.

102-Invalid input error

Remarks

The rawbytes returned by the camera or the encryption API are a set of junk characters that are not readable. When you want to display this data in a readable format to the user, you can use this API.

Platform Availability

Available on all platforms except Desktop Web.

Provides your app with the ability to read rawbytes from a base 64 encoded string.

Syntax

kony.convertToRawBytes(base64String);

Input Parameters

Example

var base64 = "MIICKTCCAZKgAwIBAgIESrI6bzANBgkqhkiG9w0BAQUFADBZMQswCQYDVQQGEwJpbjELMAkGA1UECBMCYXAxDDAKBgNVBAcTA2h5ZDENMAsGA1UEChMEa29ueTENMAsGA1UECxMEa29ueTERMA8GA1UEAxMIcGF0dGFiaGkwHhcNMDkwOTE3MTMzMjMxWhcNMDkxMjE2MTMzMjMxWjBZMQswCQYDVQQGEwJpbjELMAkGA1UECBMCYXAxDDAKBgNVBAcTA2h5ZDENMAsGA1UEChMEa29ueTENMAsGA1UECxMEa29ueTERMA8GA1UEAxMIcGF0dGFiaGkwgZ8wDQYJKoZIhvcNAQEBBQADgY0AMIGJAoGBAIGPdqCQCtFgsy1sM494o1F07aN+UXgsilTuKsNRExOb03RGrg2WpAI8PqMXD1XzGZAg+qC9iQexpWHUjXgCYCbYrETvB3wNAToOrRE6mhZ0iaJij/0tLZACocLiTnvmzZU1B/xowvlioD3zsEs5N5n0U0fIsv
W/22MZ6WtZuAZTAgMBAAEwDQYJKoZIhvcNAQEFBQADgYEAXfOB1Mhx2R9ameeZz0hvCzYYSGcWsWNZaM7lMdBHFPzASYcVrmLj7JlLpuMm679A2p2JwXBsfetmhKse1ixqVeWdbe/FUfESU+8Krdvkcknv
ZaDqXYFxQAaVjTwWOn+zcDHf7LjjDohgDsMOJWXHkVQj2jooXqiktrBrpccm864=";
kony.convertToBase64(myVal);
var rawBytes = kony.convertToRawBytes(base64);		

Return Values

This API returns the modified rawbytes of the image. The data type of the rawbytes varies per platform. In JavaScript, there is no specific type for rawbytes and every platform represents the rawbytes in a unique way.

If the base64String parameter does not contain a valid value, this function returns null.

Exceptions

An error occurs if input type is invalid or does not follow the expected structure.

Platform Availability

Available on all platforms except Desktop Web.

The kony.evaluateJavaScriptInNativeContext API enables a web app JavaScript module, which is running in the Browser widget, to execute JavaScript code in the Kony native context. This API works only when the enableNativeCommunication property of the Browser / CordovaBrowser widget is set to true.

NOTE: This API is applicable for the widgets Browser and CordovaBrowser.

Syntax

The syntax of the API varies depending on the application type.

The syntax for native platforms is as follows.

kony.evaluateJavaScriptInNativeContext(methodName, args);

The syntax for Desktop Web platform is as follows.

kony.evaluateJavaScriptInNativeContext(methodName('args'));

Input Parameters

Remarks

When you enable the contentLoadsKonyWeb property, you must use the konyNative namespace (in your web app) to invoke the evaluateJavaScriptInNativeContext API on the parent native app as follows:

konyNative.evaluateJavaScriptInNativeContext("methodname",JSON.stringify(arr_of_arguments));

Example 1

/*In this sample code, the evaluateJavaScriptInNativeContext API invokes the noparamsfunction method in the native context without any parameters.*/
var arr = [];
kony.evaluateJavaScriptInNativeContext("noparamsfunction", JSON.stringify(arr));

//function definition in modules
function noparamsfunction() {
    alert("noparamsfunction invoked");
}

//Output: Displays an alert with message "noparamsfunction invoked".

Example 2

/*In this sample code, the evaluateJavaScriptInNativeContext API invokes the twoparamsfunction method in the native context with two parameters.*/
/*Here, the arr Array contains all the arguments required for invoking the twoparamsfunction method.*/

var arr = [];
//First Argument
arr.push("hi");
//Second Argument
arr.push("helloworld");

kony.evaluateJavaScriptInNativeContext("twoparamsfunction", JSON.stringify(arr));

//Function definition in the modules section of the project.
function twoparamsfunction (arg1, arg2){
alert("twoparamsfunction invoked with arg1: "+arg1+" and arg2: "+arg2);
}
/*Output: Displays an alert with the following message:
"twoparamsfunction invoked with arg1: hi and arg2: helloworld".*/

Example 3

/*Sample code for the implementation of the evaluateJavaScriptInNativeContext
 API in the Desktop Web platform.*/

var arr = [];
arr.push("hello world");
kony.evaluateJavaScriptInNativeContext ('sampleMethod('+JSON.stringify(arr)+')');

//Function method in modules
function sampleMethod(arg1){
alert("sampleMethod invoked with the parameter: "+arg1);
}
/*Output: Displays an alert with the following message:
"sampleMethod invoked with the parameter: hello world"*/

Return Values

None

Platform Availability

• iOS
• Android
• Desktop Web

Retrieves an error object from a handle to the error object.

Syntax

kony.getError(error);

Input Parameters

Example

try {
    // Label to check UserData Type.
    var basicconf = {
        id: "lblWithUserData",
        text: "userdata",
        isVisible: true,
        skin: "sknlbl"
    };
    var layoutconf = {
        containerWeight: 100,
        hExpand: true,
        vExpand: true
    };
    var lbl1 = new kony.ui.Label(basicconf, layoutconf, {});

    hbox.add(lbl1);
} catch (e) {
    var err = kony.getError(e);

    if (err instanceof KonyError)

        alert("A Kony error");
    else if(err instanceof EvalError)
    alert("A JavaScript Eval Eror");
}

Return Values

Returns the JavaScript error object.

Exceptions

If the input type is invalid or there is an unexpected structure.

Remarks

Use getError APIs for cross platform applications to handle exceptions consistently.

Platform Availability

Available on all platforms.

Prints debugging output.

Syntax

kony.print(myString);

Input Parameters

Example

kony.print("This is a test message.");

Return Values

None.

Remarks

If any other type of argument is passed a string representation of that input is passed. It prints the value to the Standard Output specific to the platform. It prints their values to stdout, using the tostring function to convert them to strings. print is not intended for formatted output, but only as a quick way to show a value, typically for debugging. For formatted output, use string.format.

Platform Availability

Available on all platforms.

This API helps you run the JavaScript code on the main thread. It is an asynchronous API. It posts a message to the main thread to invoke a function f with parameters arguments.

NOTE: If runonMainThread is invoked in a JavaScript function that is already running on the main thread, then the function is executed in synchronous mode.

Syntax

kony.runOnMainThread (f, args);

Input Parameters

Example

kony.runOnMainThread(mainthread, []);
function mainthread () {
   kony.print ("Running on On Main Thread");
}

Return Values

None

Platform Availability

• Android
• iOS

Provides apps with multithreading capabilities.

Syntax

kony.runOnWorkerThread(f,args);

Input Parameters

Example

kony.runOnWorkerThread(workermethod, []);
function workermethod () {
   kony.print ("Running on On Worker Thread");
}

Return Values

None.

Remarks

This function helps you run JavaScript code asynchronously on a worker thread. It posts a message to the worker thread that owns the current JavaScript context to invoke the function specified in the f parameter.

IMPORTANT: The assumption here is that main thread does not own any JavaScript context. The VM/closure thread and worker threads own the JavaScript context. When the kony.runOnWorkerThread is invoked from the main thread, a message is posted to the thread that originally invoked the kony.runOnMainThread. If the runonWorkerThread is invoked in a JavaScript function that is already running on the worker thread, then the function would be executed in synchronous mode.

Platform Availability

• Android
• iOS

You can use the kony.screenshot API to capture the whole web page or screen of your application.

Syntax

kony.screenshot(config);

Input Parameters

config

The config parameter consists of a JavaScript object. It contains the following attribute.

Example

config = {
"callback": function(imageData) {
  kony.print(imageData);
 } //The imageData parameter contains the base64 String of the screenshot.
};
kony.screenshot(config);

Return Values

None

Important Considerations

• When you use the kony.screenshot API to get a screenshot of your web browser, the screen capture does not include the images and videos that use an external URL.
• When you use the kony.screenshot API to get a screen capture, the scrollable containers (such as FlexScrollContainer and Segment) do not display the whole content. The screen capture only displays the content within the height of the scrollable containers.

Platform Availability

• Desktop Web (Google Chrome (v72 and later),Mozilla FireFox (v66), Opera (v60), Microsoft Edge, and Safari).

Use this API to stop displaying the native Android Splash Screen that was enabled by the continueNativeSplashScreen property.

Syntax

kony.exitNativeSplashScreen();

Input Parameters

None.

Example

kony.exitNativeSplashScreen();

Return Values

None.

Remarks

The kony.exitNativeSplashScreen API and the continueNativeSplashScreen property do not work appropriately in the Debug build mode. Ensure that you set the Build Mode as Release or Protected while using the API.

Platform Availability

• Android

This API retrieves the data type of the specified input. The possible return values in JavaScript are:

• string
• number
• boolean
• function
• userdata - not JavaScript type but the platform specific type that platform returns and consumes like rawBytes.
• In case of kony custom objects, this API returns the fully qualified name of the class from which object is instantiated. for e.g kony.ui.Form2
• null

Use the typeof operator instead of kony.type to achieve the same result. If the typeof operator cannot be used, use kony.type instead.

Syntax

kony.type(variable);

Input Parameters

Example

var myVal = 2000;
var varType = kony.type(myVal);//Returns a number
var myVal1 = "hello";
var varType = kony.type(myVal1);//Returns a string

Return Values

returnValue [String]

Returns a string that determines the data type of the specified input. Possible values are:

In case of kony custom objects, this API returns the fully qualified name of the class from which object is instantiated. for e.g kony.ui.Form2. When you pass any custom / built in JSObject to this API, it should return the name of the custom JSObject.

Platform Availability

Available on all platforms.

This API helps you to manage the sharing of a one-time login credentials between the Safari web browser and an app. The one-time login credentials can also be used to automatically log on to associated apps. The kony.web.WebAuthenticationSession API is available from V8 SP4 onwards.

In addition, this API facilitates a single sign-on (SSO) experience when used with standards such as OAuth. It puts users in control of whether they want to use their existing logged-in session from Safari browser.

When users try to authenticate an URL from your application by using this API, the API displays an alert containing two buttons: Continue and Cancel. The following scenarios can occur when the Login screen of the web service is displayed:

• If the user taps Continue, one secure controller will be opened with authenticationURL. If the user has already authenticated the URL in Safari browser, it calls the redirectionURL (the URL scheme that points to this app), which is then passed in the API.
• If the user cancels the alert, the session will be canceled and the constants.WEB_AUTH_SESSION_ERROR_CANCELLED_LOGIN error message will be displayed.
• If the user taps Cancel, the session will be canceled and the constants.WEB_AUTH_SESSION_ERROR_CANCELLED_LOGIN error message will be displayed.

This will also dismiss the view controller that displays the login page of the web service.

Syntax

kony.web.WebAuthenticationSession(authenticationURL, redirectionURL, callbackfun);

Input Parameters

Methods

Example

var session = new kony.web.WebAuthenticationSession(authenticationURL, redirectionURL, callbackfun);
session.start();

function callbackfun(response) {
    if (constants.WEB_AUTH_SESSION_ERROR_CANCELLED_LOGIN == callbackURL.errorCode) {
        kony.print("Error occured during authentication ", response.errorCode);
    } else {
        //user-defined flow 
    }
    kony.print("resonse callbackURL ", response.callbackURL);
}

Return Values

None

Platform Availability

• iOS

Replaces a record if the primary key matches, else the record is added.

Syntax

kony.nosql.addRecords(transactionObject, tableName, records);

Input Parameters

Example

kony.nosql.openTransaction(dbObject, 'EMP', kony.nosql.READ_WRITE, function(transactionObject) 
{
    kony.nosql.addRecords(transactionObject, 'EMP', [{
        'Emp_id': 1234,
        'Emp_name': 'abc',
        'Emp_manager': 'def'
    }, {
        'Emp_id': 1235,
        'Emp_name': 'efg',
        'Emp_manager': 'xyz'
    }, {
        'Emp_id': 1236,
        'Emp_name': 'ijk',
        'Emp_manager': 'def'
    }]).then(function() {
        //add records success callback
    }).
    catch(function(errorObject) {
        //add records error callback
    });
}).then(function(transactionObject) {
    //transaction complete callback
});

Return Values

Promise.

• Resolve parameter: none

• Reject parameter: errorObject {errorMsg:" ", errorCode: " "}

Platform Availability

• Desktop Web

Replaces a record if the primary key matches, else the record is added.

Syntax

kony.nosql.addOrReplaceRecords(transactionObject, tableName, records);

Input Parameters

Example

kony.nosql.openTransaction(dbObject, 'EMP', kony.nosql.READ_WRITE, function(transactionObject) {
    kony.nosql.addOrReplaceRecords(transactionObject, 'EMP', {
        Emp_manager: 'updated manager name'
    }).then(function() {
        //addOrReplaceRecords records success callback
    }).
    catch (function(errorObject) {
        //addOrReplaceRecords records error callback
    });
}).then(function(transactionObject) {
    // transaction complete callback
});

Return Values

Promise.

• Resolve parameter: none

• Reject parameter: errorObject {errorMsg:" ", errorCode: " "}

Platform Availability

• Desktop Web

Clears the existing data in a table in the callback of openTransaction API.

Syntax

kony.nosql.clearTable(transactionObject, tableName);

Input Parameters

Example

kony.nosql.openTransaction(dbObject, 'EMP', kony.nosql.READ_WRITE, function(transactionObject) {
    kony.nosql.clearTable(transactionObject, 'EMP').then(function() {
        //clear table success callback
    }).
    catch(function(errorObject) {
        //clear table error callback
    });
}).then(function(transactionObject) {
    // transaction complete callback
});

Return Values

Promise.

Platform Availability

• Desktop Web

Closes the database connection.

Syntax

kony.nosql.closeDatabase(dbObject)

Input Parameters

Example

kony.nosql.openDatabase('Company', 1, function(dbObject) {
    //upgrade callback
}).then(function(dbObject) {
    //success callback
    kony.nosql.closeDatabase(dbObject).then(function() {
        //close database success callback
    }).
    catch (function(errorObject) {
        //close database error callback
    });
}).
catch (function(errorObject) {
    //error callback
});

Return Values

Promise.

• Resolve parameter: none

• Reject parameter: errorObject {errorMsg:" ", errorCode: " "}

Platform Availability

• Desktop Web

Creates indices for the specified table in the database. You can only create indices in the upgrade callback of an open database.

Syntax

kony.nosql.createIndices(dbObject, tableName, indexes);

Input Parameters

Example

kony.nosql.openDatabase('Company', 1, function(dbObject) {
        kony.nosql.createIndices(dbObject, 'EMP', {
                'Emp_sal': {
                    unique: true
                },
                'Emp_loc': {}
            }
        });
}).then(function(dbObject) {
    //success callback
}).
catch (function(errorObject) {
    //error callback
});

Return Values

Platform Availability

• Desktop Web

Creates a table (object store) in the indexed database. You can only create tables in the upgradebcallback.

Syntax

kony.nosql.createTable(dbObject, tableName, config);

Input Parameters

Example

kony.nosql.openDatabase('Company', 1, function(dbObject) {
    kony.nosql.createTable(dbObject, 'EMP', {
        primaryKey: 'Emp_id',
        indexes: {
            'Emp_id': {},
            'Emp_name': {},
            'Emp_manager': {},
            'Emp_DOJ': {},
            'Emp_email': {
                unique: true
            }
        }
    });
}).then(function(dbObject) {
    //success callback
}).catch(function(errorObject) {
    //error callback
});

Return Values

None.

Remarks

• If there is any error in creating a table, you will be directed to the reject callback.

• If you successfully create a table, you will be directed to the success callback of openDatabase API.

• Error in the creation of the table results in any one of the following scenarios:

  • If the database already exists: roll-back to the previous version of database occurs.

  • If this is the first version of the database: no new database is created.

• The autoIncrement property is not applicable when the primarykey is of composite value.

• Unlike SQL, you do not need to specify all properties but only the one you wish to index.

• Do not index properties that contain images, movies, or large-sized strings. Store them in IndexedDB, but do not index them; it may affect the performance.

Platform Availability

• Desktop Web

Specifies whether the required database exists or not.

Syntax

kony.nosql.databaseExists(dbName);

Input Parameters

Example

kony.nosql.databaseExists('dbName').then(function(isExists) {
    //successcallback
}).
catch(function(errorObject) {
    //error callback
});

Return Values

Promise.

• Resolve parameter: true if database exists; else, false

• Reject parameter: errorObject {errorMsg:" ", errorCode: " "}

Platform Availability

• Desktop Web

Deletes an existing database.

Syntax

kony.nosql.deleteDatabase(dbname);

Input Parameters

Example

kony.nosql.deleteDatabase('Company').then(function() 
{
   //success callback
}).
catch(function(errorObject) 
{
   //error callback
});

Return Values

Promise.

• Resolve parameter: none

• Reject parameter: errorObject {errorMsg:" ", errorCode: " "}

Platform Availability

• Desktop Web

Deletes indices for the specified table in the database. You can only delete indices in the upgrade callback of an open database.

Syntax

kony.nosql.deleteIndices(dbObject, tableName, indexes)

Input Parameters

Example

kony.nosql.openDatabase('Company', 1, function(dbObject) {
        kony.nosql.deleteIndices(dbObject, 'EMP', {
                'Emp_sal': {
                    unique: true
                },
                'Emp_loc': {}
            }
        });
}).then(function(dbObject) {
    //success callback
}).
catch (function(errorObject) {
    //error callback
});

Return Values

Platform Availability

• Desktop Web

Deletes the rows that match the specified condition.

Syntax

kony.nosql.deleteRecords(transactionObject, tableName, condition);

Input Parameters

Example

kony.nosql.openTransaction(dbObject, 'EMP', kony.nosql.READ_WRITE, function(transactionObject) 
{
    kony.nosql.deleteRecords(
        transactionObject,
        'EMP',
        condition
    ).then(function() {
        //delete records success callback
    }).
    catch(function(errorObject) {
        //delete records error callback
    });
}).then(function(transactionObject) {
    // transaction complete callback
});

Return Values

Promise.

• Resolve parameter: none

• Reject parameter: errorObject {errorMsg:" ", errorCode: " "}

Remarks

• If you do not pass any condition, the kony.nosql.deleteRecords API deletes all the records.

• If you want to delete all the records, use the kony.nosql.clearTable API for better performance efficiency.

Platform Availability

• Desktop Web

Deletes a table in the database. This can only be done in the upgradecallback parameter of openDatabase API.

Syntax

kony.nosql.deleteTable(dbObject, tableName);

Input Parameters

Example

kony.nosql.openDatabase('Company', 1, function(dbObject) {
    kony.nosql.deleteTable(dbObject, 'EMP');
}).then(function(dbObject) {
    //success callback
}).
catch(function(errorObject) {
    //error callback
});

Return Values

None.

Platform Availability

• Desktop Web

This API retrieves the records from the table depending on the condition set by user.

Syntax

kony.nosql.fetchRecords(transactionObject, tableName, condition);

Input Parameters

Example

kony.nosql.openTransaction(dbObject, 'EMP', kony.nosql.READ_WRITE, function(transactionObject) {
    /*
    For example, to form a condition like - "((Emp_name = 'Joe' || Emp_name = 'John') && (Emp_manager = 'Albert' || Emp_manager = 'Bill'))"
 
        var rule1 = new kony.nosql.Rule('Emp_name', kony.nosql.EQ, 'Joe');
        var rule2 = new kony.nosql.Rule('Emp_name', kony.nosql.EQ, 'John');
        var rule3 = new kony.nosql.Rule('Emp_manager', kony.nosql.EQ, 'Albert');
        var rule4 = new kony.nosql.Rule('Emp_manager', kony.nosql.EQ, 'Bill');
 
        var cond1 = new kony.nosql.Condition(rule1);
        cond1.addRule(kony.nosql.OR, rule2);
 
        var cond2 = new kony.nosql.Condition(rule3);
        cond2.addRule(kony.nosql.OR, rule4);
 
        var condition = new kony.nosql.Condition(cond1);
        cond2.addCondition(kony.nosql.AND, cond2);
 
        condition.toString() will return the below line, so that one can verify their condition.
        "((Emp_name = 'Joe' || Emp_name = 'John') && (Emp_manager = 'Albert' || Emp_manager = 'Bill'))"
 
        //Now pass "condition" to kony.nosql.fetchRecords API
    */

    kony.nosql.fetchRecords(transactionObject, 'EMP', condition).then(function(result) {
        //fetch records success callback

        /* To know about the properties and methods of the result object, refer Remarks. */
     
    }).
    catch (function(errorObject) {
        //fetch records error callback
    });
}).then(function(transactionObject) {
    // transaction complete callback
});

Return Values

Remarks

The result object has the following properties and methods:

Properties:

• result.data: Returns list of records (i.e. an array).
• result.length: Returns the number of records fetched.
• result.next: Moves the internal array index by 1, and returns true or false depending on, if record exists at that index.
• result.record: Returns a single record. Make sure "result.next" is called before calling "result.record"
  For example, Iterating through a result object

//Considering "result.next" was not called before
//if "result.record" is called here, it would return "null"
while (result.next) {
    kony.print(result.record);
    kony.print(result.record); //prints the same record as that of above line.
}
//if "result.record" is called here, it would return "null"

Methods:

• result.sort: This method can be invoked in the following ways:
  • result.sort(compareFunction) returns the list of sorted records depending on the compareFunction passed.
  • result.sort(columnName, sortType) returns the list of sorted records of specified column in ascending or descending order.
  • result.sort([columnName1,columnName2, ...], sortType) returns the list of sorted records of multiple columns in ascending or descending order.
• result.limit(startIndex, recordCount): This method returns the count of records from the startIndex. This API is chainable and mutates the output of result.data list.
  Here are a few examples:
  • result.sort(columnName, sortType).limit(0, 10).data: Sorts all the records and on then returns the first 10 records.
  • result.limit(0, 10).sort(columnName, sortType).data: Picks up the first 10 records and then sorts those 10 records.
    
• result.groupBy([columnName1,...], index): This method returns a 1D array or a 2D array by grouping the records of multiple columns. This API is not chainable and does not mutate the output of result.data list.
  Depending on the index provided, the result varies in the following ways:
  
  • if index is not given, a 2D array is returned with all the records grouped based on the column names.
  • if index is positive, it picks the records from the beginning of the grouped data and returns the array.
  • if index is negative, it picks the records from the end of the grouped data and returns the array.
    

Platform Availability

• Desktop Web

Fetches the primary key of the required table.

Syntax

kony.nosql.getPrimaryKeys(dbObject, tableName, transactionObject);

Input Parameters

Example

kony.nosql.openDatabase('Company', 1, function(dbObject) {
    //upgrade callback
}).then(function(dbObject) {
    //success callback
    kony.nosql.getPrimaryKeys(dbObject, tableName).then(function(primayKeyList) {
        //getPrimaryKeys success callback
    }).
    catch(function(errorObject) {
        //getPrimaryKeys error callback
    });
}).
catch(function(errorObject) {
    //error callback
});

Return Values

Promise.

• Resolve parameter: [Array] list of primary keys

• Reject parameter: errorObject {errorMsg:" ", errorCode: " "}

Platform Availability

• Desktop Web

Returns the list of tables in the selected database.

Syntax

kony.nosql.getTables(dbObject);

Input Parameters

Example

kony.nosql.openDatabase('Company', 1, function(dbObject) {
    //upgrade callback
}).then(function(dbObject) {
    //success callback
    kony.nosql.getTables(dbObject).then(function(tableNames) {
        //getTables success callback
    }).
    catch(function(errorObject) {
        //getTables error callback
    });
}). 
catch(function(errorObject) {
    //error callback
});

Return Values

Promise.

• Resolve parameter: tableNames[Array]

• Reject parameter: errorObject {errorMsg:" ", errorCode: " "}

Platform Availability

• Desktop Web

Opens an existing database; if the database does not exist, however, the API creates the database and then opens it.

Syntax

kony.nosql.openDatabase(dbname, version, upgradecallback);

Input Parameters

Example

kony.nosql.openDatabase('Company', 1, function(dbObject) {
    //upgrade callback
}).then(function(dbObject) {
    //success callback
}).catch(function(errorObject) {
    //error callback
});

Return Values

Promise.

• Resolve parameter: dbObject

• Reject parameter: errorObject {errorMsg:" ", errorCode: " "}

Platform Availability

• Desktop Web

Opens a transaction in which you can execute any of the insert, update, or delete operations.

Syntax

kony.nosql.openTransaction(dbObject, tableNames, mode, callback);

Input Parameters

Example

kony.nosql.openDatabase('Company', 1).then(function(dbObject) {
    kony.nosql.openTransaction(dbObject, 'EMP', kony.nosql.READ_WRITE, function(transactionObject) {
        //transaction callback
    }).then(function(transactionObject) {
        //transaction complete callback
    }).
    catch(function(errorObject) {
        //transaction error callback
    });
}).
catch(function(errorObject) {
    //open database error callback
});

Return Values

Promise.

• Resolve parameter: transactionObject

• Reject parameter: errorObject {errorMsg:" ", errorCode: " "}

Remarks

• In case of nested transactions, ensure that the child and parent transactions are not opened in the same table.

Platform Availability

• Desktop Web

Replaces the records that match the provided condition. The API also updates the full record with a new set of columns.

Syntax

kony.nosql.replaceRecords(transactionObject, tableName, columnValuePair, condition);

Input Parameters

Example

kony.nosql.openTransaction(dbObject, 'EMP', kony.nosql.READ_WRITE, function(transactionObject) {
    kony.nosql.replaceRecords(
        transactionObject,
        'EMP', {
            Emp_manager: 'updated manager name'
        },
        condition
    ).then(function() {
        //replace records success callback
    }).
    catch (function(errorObject) {
        //replace records error callback
    });
}).then(function(transactionObject) {
    // transaction complete callback
});

Return Values

Promise.

• Resolve parameter: none

• Reject parameter: errorObject {errorMsg:" ", errorCode: " "}

Platform Availability

• Desktop Web

Returns the appropriate Boolean value depending if the required table exists or not.

Syntax

kony.nosql.tableExists(dbObject, tableName);

Input Parameters

Example

kony.nosql.openDatabase('Company', 1, function(dbObject) {
    //upgrade callback
}).then(function(dbObject) {
    //success callback
    kony.nosql.tableExists(dbObject, tableName).then(function(isExists) {
        //tableExists success callback
    }).
    catch(function(errorObject) {
        //tableExists error callback
    });
}).
catch(function(errorObject) {
    //error callback
});

Return Values

Promise.

• Resolve parameter: true if table exists; else, false

• Reject parameter: errorObject {errorMsg:" ", errorCode: " "}

Platform Availability

• Desktop Web

Updates rows and specific columns that match the provided condition.

Syntax

kony.nosql.updateRecords(transactionObject, tableName, columnValuePair, condition);

Input Parameters

Example

kony.nosql.openTransaction(dbObject, 'EMP', kony.nosql.READ_WRITE, function(transactionObject) {
    kony.nosql.updateRecords(
        transactionObject,
        'EMP', {
            Emp_manager: 'updated manager name'
        },
        condition
    ).then(function() {
        //update records success callback
    }).
    catch (function(errorObject) {
        //update records error callback
    });
}).then(function(transactionObject) {
    // transaction complete callback
});

Return Values

Promise.

• Resolve parameter: none

• Reject parameter: errorObject {errorMsg:" ", errorCode: " "}

Platform Availability

• Desktop Web