Version: 10.1

Scripting with data sources

You can use the following functions to script around data source objects.

Data sources

You can refer to data sources by using these placeholders:

${DefaultDataSource} contains the data source in the current page that has the Default Data Source = Yes property setting.
${getDataSourceAlias} is used to refer to the (USoft-generated) alias of a data source in a SQL statement.
${getMainDataSourceAlias} is used in the WHERE clause of a SQL statement, and refers to the (USoft-generated) alias of the main data source in the FROM clause.
${getThisDataSourceAlias} is used in the WHERE clause of a SQL statement, and refers to the (USoft-generated) alias of the data source itself.

You can refer to objects related to data sources by using these placeholders:

${getSearchValue} is used to retrieve values from query conditions.
${getValue} reads a value from the selected record in a web page. This can be a column value of the selected record, or the current value of a variable in a variable set.
${getWhereClause} is used in the WHERE clause of a SQL statement, and copies the WHERE clause of another data source based on the same table to the appropriate data source.
${getSelection} is used in the WHERE clause of a SQL statement, and creates an expression of the selected record of another data source based on the same table.
${getExpression} is used to copy the Output Expression of a table column to use it in other expressions.

To refer to host variables in SELECT or WHERE clause of a SQL statement, you can use a colon ( : ) as a prefix, for example:

:customer_id