Setting and Deleting Filters
The following Notes are only valid for the Grid and List display.
This function is not available for the tree display.
Use
If necessary, you can display a list of only those rows that fulfill specific criteria with regard to one or columns.
Procedure
Set Filters
...
2.
Choose 
→ Set
Filters.
Or:
...
2. Use the secondary mouse button to click on one of the selected headers.
3. Choose Set Flters.
The Define Values for Filter Criteria dialog box appears.
If you click a cell with the right mouse button and choose Set Filer, the Define Values for Filter Criteria dialog box appears with the content of the cell as the value of the affected filter criteria. Once this dialog box is confirmed, the column is then filtered according to this value.
To determine the values or intervals of values that are to be displayed in your list, enter the From or From and To values for your filter criteria.
Only one filter is active on a list at one time. This filter consists of one or more filter criteria. To filter across multiple columns for a list, set a filter with multiple filter criteria.
To apply
your changes, choose 
.
If you want
to include more than only value or interval for a column, choose 
.
The Multiple Selection for... dialog box appears. You have the following options for entering further values:
● You can enter additional values that are to be displayed for the filter criteria under the Single Values (with a green traffic light) tab.
● You can enter additional from/to values that are to be displayed for the filter criteria under the Intervals (with a green traffic light) tab.
● You can enter additional values that are to be excluded for the filter criteria under the Single Values (with a red traffic light) tab, that is, they are not to be displayed.
● You can enter additional from/to values that are to be excluded for the filter criteria under the Intervals (with a red traffic light) tab, that is, they are not to be displayed.
The number of existing entries for each tab are then displayed in the tab description:
To define the selection options for a value entry, double-click the pushbutton next to the input field. For more information about selection options, see Overview of Functions in Dialog Boxes.
To apply
your changes, choose .
Overview of Functions in Dialog Boxes
●
To check if
your entries are correct (that is, if they are in the correct format), choose
.
●
To insert
the row, choose 
.
●
To delete
the values that have been entered for a filter criterium, select the relevant
column and choose 
.
●
To delete
the specified values for all filter criteria, choose 
.
●
To define
the selection options for a value entry, choose 
. The Maintain Selection Options dialog
box appears.
Selection Options
With the selection options you are further able to describe your filter settings. The starting points are the values of the previous dialog box. That is, the selected entries correspond to the settings on the dialog box where you triggered the Maintain Selection Options function.
To deny these settings, for example, to change the setting from smaller to not smaller, choose Exclude from Selection. To restore the initial settings, choose Select.
To apply
your changes, choose . Your
selected settings are displayed on the start dialog boxes.
The meaning of the symbols that appear in front of the values are displayed to you in the form of a legend. To display this information, place your cursor over the relevant symbol.
Procedure Without Column Selection
If you have
not selected a column and → Set Filter, or chosen the path using the right mouse button, the dialog box
Define Filter Criteria appears. In this dialog box you specify which
columns are to be filtered. Proceed as follows:
...
1. Select the relevant entries in the Column Set.
2.
Click 
to copy the selected entries to the Filter
Criteria.
Or:
...
1. Select the relevant entries in the Column Set.
2. Click again on the selected entry or entries without releasing the mouse button. The cursor now appears with a small square.
3. Drag the entries to Filter Criteria and drop them.
To search for terms,
choose 
.
To change the sequence of filters, proceed as follows:
...
1. Select one or more entries.
2. Click again on the selected entry or entries without releasing the mouse button. The cursor now appears with a small square.
3. Drag the entries to the required position.
The entry is added before the selected row.
Or:
...
1. Select one or more entries.
2. In order to move an entry/entries
○
up one
entry, choose 
,
○
down one
entry, choose 
,
○
to the start
of the filter sequence, choose 
,
○
to the end
of the filter sequence, choose 
,
To remove
the entries from the filter criteria, choose 
.
Confirm the
dialog box with to copy the relevant settings.
Result
If a column has been filtered, then a small black filter is shown in the column header.
Delete Filters
As only one filter is active on a list, the whole filter is deleted with the Delete Filter function and not only the individual filter criteria. Explicitly selecting columns therefore has no effect on the Delete Filter function. To delete individual filter criteria, repeat the setting and deleting filter criteria procedure as required.
To delete
the filter, choose → Delete Filter.
Alternative Use in Fullscreen Mode
Aside from the procedure described here, in fullscreen mode you also have the option to trigger the functions using the menu path.
Proceed as follows to set a filter:
...
2. Choose Edit → Set Filters.
To delete a filter, choose Edit → Delete Filter.