Query Builder
Summary
- Enables Boolean Expressions to be created using dropdowns
- Provides large range of operators
- Supports existing column values, new values and other Columns in the Grid
The Query Builder allows for basic Boolean Expressions to be created at run-time.
Hint
For more complicated Expressions use the Expression Editor
Each Query created by the Query Builder consists of (up to) 2 elements:
- Condition - essentially a set of Column -> Operator -> Value (e.g. Bid > 500)
- AND / OR Group - defines if all Conditions, or just one Condition, must be true
Note
- Currently the Query Builder is only available in the Grid Filter
- It will shortly be extended to other Modules e.g. Alerts and Conditional Formats
- This demo showcases the AdapTableQL UI Query Builder by displaying the current Grid Filter
Hint
If you want only to display the Query Builder set availableFilterEditors in Grid Filter Options to 'QueryBuilder'
Condition
A Query must contain at least one Condition.
Each Condition essentially consists of 3 elements:
-
A Column - selected via a Column Selector.
-
An Operator - selected via a dropdown (the contents change based on DataType of selected Column)
-
A Value - what the column value is compared against. This can be one of 4 types:
- An existing Column Value
- A "new" value (not currently in the Column)
- Another Column in the Row
- A Field (if one has been defined)
Note
If the IN operator is used then a list of column values can be selected
AND / OR Group
Additionally the Query Builder allows you to create AND / OR Groups.
Expression
The Query Builder will display the outputted Expression.
Reduced Operators
Because the Query Builder is designed for less complex Expressions, only the most commmonly used Expression Functions provided by AdapTableQL are available.
Hint
None of these limitations are present if using the Expression Editor