Advanced Expressions
Summary
- Expressions in AdapTable have some powerful features for more advanced use cases. These include:
- Using
QUERYto reference other Expressions by keyword - The
VARfunction which allows developers to provide values which can be evaluated in other Expressions - Complex Logic - using
IFandCASEfunctions - Referencing row data (rather than Columns) inside Expressions
- Using
Most Expressions are often fairly straightforward - typically just a couple of operands and an operator.
However, Expressions can include more complex elements to deal with advanced use cases.
This section of the documentation details some advanced Expression capabilities supported by AdapTableQL:
- QUERY function enables Named Queries to be referenced in an Expression
- VAR function supports custom values which can be used in Expressions
- Support for Logic constructs - ternary operator and CASE statements facilitate using logic in Expressions
- Data in row fields can be referenced (i.e. data that is not stored in Columns)
Hint
- Another advanced Expression use case is Custom Expression Functions
- These allow developers to provide bespoke functions which are then invoked and evaluated by AdapTableQL