Expression UI Components

Summary

  • AdapTable provides 2 UI Components to help write Expressions:
    • Expression Editor - ideal for complex queries with full drag and drop
    • Query Builder - used for more simple multi-column conditions using selects / dropdowns

Expressions are widely used in AdapTable, including Alerts, Calculated Columns and Format Columns.

An AdapTableQL Expression is ultimately just a human-readable string and can, therefore, be written by hand.

Note

Expressions provided in Initial Adaptable State might often be hand-produced

AdapTable provides 2 different User Interface components available for writing Expressions.

Hint

Use the availableFilterEditors property in Grid Filter Options to set which of the UI Components is available

Query Builder

  • Used in Grid Filter
  • For more basic Expressions
  • Contains Dropdowns & Selects
  • Supports AND / OR groups

Expression Editor

  • Used in all Expression-based Modules
  • For complex hand-written Expressions
  • Contains Drag n Drop Columns
  • Context sensitive support