📄️ Scripting with data sources
You can use the following functions to script around data source objects.
📄️ The DefaultDataSource placeholder
Each page has a default data source. This is the data source object that has its Default Data Source property set to Yes.
📄️ The getDataSourceAlias placeholder
In a SQL statement, the getDataSourceAlias placeholder is used to refer to the (USoft-generated) alias of some data source.
📄️ The getExpression placeholder
This placeholder is no longer supported in USoft 11.
📄️ The getMainDataSourceAlias placeholder
The getMainDataSourceAlias placeholder is used exclusively in WHERE clauses, and refers to the (USoft-generated) alias of the main data source in the FROM clause.
📄️ The getThisDataSourceAlias placeholder
In a SQL statement, the getThisDataSourceAlias placeholder is used to refer to the (USoft-generated) alias of the current data source.
📄️ The getSearchValue placeholder
This placeholder is no longer supported in USoft 11.
📄️ The getSelection placeholder
This placeholder is no longer supported in USoft 11.
📄️ The getValue placeholder
This placeholder is no longer supported in USoft 11.
📄️ The getWhereClause placeholder
This placeholder is deprecated in USoft 11 but still functional on data sources on the current main page.