Single Quotes in Placeholders |
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])} |