Custom Expression Functions

Summary

  • Custom Expression Functions are AdapTableQL Expression Functions provided at design-time
  • They are registered with the AdapTableQL evaluation engine and available for use in AdapTable
  • They can be Standard (single-row) or Aggregated (multiple-rows)
  • They are also listed in the Expression Editor with full help
  • Custom Expression Functions may be provided only to specific Adaptable Modules

AdapTableQL ships with a huge range of Expression Functions.

These allow run-time users to create powerful, and sometimes very complex queries.

Additionally, AdapTableQL can be extended through bespoke, custom, expression functions.

Caution

Custom Expression functions return a single value, either a boolean (ie. true / false) or other value.

They can be divided into 2 types:

  • Standard - evaluate on a single row in the Grid
  • Aggregation - evaluate against a set of rows in the Grid

By default every Custom Expression Function created is available in all Modules in AdapTable.

However this can be changed by setting the Custom Expression Function Scope which limits where the Expression function is available.

Custom Expression Functions

(Recorded with AdapTable v16.0)

FAQ

Can I provide an asynchronous Custom Expression Function? Not at the moment but this is something in the pipeline and likely to be available in future releases.