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

  • 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

  • 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
    • Technical Reference
  • 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
    • Technical Reference
  • 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
      • 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
    • 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
    • Using AdapTable Wizards
    • Styling Editable & ReadOnly Cells
    • Supplying an Adaptable Style
    • Displaying AdapTable Buttons
    • Configuring AdapTable Forms
    • Creating Adaptable Icons
    • Hiding AdapTableNew
    • Choosing American English
    • Using & Extending Colour Palette
    • UI Technical Reference

  • Core Features

  • Calculated Columns
    • Standard Calculated Columns
    • Aggregated Calculated Columns
    • Cumulative Calculated Columns
    • Quantile 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
    • Action Column CommandsNew
    • Configuring Action Columns
    • Technical Reference
  • Charting
    • Using Charts
    • Configuring Charts
    • External Chart Libraries
    • Technical Reference

  • Searching & Filtering

  • Quick Search
    • Styling Quick Search
    • Quick Search as Filter
    • Configuring Quick Search
    • Technical Reference
  • Column FiltersUpdated
    • Filter Components
    • 'In' Column Filter
    • System Filters
    • Custom Filters
    • Defining Filters
    • Configuring Filters
    • Manually Applyling Filters
    • Technical Reference
  • Grid FilterNew Feature
    • Defining Grid Filter
    • Configuring Grid Filter
    • Using Grid Filter
    • Technical Reference
  • Data Sets
    • Data Set Forms
    • Technical Reference
  • Named Queries
    • Technical Reference

  • Cell Rendering

  • Formatting & Styling
    • Display Formats
      • Numeric Format
      • String Format
      • Date Format
      • Template FormatNew Feature
      • Custom Format
    • Styles
    • Conditions
      • Predicate Conditions
      • Expression Conditions
    • Configuring Format Columns
    • 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
    • Configuring Flashing
    • Technical Reference

  • Editing

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

  • Annotating

  • Notes
    • 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
  • Scheduling

  • 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
  • AdapTable No Code
    • Configuring No Code
  • 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
    • Managing AdapTable State
    • Customising AdapTable State
    • Suspending AdapTable State
    • Listening to AdapTable State
    • Migrating AdapTable State
    • Technical Reference
  • Permissions
    • Permissioning Modules
    • Permissioning Objects
    • Default Access Level
    • 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
    • Filtering
    • Exporting
    • Sorting
    • Pivoting
    • Row Grouping
    • Managing Rows
    • Formatting & Styling
    • Calculated Columns
    • Searching
    • Viewport Row Model
  • Managing ColumnsNew Section
    • Providing Column Types
    • Setting AG Grid Cell Data Types
    • Managing ColDefs at Runtime
    • Configuring ColDefs at Design Time
    • Creating Array Columns
    • Setting Column Scope
    • Managing Columns
    • Configuring Column Headers
    • Hiding ColumnsNew Tutorial
    • Adaptable Column Object
  • Configuring AG Grid
    • Configuring GridOptions
    • Configuring ColDefs
    • AG Grid Cell Rendering
    • AG Grid Pagination
  • Developer Tutorials
    • Setting Cell Editability
    • Adding Holiday Calendars
    • Providing Adaptable Context
    • Providing Containers
    • Using Hotkeys
  • Supporting AdapTableNew Section
    • Logging
    • Profiling
    • Testing
    • Monitoring
    • AdapTable Performance
  • Integrated Examples
    • Editing Tips and Tricks
    • Undoing Data Edits
    • Filter by StyleNew Example

  • AdapTable Query Language

  • ExpressionsNew Functions
    • Standard Expressions
    • Aggregation Expressions
      • Cumulative Expressions
      • Quantile Expressions
    • Observable Expressions
    • Advanced Expressions
      • QUERY Function
      • VAR Function
      • IF & CASE Logic Functions
      • FIELD FunctionNew
      • Reducing Expression Complexity
    • Relative Change Expressions
    • Expression UI Components
      • Expression Editor
      • Query BuilderNew
    • Expression Functions
      • Standard Functions
      • Aggregated Functions
      • Relative Change Functions
      • Observable Functions
      • Advanced Functions
    • Custom Expression FunctionsNew
      • Custom Standard Functions
      • Custom Aggregated Functions
      • Custom Functions Scope
    • Technical Reference
  • Predicates
    • System Predicates
    • Custom Predicates
    • Technical Reference
  • 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 & AG Grid Modules

Filtering Grid Data

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

    • Grid Filters
    • Column Filters