ColumnFilterOptions

Options for managing Column Filtering in AdapTable

TypeScript
export interface

Properties

PropertyTypeDescriptionDefault
defaultArrayColumnFilterStrictExtract<SystemFilterPredicateId, 'In' | 'NotIn' | 'Blanks' | 'NonBlanks'> | ((adaptableColumnContext:DefaultPredicateFilterContext) => StrictExtract<SystemFilterPredicateId, 'In' | 'NotIn' | 'Blanks' | 'NonBlanks'>)Default filter type for array Columns ('textArray', 'numberArray', etc.)In
defaultDateColumnFilterStrictExtract<SystemFilterPredicateId, 'After' | 'Before' | 'On' | 'NotOn' | 'In'> | ((adaptableColumnContext:DefaultPredicateFilterContext) => StrictExtract<SystemFilterPredicateId, 'After' | 'Before' | 'On' | 'NotOn' | 'In'>)Default filter type for date ColumnsOn
defaultNumericColumnFilterStrictExtract<SystemFilterPredicateId, 'GreaterThan' | 'LessThan' | 'Equals' | 'NotEquals' | 'In'> | ((adaptableColumnContext:DefaultPredicateFilterContext) => StrictExtract<SystemFilterPredicateId, 'GreaterThan' | 'LessThan' | 'Equals' | 'NotEquals' | 'In'>)Default filter type for numeric ColumnsEquals
defaultTextColumnFilterStrictExtract<SystemFilterPredicateId, 'Is' | 'IsNot' | 'Contains' | 'NotContains' | 'StartsWith' | 'EndsWith' | 'Regex' | 'In'> | ((adaptableColumnContext:DefaultPredicateFilterContext) => StrictExtract<SystemFilterPredicateId, 'Is' | 'IsNot' | 'Contains' | 'NotContains' | 'StartsWith' | 'EndsWith' | 'Regex' | 'In'>)Default filter type for text ColumnsContains
hideQuickFilterDropdown(adaptableColumnContext:AdaptableColumnContext<TData>) => booleanHides Dropdown in Quick Filter Bar for a given Columnundefined
indicateFilteredColumnsbooleanMake Column Header distinctive for filtered columns, helps users see currently filtered columnstrue
manuallyApplyColumnFilterboolean | ((context:AdaptableColumnContext) => boolean)Manually apply Column Filters; an Apply Filter button is displayed and Quick Filter is disabledfalse
quickFilterDebouncenumberTime to wait (in ms) before Filter Bar reacts to new value250
quickFilterHeightnumberHeight of Quick Filter Bar (if not provided, AG Grid default is used)null
quickFilterWildcardsPartial<Record<SystemAlertPredicateId, string[]>>Shortcut Keys to activate a Quick Filter Predicate
showQuickFilterbooleanDisplay 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

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[]>>;
Default Value
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