3. Filter

Filters allow you to select and display only those table rows that meet certain criteria. In our example, you may want to display only albums that are out of stock. You can do this by the following steps:
1.
Display the filter definition area by clicking the button located next to the upper right corner of the table. A row appears under the table header, where you can define conditions determining which rows will be selected for display. As in a table, there is always one empty row at the bottom for the definition of a new filter condition.
2.
In the Stock column, click the button on the left side of the filter field, and select the “= equal” operation. (There is one field per column in the filter definition row, consisting of a button for the selection of required operation and a space where you can type a value to refine the operation).
3.
Type 0 in the field next to the selected operation. Only rows that have 0 in the Stock column will remain visible while all other rows will be hidden.
4.
When you have specified a filter, you can hide the filter definition area by clicking on the same button that you used to display it. The filter remains in effect even if you hide the filter definition area. When a filter is applied to the table, the image on the button for displaying/hiding the filter changes to .
You should keep in mind that the application of a filter does not physically remove hidden rows from table data; instead, a view of the table containing only some rows is created. When you cancel the filter, all table rows are displayed again.

Filter Cancellation

1.
Display the filter definition area with the button.
2.
Activate any field of the filter row containing the filter condition by a mouse click (or by the arrow keys).
3.
Press Ctrl+Delete or the button in the tool bar to remove the filter row.
4.
Hide the empty filter definition area again using the button.

Combining Filter Conditions

You can also define a filter that combines multiple conditions. Suppose you wish to display all the albums by the Echt! band that are in stock. In a single filter definition row, set the condition in the Artist column to “= Echt!” and the condition in the Stock column to “> 0”:
If there are two (or more) conditions on a single filter definition row, they must be satisfied at the same time, or otherwise the row is excluded from the view. In other words, conditions in the same row are conjunctive – they are combined by the “and” logical operator.
If you wish to specify a condition that includes “albums newer than 2000, but all from Metallica” (in other words, “the Album has year greater or equal to 2000, or the Artist is Metallica”), enter the “≥ 2000” condition in the Year column on one filter row and the “= Metallica” condition in the Artist column on a new filter row:
If filter conditions are specified on different rows, a table row needs to satisfy only one condition in order to be included in the view (in other words, every new row of the filter definition adds those table rows to the view that satisfy the filter row). That is, the conditions are disjunctive – they are combined by the “or” logical operator.

Further Information

All filter options are explained in detail in the Filter chapter of the Reference Guide.