Multi-Select Filtering

Format of Filtering Row when Multi-Select Filtering is in use:

To apply filter using the multi-select style filtering facility, first activate it for the list by checking the Multi-Select Filter Style checkbox in the Grid Options group of the View tab, or right-clicking on the list and ticking the Multi-select Filter Style option on the menu that is then displayed.

Applying a Basic Filter

A basic filter can be applied by typing a value into the filter row above the appropriate column. The list will then be filtered to display only those records that include a value in that column that matches or starts with that filter value.

Applying a Multi-Select Filter

To apply a multi-select style filter to a column, hover the cursor over the filter row field for that column and click on the button that is then displayed at the end of the field.

The following window is then displayed:

The window lists all the values in the column, plus All and Blanks.

Next to each item in the list there is a checkbox. To filter out a value from the column, uncheck its checkbox. To uncheck all values, uncheck the All checkbox. Check the All checkbox again to check all the checkboxes again.

If the Blanks checkbox is checked, rows without a value in the column are displayed when the filter is applied.

When the required filter conditions have been selected, click OK to close the window and apply the filter.

The filter is then applied. The value that the column is being filtered by is displayed in the filtering row field for the column. If the column is being filtered by multiple values or by and a text filter (see below), Custom is displayed.

To edit a Multi-select style filter, access the filter window again and change the filter criteria as required. To clear the filter, click Clear Filter. See also Removing Filtering.

Text Filters

More advanced filters can be applied:

1. Click Text Filters. A list of text filtering criteria is then display, plus Custom Filter.

   

2. Click on the required criterion. The Custom Filter window is then displayed.

   

   The first field displays the name of the column that list is to be filtered by. This cannot be changed.

3. The second field displays the criterion selected when the window was accessed. If the Custom Filter option was selected, this field is blank. Select a different criterion from the list of values if required.

4. In the third field, select the value to filter by. The list accessed from this field contains every value in the column plus options for filtering out records that do not contain values.

5. If another filter condition is required, click the Add button. Another row of fields is then displayed. Select a filter criterion and enter a value as described above.

6. To delete a filter condition, select the criteria row and click the Delete button.

7. If more than one filter condition has been specified, select Any from the Filter based on list if records meeting any of the conditions are to be displayed in the list when the filter is applied.

8. If only records meeting all the conditions are to be displayed, select All.

9. Click OK to apply the filter.