...
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
...