ADR related inline functions available in ZT

getTableColumn(tableName, columnName)

Retrieves the first row in that column, there is an optional parameter row index you can pass as well when you need to have value from a particular row index

country = getTableColumn("100_Sales_Records", "Country", 1)

By default this function will give different column values for each request , but if you want to get always the same value , you need to pass the third parameter row index

team = getTableColumn("TeamDetails", "teamName", 2)

getTableRow(tableName, columnNames)

Retrieves the first row of each column given. columnNames separated by semicolon . Next call will give the second row and so on.

getTableRow("100_Sales_Records", "Country;Region")

getTableRowByColumn(tableName, matchColumnNames, matchColumnValues, outputColumnNames)

Retrieves the first row of column values that matches given column names and values. User can also supply the output columns to be retrieved , but it is optional . In case of multiple input, the values of matchColumnNames, matchColumnValues and outputColumnNames should be separated by a semicolon

This function will always give the values of the columns consistently, means you can have the same set of values for every call based on the criteria

getTableRowByColumn(“100_Sales_Records”, “Region;Country”, “Europe;Russia”)

setTableColumn(tableName, columnName, columnValue, uniqueFlag)

Set a value to a single column of the table. Value of uniqueFlag can be 0 or 1

setTableColumn("100_Sales_Records", "Country","USA", "0")

setTableRow(tableName, columnNames, columnValues, type)

Set the values of a row in a table(columnNames and columnValues separated by semicolon). Value of type can be ROW or UNIQUE or STACKED

setTableRow("100_Sales_Records", "Country;Region", "Japan;Nagasaki", "ROW")

updateTableColumn(tableName, columnName, columnValue, uniqueFlag, rowIndex)

Update a value to a single column of the table by row index. Value of uniqueFlag can be 0 or 1

updateTableColumn("100_Sales_Records", "Country","India", "0", "1")