Automatic Filter Row
- 2 minutes to read
The automatic filter row allows end-users to filter data on the fly, by typing text directly into a row. When an end-user types text within a row, a filter condition is automatically created based upon the values entered and applied to the column.
By default, the auto-filter row is hidden. It can be activated by setting the TableView.ShowAutoFilterRow property to true.
By default, when an end-user modifies text within an auto filter row's cell, the filter condition for this column isn't automatically updated. An end-user should press the Enter key or move focus to another cell to force updates. To enable automatic updates, set the column's ColumnBase.ImmediateUpdateAutoFilter property to true. In this instance, a column's filter is immediately updated each time an end-user modifies the auto-filter row cell's value.
To remove the filter, clear the text from the auto-filter row.
#Auto-Filter Row Settings
Availability
Columns provide the ColumnBase.AllowAutoFilter property that specifies whether or not their values can be filtered using the automatic filter row. If this property is set to false, the corresponding cell within the automatic filter row is disabled.
Comparison Operator Type
A column's ColumnBase.AutoFilterCondition property allows you to specify the comparison operator type (CONTAINS, EQUALS or LIKE).
Identifier
The automatic filter row is identified by its handle, returned by the static DataControlBase.AutoFilterRowHandle field.
Row Data
A cell's value can be obtained using a corresponding column's ColumnBase.AutoFilterValue property.