The functionality described in this article is available in Navigator versions 10.4 and greater. See 10.4 Highlights for an overview of feature changes

By managing filtered columns in a viewlet, you can tailor the use of the Filter by box to your specific needs. Instead of using it to filter viewlet data by all columns only (its default behavior), you can choose one or more specific columns to apply the filter to. For example, you can specify the Put column for filtering, so that a filter for “Allowed” returns only records for which the Put action is allowed.

To manage filtered columns, a user must either be the creator of the viewlet or, for viewlets on shared dashboards, have "write" permission for the viewlet. After filtered columns have been selected for a viewlet, all users of the viewlet can choose whether to filter by the selected columns or by all columns (see Choose a filter method below).

Manage filtered columns

1. Select Manage Filtered Columns from the viewlet's menu to allow individual columns to be selected for filtering.
2. To indicate which columns you want the viewlet data to be filtered by, click the filter icons next to the column headers. When filtering viewlet data, users can still choose whether or not to use these columns exclusively. See Choose a filter method below. 

Clear all column-specific filters

While in Manage Filtered Columns mode, to "reset" or clear the green filter icons from all columns, click the Clear All Selected Filters button. The filter icons for all columns will turn grey .

Turn off individual column filtering

To stop managing which columns are filtered, select Stop Managing Filtered Columns from the viewlet's menu. Columns that have been selected for filtering retain the green icons. When filtering viewlet data, users can still choose whether or not to use these columns exclusively. See Choose a filter method below. 

Choose a filter method

The filter icon in front of the Filter by: label allows you to toggle between filtering by all columns and filtering by selected columns:

• • Click this white filter icon to switch to Filter by Chosen mode. This icon turns green . Records are filtered by the values in the selected columns (those with the green filter icons) only. 
  • To revert to filtering by all columns, click the filter icon again. It becomes a white Filter by All icon . The Filter by box will apply to values in all columns.

Enter a filter value in the Filter By box to filter records as you type.