Presentation Variables

You can use the following guidelines for referencing presentation variable in expressions.

When referencing a presentation variable, use this syntax:

@{variablename}{defaultvalue}

where variablename is the name of the presentation variable and defaultvalue (optional) is a constant or variable reference indicating a value to be used if the variable referenced by variablename isn’t populated.

To type-cast (that is, convert) the variable to a string or include multiple variables, enclose the entire variable in single quotes, for example:

'@{user.displayName}'

If the @ sign isn’t followed by a {, then it’s treated as an @ sign. When using a presentation variable that can have multiple values, the syntax differs depending on the column type.

Use the following syntax in SQL for the specified column type in order to generate valid SQL statements:

• Text — (@{variablename}['@']{'defaultvalue'})

• Numeric — (@{variablename}{defaultvalue})

• Date-time — (@{variablename}{timestamp 'defaultvalue'})

• Date (only the date) — (@{variablename}{date 'defaultvalue'})

• Time (only the time) — (@{variablename}{time 'defaultvalue'})

For example:

'@{user.displayName}'