1. Logical “Or operator”
By default, the filter is active in this mode. In the following example, you want to find all records with at least one of the tags “Important” or “Development”. This also means that records can either have one of the tags, or both.
Due to the colour coding of the tags in the data records, it can be seen that the first two data records have one of the tags, while the third one has both tags. However, all three are included in the results. At least one filter criterion must be met.
2. Logical “And operator”
This mode is activated directly by the checkbox in the filter. Each filter criterion has its own checkbox.
In contrast to the “OR link”, the “AND link” must fulfil both criteria. Accordingly, in the present example, only the records that have both the tag “important” and the tag “development” are listed with the results.
Filter tab in the ribbon
Saving, editing, and deleting filters
In many cases, it is recommended to store defined filters. In this way, it is possible to make efficient use of filter results from previous searches. The button “Save filter” prompts you directly to assign a meaningful name for this filter. The filter is saved according to the criteria currently configured in the filter. This filter is now listed in the selection menu and can now be selected. Note that a selected filter selection is immediately applied to the filter but is not automatically executed. The filter must be used for this purpose. Both the button in the ribbon, so also the counterpart in the filter, lead to the same result here.
Deleting and overwriting existing filters is identical in the procedure. The filter, which has been marked in the selection field, is always deleted. If an existing filter is to be overwritten, the name of the filter is retained and is overwritten with the filter criteria currently configured in the filter.
In the “Extended filter” category you can adjust the filter as desired, eg by adding or removing filter groups. Clicking on “Edit filter” activates the processing mode. You can terminate it with “Finish editing”.
New filter groups can now be added via the selection field. For this purpose, the desired filter type is selected (in the example, the filter group is the seal). The process is completed by “adding a filter group”. Newly added filter groups are always placed at the very bottom of the filter.
In Edit mode, the filter view changes, in addition to the possible actions in the ribbon. Use the arrow buttons to adjust the order of the filter groups. The icons “Plus” and “Minus” can be used to create additional instances of existing filter groups or to remove existing ones. In the following example, a content filter was added and all other filter groups removed.
In this example, only the content filter is used – in two instances! * The “And” link will now display all records that contain both the word “password” and the phrase “important”. *
Negation of filters
In Edit mode, there is also the possibility to negate criteria.
It is thus possible to refine very precisely filter results even further. This becomes more and more important when there are a large number of records in the database and the resulting amount of data is still unmanageable despite the fact that filters has been appropriately defined.
Negations are defined directly in the checkbox of an element within a filter group. Without negations, you can only search e.g. for a tag. Negations make the following queries possible:
“Deliver all records that have the tag “development” but are tagged with “important”!”