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.

NOTE: You can configure the advanced filters for your local views. For shared views, only your Alloy Discovery administrator can create and modify the advanced criteria for filtering data. You can change the advanced filter on the shared view, but you cannot save your changes and update the shared view. To save your changes, create your local copy of the shared view. For details, see Working with views.

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:

    • ClosedTo 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.

    • ClosedTo 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.

    • ClosedTo 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.

    • ClosedTo 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.