Pass data as input parameter values

Use curly brackets ("{" and "}") as delimiters and the fully qualified format (model.table.column) to indicate input parameter values to SQL functions or custom functions in the expression. The default input is the column value if no metadata is specified after the column name.

For example, to calculate a subject's age from his date of birth:

round((sysdate - {Review.LAB_SRC.dob})/365)

where Review is the data model name, LAB_SRC is the table name, and dob is the column name. No metadata follows the column name, so by default the system passes the Date of Birth (dob) data value to the expression.