Filtering Records in the Search Table
By filtering records, we narrow the list of all records to those that match the selected criteria. We can further filter records by all those criteria they can be sorted by. Filtering can be used in conjunction with record sorting (see Sorting records in the search table).
Table of contents
- Adding a filter
- Filtering
- Operators
- Filtering by multiple criteria
|
1. Adding a filter
We left-click on any line of the field that we want to use as a filter criterion. We hold down the left mouse button and drag the selected column into the central field. When we are in the allowed area for adding filter criteria, the adding icon 
appears under the cursor.
We release the button in this area. The filter data is the same as in the field we used to define the filter. The default operator is the equals operator (so by default we filter by records that are the same as the selected record). The default value for the filter is the value from the selected field.
2. Filtering
When a new filter is set, the following information is displayed:
| (Field Name) |
The name of the field used as the filter criterion |
| (Operator) |
The default operator is the equal sign. The operator can be changed if necessary. |
| (Value) |
A field for entering values. For the default filter value, the program offers the selected record. |
By clicking the 
(Remove filter) icon, the filter is removed.
3. Operators
By selecting the operators, we define the display of the data according to the selected filter. The operators are:
| = |
equals. |
| <> |
not equal. |
| contains |
Contains |
| starts |
Starts with. |
| Ends with. |
Ends with. |
| from-to (range) |
From including to including. With this filter criterion, we have two fields to enter the filter criterion: including start (from) and including end (to). |
| >= |
Greater than or equal to. |
| <= |
Less than or equal to. |
4. Filtering by multiple criteria
It is also possible to filter by multiple selected additional criteria. As the first one, additional sorting criteria are added by clicking a value and moving it to the appropriate place.
 |
WARNING
If you select multiple filtering criteria, they are always combined (logical AND). The program will display the values that match all the criteria.
|
Filter settings are preserved until they are manually removed by selecting 
(Remove Filter).
|
WARNING
If we try to place a filter in an area where this is not allowed, the operation will fail. This is indicated by the shape of the cursor – adding a filter to an area that is not intended for it.
|