Filter types

Depending on the data type of a column, a corresponding filter is displayed in the list header. In addition to common text/number and Boolean filters, date filters and filters for enumerations (usually for values from dynamic enumerations) are supported.

Text/Number filter

The text and number filter is the simplest filter form. This only allows the input of a search expression. As a rule, filtering is performed for exact matches without specifying any particular control characters. To be able to filter more dynamically, the text filter also supports Wildcards.
With the help of such wildcards, search expressions can be defined, which also enable more complex filters.

Filter expressions with wildcards

Wildcard	Description	Example
*	Case-insensitive subtext filter	search value Matches 'Find this search value' or 'Search value help to filter' Search value* Applies to 'Search values help filtering' but not on 'Find this search term'
%	Case sensitive subtext filter	%searchvalue% Does not apply to 'Find this search term' %Searchvalue% however already Searchvalue% Applies to 'Search terms help filtering'
>	Filters for numeric values which are greater than the specified value	>5 Applies to numbers greater than 5
<	Filters for numeric values which are smaller than the specified value	<5 Applies to numbers less than 5
=	Filters for numeric values which are equal to the specified value. Combine with <, > and !	=5 applies to 5 only >=5 Applies to numbers greater than or equal to 5
!	Negates the filter expression	!5 Applies to all numbers except 5
&	Conjuction (AND) expressions	>5&<10 Applies to numbers between 5 and 10
\| (Pipe)	Disjunction (OR) expressions	<5\|>10 Applies to numbers less than 5 or greater than 10

Concatenation of expressions

Filter expressions can also be combined using '|', '&' and by bracket replacement.

Example
(!(<5|>10) & !7) | 100
Find values that are equal to 100 or values that are between 5 and 10 but are not equal to 7.

Date filter

The date filter is able to filter by predefined date ranges, times or also by a user-defined time period.

Filter value	Description
Last XX minutes/hours	Filters for values which are within the last minutes/hours
This hour	Filters for values that are within the current hour (not to be confused with Last 60 minutes)
Last hour	Filters for values which are within the last hour (not to be confused with Last 60 minutes)
Next hour	Filters for values which are within the next hour
Today	Filters for values which lie within the current day
Yesterday	Filters for values which are within the past day
Tomorrow	Filters for values which are within the next day
...	The remaining filter values are analogous to the already documented options according to their names
Custom...	It is filtered for date values which are in a defined range (1). If the 'Immediate search' option (4) is deactivated, the filter can be applied by clicking on (2), otherwise the filter will be applied automatically when the section is changed. Function (3) removes the filter.

Boolean filter

The Boolean filter distinguishes between true (set) or false (unset) values. The filter value is visualized by a checkbox. By clicking on the checkbox, the filter value can be changed.
To remove the filter, click on the box until it reaches the "Undefined" state. See the table below:

Filter value	Image	Description
True		Applies only to true/set values
False		Applies only to false/not set values
Nicht definiert		Applies to both true/set and false/not set values

Enumeration filter

An enumeration filter provides a defined set of filter values, which is automatically applied by selecting one or more values. To include several values in the filter, they can simply be selected one after the other.
If more than one filter value was selected, the input line of the filter shows an element with the label 'x selected' to save space. By clicking on this element the currently selected filter values can be viewed and edited:

images/download/attachments/69045435/image2017-7-21_10_44_9-version-1-modificationdate-1615474497407-api-v2.png

The individual filter values are set as an (OR) disjunction. In the example shown above, the filter is based on elements whose language is either German or English.
Clicking on 'x' removes the corresponding filter value.