Designing an Advanced Filter with the Filter Builder

The Filter Builder provides you a graphical interface for creating, editing or removing the advanced filters. You can use Filter Builder, when the Advanced Filter tab appears in the Design mode.

To use a Filter Builder:

1. Right-click anywhere in the grid, and then click Filter > Advanced Filter. The Advanced Filter tab of the Customize View window opens.

2. If the Advanced Filter tab appears in the SQL mode, click Switch to Design Mode.

3. In the Design mode, configure the advanced filter criteria, click OK.

You can configure advanced filter criteria using the following tasks:

• To add a condition:

  1. On the Advanced Filter Menu, click Add Condition, or click the plus button to the right of a row.

  2. Define the condition: choose the field to compare, the comparison operator and value to compare with (if applicable to the chosen operator). For details, see Using operators in the Filter Builder. If the comparison operator is either like or not like, in the value you can use the wildcards: "_" representing any single character or "%" representing any sequence of characters.

• To add a group of conditions:

  1. On the Advanced Filter Menu, click Add Group, orclick the ellipsis button to the right of a row.

  2. In the new group row, choose the operator to combine the conditions within the group (the default operator is all matched, you can also choose any matched, one failed, or all failed). For details, see Using operators in the Filter Builder.

  3. Define the conditions in the group.

• To remove a condition or a group of conditions:

  • Select the corresponding row and click Delete Row on the Advanced Filter Menu, or click the minus button to the right of the row.

• To move a condition into another group:

  • To move a condition into another group, use Move Up (Move Down) commands on the Advanced Filter Menu. Alternatively, you can use the drag icon (three gray parallel lines ) to the left of each row.

Related Information:

Removing filtering

Designing an Advanced Filter by specifying an SQL WHERE clause