Using the Grid Filter
Summary
- Run-time users can create and manage the Grid Filter in multiple ways
Run-time users (if correctly permissioned) can write, edit, delete, clear, save and reload Grid Filter Expressions.
Writing Grid Filters
AdapTable users can write Grid Filter Expressions by hand which will be evaluated immediately by AdapTable.
Grid Filter Expressions can be written directly in the Grid Filter Toolbar or Tool Panel and they will be applied and evaluated when the Run button is clicked.
But, more often, users will click the Expand button to open the Expression Editor or Query Builder which provide a richer environment for writing Expressions.
Hint
The Expression UI Components include functions lists, intuitive UI controls and context sensitive help
Users can create multiple Grid Filters and load them on demand, but only one Grid Filter can be run (and active) at any one time.
Editing Grid Filters
A Grid Filter can be easily be edited in the Expression Editor or Query Builder and then re-run.
Caution
Editing a Named Query creates a new Grid Filter - which can then itself be saved as a new Named Query
Validating Grid Filters
AdapTableQL automatically validates the Grid Filter as it is being written.
Caution
AdapTable will only enable the Run button if the Grid Filter's Expression is valid
Set performExpressionValidation in Expression Options to false to turn off automatic validation.
Hint
This is useful if you are evaluating the Grid Filter on your server
Clearing Grid Filters
The Grid Filter can be cleared by clicking the Clear Grid Filter button in the Grid Filter Toolbar or Tool Panel.
This will have the effect of showing all rows in the Grid (subject to any Column Filters that have been applied).
Hint
- Cleared Queries can be subsequently reloaded
- This applies both to Named Queries or unsaved Grid Filters (but only those created in the current session).
Saving Grid Filters
A Grid Filter can be saved by clicking the Save button in the Grid Filter Toolbar or Tool Panel.
This will save the Grid Filter as a Named Query for re-use as required.
Caution
Grid Filters which are not saved explicity are still persisted temporarily and can be reloaded during the current session
Loading Grid Filters
The Grid Filter Toolbar and Tool Panel both contain a dropdown which allow for previously run Expressions to be loaded and then run as a Grid Filter.
The dropdown includes all saved Named Queries, plus any unsaved Grid Filters created in the Current Session.
Note
Unsaved Grid Filters are named according to the time of creation (e.g. 'Grid Filter at 5:38:33 PM')