Creating Complex Filter Criteria with the Filter Control

To build complex filter criteria with an unlimited number of filter conditions, combined by logical operators, use the built-in Filter Control.

Open the Filter Control using one of the following:

• Click the filter image in the filter bar.

  

• Click the filter expression link in the filter bar.

  

Use the and buttons embedded into the control to create and customize the filter criteria:

 

Remarks

A filter condition group is a set of conditions combined by a logical operator. The following filter expression contains two groups combined by the logical OR operator: “(Country Equals ‘UK’ And Category Equals ‘Beverages’) Or (Country Equals ‘USA’ And Category Equals ‘Produce’)”.

Refer to the Filter Editor topic for more information.