Filtering views

  1. From the view that you want to filter, click the Filter tab to open the filter workspace.

  2. In the Filter Selection area, begin typing the field name to view all the available options.

  3. From the dropdown menu, select an operator, such as LIKE or NULL.

  4. In the box, enter the value or range.

  5. (Optional) To add additional criteria, select AND or OR from the dropdown menu to define the relationship to the previous filter item, and then click ADD.

  6. (Optional) If you need to remove criteria, click Remove ().

  7. Click Add Filter.

    The filter is displayed in the Active Filters section.

  8. (Optional) Repeat steps 2-7 as necessary to add additional filters.

  9. Click Execute to apply the filters displayed in the Active Filters section.