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.
Parent topic: Use the Expression Builder