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.

Objects related to data sources

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.

Host variables

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