All docs
V19.2
24.1
The page you are viewing does not exist in version 24.1.
23.2
The page you are viewing does not exist in version 23.2.
23.1
The page you are viewing does not exist in version 23.1.
22.2
The page you are viewing does not exist in version 22.2.
22.1
The page you are viewing does not exist in version 22.1.
21.2
The page you are viewing does not exist in version 21.2.
21.1
The page you are viewing does not exist in version 21.1.
20.2
The page you are viewing does not exist in version 20.2.
20.1
The page you are viewing does not exist in version 20.1.
19.2
19.1
18.2
18.1
17.2
Box
Row
Map
Vue
A newer version of this page is available. Switch to the current version.

jQuery DataGrid - filterRow

Configures the filter row.

Type:

Object

The filter row allows a user to filter data by values of individual columns.

DevExtreme HTML5 JavaScript jQuery Angular Knockout DataGrid FilterRow

Each cell in the filter row contains a magnifying glass icon, pausing on which opens a drop-down list with filters available for the column.

DevExtreme HTML5 JavaScript jQuery Angular Knockout DataGrid FilterRow

To make the filter row visible, assign true to the filterRow.visible option.

View Demo

See Also

applyFilter

Specifies when to apply a filter.

Type:

String

Default Value: 'auto'
Accepted Values: 'auto' | 'onClick'

By default, the filter applies automatically after a user finishes entering a value into a cell of the filter row. Alternatively, the filter can be applied on a click on the "Apply Filter" button. To enable this mode, assign "onClick" to the applyFilter option.

Use the GridApplyFilterMode enum to specify this option when the widget is used as an ASP.NET MVC 5 Control or a DevExtreme-Based ASP.NET Core Control. This enum accepts the following values: Auto and OnClick.

applyFilterText

Specifies text for a hint that appears when a user pauses on a button that applies the filter.

Type:

String

Default Value: 'Apply filter'

betweenEndText

Specifies a placeholder for the editor that specifies the end of a range when a user selects the "between" filter operation.

Type:

String

Default Value: 'End'

See Also

betweenStartText

Specifies a placeholder for the editor that specifies the start of a range when a user selects the "between" filter operation.

Type:

String

Default Value: 'Start'

See Also

operationDescriptions

Specifies descriptions for filter operations on the filter list.

Type:

Object

See Also

resetOperationText

Specifies text for the reset operation on the filter list.

Type:

String

Default Value: 'Reset'

The reset operation restores the default filter, which depends on the column's data type. For details on default filters by data types, refer to the description of the selectedFilterOperation option.

showAllText

Specifies text for the item that clears the applied filter. Used only when a cell of the filter row contains a select box.

Type:

String

Default Value: '(All)'

In columns that contain Boolean values or use lookup, a user filters data with a select box. To clear the applied filter, the user selects the "All" item in this select box. The showAllText option specifies text for this item.

showOperationChooser

Specifies whether icons that open the filter lists are visible.

Type:

Boolean

Default Value: true

visible

Specifies whether the filter row is visible.

Type:

Boolean

Default Value: false