Autofilter

The Autofilter option allows you to define conditions in lists quickly and easily.

Below are the steps to define auto filter.:

Switch to list view.
Right click on a column heading. A popup menu is displayed.
Select Define Autofilter.Different dialog boxes are displayed depending on the field type.
- If the field is a catalog, a list of the catalog values is displayed. For dependent catalogs, the parent catalog value has to be selected first.
- For Boolean (logical) fields, you can select between "Yes" (true) or "No" (false).
- For all other fields, a dialog box is displayed in which you can define a condition. An operator and comparison value can be selected here.
Choose the desired values and confirm with OK.
The list now displays data according to the conditions you defined. The Autofilter option in the popup menu is displayed with a tick, and an asterisk (*) is displayed in the column.

If you define criteria for further columns, i.e. fields, the criteria are linked with a logical AND.

To remove an autofilter:

Right click on the column header and select Remove Autofilter from the popup menu.
Select Autofilter from the popup menu to remove the tick and disable the autofilter for all fields.

Note: If you enable an autofilter in addition to active conditions, you are informed that the conditions is removed.

You can also define time ranges using the calendar for date fields. This defines condition with two lines which can only be edited by selecting Data > Define Conditions menu option.