Quick filters

To quickly filter a list using a value in a field, right-click in the field and select Show Matching or Filter Out. For date fields, choose from Show Before, Show After, and Filter Out.

These functions add a condition to the right in the breadcrumb of the current filter.
Figure 1. Quick filter
Quick filter

In this example, right-clicking In Progress and selecting Show Matching adds the condition State = In Progress as the most specific condition of the filter. By contrast, right-clicking In Progress and selecting Filter Out adds the condition State != In Progress as the most specific condition of the filter.

For date and date-time fields, you can also use Show After or Show Before to define a time-based filter.

Using the quick filter method to filter out a particular value builds the following conditions: [field] [is not] [value] or [field] [is] [empty]. Records that contain empty or null values still display in the filtered list. If you manually create a filter, it does not automatically include the OR condition [field] [is] [empty], so records that have an empty or null value do not display in the filtered list.