The getSelection Placeholder

Previous Next


See Also

The getSelection placeholder creates a WHERE clause of the specified data source from its selected record’s primary keys and values. If no record is selected in the specified data source, then a default WHERE clause is generated instead.


The syntax of the getSelection placeholder is very similar to that of the getWhereClause placeholder:


 ${getSelection(<DataSource name>,<DataSource alias>,<IfNullString>)}


The resulting expression can only be used in the context of a WHERE clause (usually the Where Clause property of a data source). It is only useful if both the specified data source and the data source where it is used, are based on the same table. Moreover, both data sources should have the same embedded data sources as well.


The result of the getSelection placeholder can also be achieved by a combination of getValue placeholders for each column to be copied, but in the case of large primary key sets, the use of getSelection is recommended.


Note: the WHERE clause substituted by the getWhereClause placeholder may also contain other placeholders, which are substituted in turn as well. Be careful with getWhereClause placeholders pointing to each other.