Table of Contents

Creating Complex Filter Criteria with the Filter Builder

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

FilterControl

To open the Filter Builder, click one of the following.

  • the filter image displayed within the filter bar.

    FilterControlShow1

  • the filter expression link.

    FilterControlShow2

To create and customize filter criteria, use the FilterEditor_EU_AddButton and FilterEditor_EU_DeleteButton buttons.

FilterControlInfo

Remarks

A filter condition group is a set of conditions combined by the same 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')". In the Filter Builder, it is represented as follows.

FilterControlConditionGroups

To learn more, see the Filter Editor topic.

Edit this page