Advanced Expression Functions
Summary
- This section lists the Expression Functions used in Advanced Expression use cases
There are some "specialised" Expression Functions available when writing Advanced Expressions:
| Function | When Used | Example |
|---|---|---|
| QUERY | Referencing Named Queries | QUERY('my named query') |
| VAR | Referencing Custom Variables | VAR("VAT",[country]) |
| FIELD | Referencing (non-column) Fields | FIELD('stars_multiplier') |
| IF (or ?) | When using Ternary Logic | [Comments] > 100 ? 'Big' : 'Small' |
| CASE THEN WHEN END | When using CASE Statements | CASE [day] WHEN 'Sunday' THEN 'off' ELSE 'work' END |