ColumnFilterOptions

Options for managing Column Filtering in AdapTable

TypeScript
export interface

Properties

PropertyDescriptionDefault
defaultArrayColumnFilterDefault filter type for array Columns ('textArray', 'numberArray', etc.)In
defaultDateColumnFilterDefault filter type for date ColumnsOn
defaultNumericColumnFilterDefault filter type for numeric ColumnsEquals
defaultTextColumnFilterDefault filter type for text ColumnsContains
hideQuickFilterDropdownHides Dropdown in Quick Filter Bar for a given Columnundefined
hideQuickFilterInputHides Input in Quick Filter Bar for a given Columnundefined
indicateFilteredColumnsMake Column Header distinctive for filtered columns, helps users see currently filtered columnstrue
manuallyApplyColumnFilterManually apply Column Filters; an Apply Filter button is displayed and Quick Filter is disabledfalse
quickFilterDebounceTime to wait (in ms) before Filter Bar reacts to new value250
quickFilterHeightHeight of Quick Filter Bar (if not provided, AG Grid default is used)null
quickFilterWildcardsShortcut Keys to activate a Quick Filter Predicate
showQuickFilterDisplay Quick Filter Bar between Column Header and Grid (provided its been setup)true

Property Details

defaultArrayColumnFilter

Default filter type for array Columns ('textArray', 'numberArray', etc.)

TypeScript
defaultArrayColumnFilter?: StrictExtract<SystemFilterPredicateId, 'In' | 'NotIn' | 'Blanks' | 'NonBlanks'> | ((adaptableColumnContext: DefaultPredicateFilterContext) => StrictExtract<SystemFilterPredicateId, 'In' | 'NotIn' | 'Blanks' | 'NonBlanks'>);
Default Value

In

Property Value

StrictExtract<SystemFilterPredicateId, 'In' | 'NotIn' | 'Blanks' | 'NonBlanks'> | ((adaptableColumnContext:DefaultPredicateFilterContext) => StrictExtract<SystemFilterPredicateId, 'In' | 'NotIn' | 'Blanks' | 'NonBlanks'>)

defaultDateColumnFilter

Default filter type for date Columns

TypeScript
defaultDateColumnFilter?: StrictExtract<SystemFilterPredicateId, 'After' | 'Before' | 'On' | 'NotOn' | 'In'> | ((adaptableColumnContext: DefaultPredicateFilterContext) => StrictExtract<SystemFilterPredicateId, 'After' | 'Before' | 'On' | 'NotOn' | 'In'>);
Default Value

On

Property Value

StrictExtract<SystemFilterPredicateId, 'After' | 'Before' | 'On' | 'NotOn' | 'In'> | ((adaptableColumnContext:DefaultPredicateFilterContext) => StrictExtract<SystemFilterPredicateId, 'After' | 'Before' | 'On' | 'NotOn' | 'In'>)

defaultNumericColumnFilter

Default filter type for numeric Columns

TypeScript
defaultNumericColumnFilter?: StrictExtract<SystemFilterPredicateId, 'GreaterThan' | 'LessThan' | 'Equals' | 'NotEquals' | 'In'> | ((adaptableColumnContext: DefaultPredicateFilterContext) => StrictExtract<SystemFilterPredicateId, 'GreaterThan' | 'LessThan' | 'Equals' | 'NotEquals' | 'In'>);
Default Value

Equals

Property Value

StrictExtract<SystemFilterPredicateId, 'GreaterThan' | 'LessThan' | 'Equals' | 'NotEquals' | 'In'> | ((adaptableColumnContext:DefaultPredicateFilterContext) => StrictExtract<SystemFilterPredicateId, 'GreaterThan' | 'LessThan' | 'Equals' | 'NotEquals' | 'In'>)

defaultTextColumnFilter

Default filter type for text Columns

TypeScript
defaultTextColumnFilter?: StrictExtract<SystemFilterPredicateId, 'Is' | 'IsNot' | 'Contains' | 'NotContains' | 'StartsWith' | 'EndsWith' | 'Regex' | 'In'> | ((adaptableColumnContext: DefaultPredicateFilterContext) => StrictExtract<SystemFilterPredicateId, 'Is' | 'IsNot' | 'Contains' | 'NotContains' | 'StartsWith' | 'EndsWith' | 'Regex' | 'In'>);
Default Value

Contains

Property Value

StrictExtract<SystemFilterPredicateId, 'Is' | 'IsNot' | 'Contains' | 'NotContains' | 'StartsWith' | 'EndsWith' | 'Regex' | 'In'> | ((adaptableColumnContext:DefaultPredicateFilterContext) => StrictExtract<SystemFilterPredicateId, 'Is' | 'IsNot' | 'Contains' | 'NotContains' | 'StartsWith' | 'EndsWith' | 'Regex' | 'In'>)

hideQuickFilterDropdown

Hides Dropdown in Quick Filter Bar for a given Column

TypeScript
hideQuickFilterDropdown?: (adaptableColumnContext: AdaptableColumnContext<TData>) => boolean;
Default Value

undefined

Property Value

(adaptableColumnContext:AdaptableColumnContext<TData>) => boolean

hideQuickFilterInput

Hides Input in Quick Filter Bar for a given Column

TypeScript
hideQuickFilterInput?: (adaptableColumnContext: AdaptableColumnContext<TData>) => boolean;
Default Value

undefined

Property Value

(adaptableColumnContext:AdaptableColumnContext<TData>) => boolean

indicateFilteredColumns

Make Column Header distinctive for filtered columns, helps users see currently filtered columns

TypeScript
indicateFilteredColumns?: boolean;
Default Value

true

Property Value

boolean

manuallyApplyColumnFilter

Manually apply Column Filters; an Apply Filter button is displayed and Quick Filter is disabled

TypeScript
manuallyApplyColumnFilter?: boolean | ((context: AdaptableColumnContext) => boolean);
Default Value

false

Property Value

boolean | ((context:AdaptableColumnContext) => boolean)

quickFilterDebounce

Time to wait (in ms) before Filter Bar reacts to new value

TypeScript
quickFilterDebounce?: number;
Default Value

250

Property Value

number

quickFilterHeight

Height of Quick Filter Bar (if not provided, AG Grid default is used)

TypeScript
quickFilterHeight?: number;
Default Value

null

Property Value

number

quickFilterWildcards

Shortcut Keys to activate a Quick Filter Predicate

TypeScript
quickFilterWildcards?: Partial<Record<SystemAlertPredicateId, string[]>>;
Property Value

Partial<Record<SystemAlertPredicateId, string[]>>

showQuickFilter

Display Quick Filter Bar between Column Header and Grid (provided its been setup)

TypeScript
showQuickFilter?: boolean;
Default Value

true

Property Value

boolean