Guide to Filtering Data in AdapTable
Summary
- AdapTable provides 2 ways to filter Grid Data (which can both operate at the same time):
- Column Filter - filters a single Column (but with multiple conditions)
- Grid Filter - filters across multiple Columns
- Both types of Filter use AdapTableQL Expressions
AdapTable provides 2 ways of filtring Grid Data - Column Filters and Grid Filter:
Important
- Column Filters and the Grid Filter complement, and work in conjunction, with each other
- Both can be active at the same time - only rows which pass both Filters are visible
Column Filters
- Filter a single Column
- Multiple conditions with AND / OR
- Filter Bar and Filter Form
- Re-applied as Grid data changes
Grid Filter
- Filter across many Columns
- Boolean AdapTableQL Expressions
- Save and re-run as Named Queries
- Includes column-comparison Filters