AdapTable for AG Grid

Framework

Version

DocsBlogDemosSupportBuy

Framework

Version

GuideTypes

    Introduction

  • Why AdapTable?
  • What's New
  • Features
  • Showcase Demos
    • Portfolio Risk Desk
    • Equity Watchlist
    • Trade Blotter & Corrections
    • Live Price Monitor
    • Exposure by Sector
    • Morning Corrections
    • Sales Pipeline
    • Approved Supplier Registry
  • Using the Docs
  • Older Versions

  • AI in AdapTable

  • AI ResourcesNew
  • Agent Skills
    • adaptable-setup
    • adaptable-dev
    • adaptable-debug
    • adaptable-upgrade
  • MCP Server and CLI
    • Technical Reference

  • Getting Started

  • Key Concepts
  • Installation
  • Integration
    • Adaptable Id
    • AG Grid Modules
    • Primary Key
    • AdapTable State Key
    • License Key
    • Adaptable Ready Event
    • User Name
    • AdapTable & AG Grid Divs
    • Technical Reference
  • Testing
  • FAQ

  • Layouts

  • Guide to Layouts
    • Updating Layouts
    • Saving Layouts
    • Extending Layouts
    • Default Layouts
    • Synchronising Layouts
    • Monitoring Layouts
    • Technical Reference
  • Table LayoutsUpdated
    • Column Order
    • Column Visibility
    • Column Sizing
    • Column Pinning
    • Column Sorting
    • Column Headers
    • Filtering and Grouping
    • Row SelectionNew
    • Table Layouts Wizard
  • Pivot Layouts
    • Defining Pivot Layouts
    • Formatting Pivot Layouts
    • Filtering Pivot Layouts
    • Sorting Pivot Layouts
    • Sizing Pivot Layouts
    • Selecting Pivot Layouts
    • Pivot Result Columns
    • Pivot Column Groups
    • Pivot Total Columns
    • Pivot Layouts Wizard
  • Row Groups
    • Expand / Collapse Behaviour
    • Formatting and Styling
    • Filtering
    • Sorting
    • Grouped Rows
  • Aggregations
    • Grand Total Rows
    • Weighted Averages
    • Only Aggregation
    • Formatting Aggregations
  • Column Groups
    • Expand / Collapse Behaviour
    • Formatting
  • Master Detail
  • Tree Data

  • AdapTable UI

  • UI Components
    • Settings Panel
      • Custom Settings Panel
      • Configuring Settings Panel
      • Grid Info Panel
      • Column Info Panel
      • Technical Reference
    • Dashboard
      • Tabs & Toolbars
      • Custom Toolbars
      • Dashboard Buttons
      • Dashboard Modes
      • Configuring Dashboard
      • Technical Reference
    • Tool Panel
      • Module Tool Panels
      • Custom Tool Panels
      • Tool Panel Buttons
      • Configuring Tool Panel
      • Technical Reference
    • Status Bar
      • Configuring Status Bar
      • Technical Reference
    • Column Menu
      • Configuring Column Menu
      • Custom Column Menu Items
      • Default Menu Structure
      • Technical Reference
    • Context Menu
      • Configuring Context Menu
      • Custom Context Menu Items
      • Default Menu Structure
      • Technical Reference
    • Wizard
      • Technical Reference
    • Popup Windows
    • Loading Screen
    • Progress Indicators
    • Custom Components
  • Theming the UI
    • Customising Themes
    • Referencing Themes
    • AG Grid Themes
    • Technical Reference
  • UI GuidesNew Guides
    • Accessibility & Keyboard
    • Displaying Toast Notifications
      • Technical Reference
    • Styling Editable & ReadOnly Cells
    • Supplying an Adaptable Style
    • Displaying AdapTable Buttons
    • Configuring AdapTable Forms
    • Creating Adaptable Icons
    • Hiding AdapTableNew
    • Choosing American English
    • Configuring Colour Picker
    • UI Technical Reference

  • Core Features

  • Calculated Columns
    • Standard Calculated Columns
    • Observable Calculated Columns
    • Aggregated Calculated Columns
    • Cumulative Calculated Columns
    • Quantile Calculated Columns
    • Window Calculated Columns
    • Referencing Calculated Columns
    • Technical Reference
  • Alerts
    • Data Change Alerts
    • Relative Change Alerts
    • Row Change Alerts
    • Aggregation Alerts
    • Observable Alerts
    • Scheduled AlertsNew
    • Validation Alerts
    • Alert Notification
    • Alert Message
    • Alert Behaviours
    • Configuring Alerts
    • Listening to Alerts
    • Technical Reference
  • Action Columns
    • Buttons
    • Toggles
    • Links
    • Selects
    • Commands
    • Menus
    • Forms
    • Custom Content
    • Configuring Action Columns
    • Technical Reference
  • Charting
    • Using Charts
    • Configuring Charts
    • External Chart Libraries
    • Technical Reference

  • Searching

  • Quick Search
    • Styling Quick Search
    • Quick Search as Filter
    • Configuring Quick Search
    • Technical Reference
  • Data Sets
    • Data Set Forms
    • Technical Reference
  • Named Queries
    • Technical Reference

  • Filtering

  • Guide to Filtering
    • Technical Reference
  • Column FiltersUpdated
    • Filter Components
    • 'In' Column Filter
    • System Filters
    • Custom Filters
    • Defining Filters
    • Configuring Filters
    • Manually Applying Filters
  • Grid Filter
    • Managing Grid Filter

  • Cell Rendering

  • Formatting & Styling
    • Display Formats
      • Numeric Format
      • String Format
      • Date Format
      • Template FormatNew Feature
      • Custom Format
    • Styles
    • Conditions
      • Observable Conditions
    • Configuring
    • Column Headers
    • Technical Reference
  • Styled ColumnsNew Styles
    • Gradient Style
    • Percent Bar Style
    • Badge Style
    • Sparkline Column Style
    • Bullet Chart Style
    • Rating Style
    • Range Bar Style
    • Icon Style
    • Technical Reference
  • Flashing Cells
    • Flashing Rows
    • Observable Flashing
    • Configuring Flashing
    • Technical Reference

  • Editing

  • Data Entry
    • Smart Edit
    • Bulk Update
    • Plus Minus
    • Shortcuts
    • Styling Editable Cells
    • Custom Edit Values
    • Technical Reference
  • Cell Editors
    • Select Editor
    • Numeric Cell Editor
    • Percentage Cell EditorNew
    • Date Picker
  • Data Validation
    • Pre-Edit Validation
    • Client Validation
    • Server Validation
  • Data Change History
    • Data Change History Actions
    • Configuring Data Change History
    • Technical Reference

  • Annotating

  • NotesUpdated
    • Configuring Notes
    • Technical Reference
  • Comments
    • Configuring Comments
    • Technical Reference
  • Free Text Columns
    • Configuring Free Text Columns
    • Technical Reference

  • Working with Grid Data

  • Exporting
    • Reports
    • Custom Reports
    • Report Format TypesNew
      • Excel
      • Visual Excel
      • CSV
      • JSON
    • Report Destinations
    • Custom Destinations
    • Formatting Reports
    • Processing Reports
    • Scheduling Reports
    • Configuring Reports
    • Technical Reference
  • Importing
    • Configuring Importing
    • Technical Reference
  • Sorting
    • Technical Reference
  • Selecting
    • Selecting using API
    • Selection Changed Events
    • Checkbox Column Selection
    • Technical Reference
  • SummarisingNew Feature
    • Cell Summaries
    • Row Summaries
    • Technical Reference
  • Transposing
  • Highlighting & Jumping

  • Advanced Features

  • Team Sharing
    • Active Team Sharing
    • Referenced Team Sharing
    • Setting Up Team Sharing
    • Custom Team Sharing
    • Technical Reference
  • Row Forms
    • Configuring Row Forms
    • Technical Reference
  • FDC3
    • FDC3 Data Mappings
    • FDC3 Contexts
    • FDC3 Intents
    • FDC3 UI Components
    • Custom FDC3
    • FDC3 Example
    • Technical Reference
  • System Status Messages
    • Configuring Messages
    • Technical Reference

  • Developer Guides

  • AdapTable State
    • Providing Initial AdapTable State
    • Persisting AdapTable State
    • Updating Initial AdapTable State
    • Customising AdapTable State
    • Suspending AdapTable State
    • Listening to AdapTable State
    • Managing AdapTable State
    • Migrating AdapTable State
    • State Migration Tool
    • Technical Reference
  • Permissions
    • Default Access Level
    • Permissioning Modules
    • Permissioning Objects
    • Technical Reference
  • Handling Grid Data
    • Loading Data
    • Managing Rows
    • Adding Rows
    • Updating Rows
    • Updating Cells
    • Deleting Rows
    • Listening to Data Changes
    • Technical Reference
  • Server-Side Row ModelNew Docs
    • Column Filtering
    • Grid Filter
    • Exporting
    • Sorting
    • Row Grouping
    • Pivoting
    • Managing Rows
    • Format Columns
    • Styled Columns
    • Calculated Columns
    • Searching
  • Viewport Row Model
  • Managing Columns
    • Configuring ColDefs at Design Time
    • Setting AG Grid Cell Data Types
    • Providing Column Types
    • Creating Array Columns
    • Adaptable Column Object
      • Technical Reference
    • Setting Column Scope
      • Technical Reference
    • Configuring Column Headers
    • Hiding ColumnsNew Tutorial
    • Managing ColDefs at Runtime
  • Configuring AG Grid
    • Configuring GridOptions
    • Configuring ColDefs
    • AG Grid Cell Rendering
    • AG Grid Pagination
  • AdapTable DevToolsNew Tool
    • Grid Info
    • Manage State
    • Theme Builder
  • Developer Tutorials
    • Setting Cell Editability
    • Adding Holiday Calendars
      • Technical Reference
    • Providing Adaptable Context
    • Providing Containers
      • Technical Reference
    • Using Hotkeys
  • Supporting AdapTable
    • DevTools In-page API
    • Logging
    • Profiling
    • Monitoring
    • AdapTable Performance
  • Integrated Examples
    • Editing Tips and Tricks
    • Undoing Data Edits
    • Filter by StyleNew Example

  • AdapTable Query Language

  • Getting Started
  • Expressions GuideNew Functions
    • Writing Expressions
    • Standard Expressions
    • Relative Change Expressions
    • Aggregation Expressions
    • Window Expressions
    • Cumulative Expressions
    • Quantile Expressions
    • Observable Expressions
    • Managing Expressions
    • Technical Reference
  • Advanced Expressions
    • QUERY Function
    • VAR Function
    • IF & CASE Logic Functions
    • IFERROR & IFNA FunctionsNew
    • FIELD FunctionNew
    • $SCOPE FunctionNew
  • Functions Library
  • Custom Functions
    • Custom Standard Functions
    • Custom Aggregated Functions
    • Custom Functions Scope
  • UI Components
    • Query Builder
    • Expression Editor
    • Formula EditorNew
  • External Evaluation
    • API Evaluation
    • Server Evaluation

  • Partners

  • OpenFin
    • Technical Reference
  • interop.io
    • Technical Reference
  • ipushpull
    • Technical Reference

  • Technical Reference

  • Adaptable Options
  • Adaptable API
  • Initial Adaptable State
  • Adaptable Events
  • Plugins
  • AdapTable Modules

Filtering Grid Data

View as Markdown

  • AdapTable provides 2 forms of Filters - see the relevant page for details:

    • Grid Filters
    • Column Filters