TCA.vtcGetColumnRange

Retrieves a range of values from a column, from a start index to an end index.

Note: This function is supported from version 26.3.

Equivalent method in VuGen: lrvtc_get_column_range

TCA.vtcGetColumnRange(colName, start, end, vtsName);

Arguments

Name Description
colName(string) The name of the column.
start(integer) The row number to start retrieving from. The first row has index 1.
end(integer) The row number to stop retrieving at (inclusive).
vtsName (Optional)(string) The alias of the VTS server.

General information

This function retrieves the values in the specified row range from the given column. The retrieved values are stored as {columnName} for a semicolon-delimited concatenation of all values, and {columnName_count} for the number of values retrieved.

Tip: To avoid performance issues, it is recommended to keep the range smaller than 1000.

Return value

A promise that is fulfilled with 0 if completed successfully, or returns an error code on failure.

Example

Copy code
TCA.vtcGetColumnRange("MyColumn1",3,5).then(function(result){
  TCA.done(result)
}).catch(function (error) {
 TCA.doneWithError(error);
});