The getThisDataSourceAlias placeholder

Previous Next

In a SQL statement, the getThisDataSourceAlias placeholder is used to refer to the (USoft-generated) alias of the current data source.

Syntax

${getThisDataSourceAlias()}

 

This placeholder can be used in SELECT and WHERE clauses, especially in WHERE clauses of embedded data sources, to refer to fields that exist in both the embedded data source, and its enclosing data source. It is not possible to use the getThisDataSourceAlias placeholder in ExecuteSQLStatement actions.

This placeholder is similar to the getDataSourceAlias and getMainDataSourceAlias placeholders. Click here for an example of the use of this type of placeholder within a SQL statement.

 

See also

Scripting with Data Sources

The getDataSourceAlias placeholder

The getMainDataSourceAlias placeholder