tableSql

Description Syntax Parameters Returns Example
Selects values from a repository. tableSql( variable.column, whereClause, DISTINCT) variable.column: array of columns from a repository variable.

whereClause: where clause (optional).

DISTINCT (Optional): The valid values are DISTINCT_TRUE and DISTINCT_FALSE.

Array of records. tableSql(var.COUNTRYNAME, where like(COUNTRYNAME,'Arg%'))

Where var is a link type variable pointing to the repository.