The getSearchValue Placeholder

The getSearchValue placeholder is used to retrieve values from query conditions.

It retrieves the last search condition specified, if any. This can be a column value of the selected record. It refers to the underlying data source item of a data source:

${getSearchValue(<DataSource name>,<DataSource item>)}

NOTE 1: The getSearchValue placeholder must not refer to variable data sources.

NOTE 2: When using the getSearchValue placeholder in a SQL statement, by default single quotation marks (' ') are added automatically around the retrieved value, according to the type of the DataSource item: A numeric type gets a single quote, and other types do not.

You can change this default behavior by adding a third, optional argument (True or False) to the placeholder to enforce or skip the addition of single quotes:

${getSearchValue(<DataSource name>,<DataSource item>[,True|False])}