Filter Editor

End-users can invoke the Filter Editor in the following ways:

• Right click the required column header and select the Filter Editor... menu item.

  

• Click the button in the Filter Panel.

You can open the Filter Editor in code with the DataViewBase.ShowFilterEditor method. Handle the DataViewBase.FilterEditorCreated event to customize the Filter Editor before it is displayed.

The Filter Editor displays filter criteria as a tree structure, where nodes are simple filter conditions. The Filter Editor groups filter conditions by logical operators if the filter criteria consist of several filter conditions. The following image displays the Filter Editor with the "[Product] = 'Chang' And [Quantity] > 20" filter expression:

Conditions combined by a logical operator at the same level form a group. You can think of groups as clauses wrapped by round brackets in the filter expression. There is only one group in the example above. In the following example, the filter expression contains two groups combined by the logical OR operator. The following image displays the "([Product] = 'Chang' And [Quantity] > 20) Or ([Product] In ('Tofu', 'Konbu') And [Quantity] < 100)" expression:

The image below shows the Filter Editor's UI elements.