Single Quotes in Placeholders

Previous Next

See Also

When using the getValue or 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:

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

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