Custom Filter dialog box

Use this dialog box to create custom, multi-condition filters for the data grid.

How to access this dialog box

Click the icon in the column header, then select Custom Filter from the Text Filters/Number Filters/Date Filters menu option.

Field	Description
Filter Based On	Indicates whether the data will be filtered by All or Any of the conditions defined in the dialog box. Make the appropriate selection from the drop-down list
Add	Click to add another filter condition row.
Delete	Click to delete the currently selected filter row. At least one filter row must be included in the dialog box.

Field	Description
Column	Indicates the column to which the filter condition will be applied. This is the column in which you clicked the filter icon.
Comparison Operator	Select the desired comparison operator from the drop-down list. The list of available options includes: Equals Does Not Equal Less Than Less Than or Equal To Greater Than Greater Than or Equal To Contains Like Matches Regular Expression Starts With Ends With Does Not Start With Does Not Contain Does Not End With Does Not Match, Not Like
Comparison Value	Select the comparison value from the available drop-down list. The contents vary depending on the column selected.

Field

Description

Column

Indicates the column to which the filter condition will be applied. This is the column in which you clicked the filter icon.

Comparison Operator

Select the desired comparison operator from the drop-down list. The list of available options includes:

Comparison Value

Select the comparison value from the available drop-down list. The contents vary depending on the column selected.