Create and Manage Filters#

Introduction#

For the new major release 2022 we have made a complete redesign of filters with focus on faster input, combination of multiple filters and improved visibility. We hope that you will like the new feature!

Syntax#

Relational Operators#

Symbol	Operator
`==`	equal (default if nothing is specified)
`!=`	not equal
`>`	greater than
`<`	less than
`>=`	greater than or equal
`<=`	less than or equal

Logical NOT#

Symbol	Operator
`!`	The logical NOT (!) operator (logical complement, negation) takes truth to falsity and vice versa.

! at beginning inverts other filter conditions, e.g.

![1;2] is the negation of [1;2] or
!<=3 is the negation of <=3 or
… etc.

Wildcard#

Symbol	Operator
`*`	Any number of characters
`?`	Any one character

The wildcard ? and * can be used on columns that contain text and integer values.

Range Filter#

Syntax	Short description
`[FROM;TO]`	Range filter between FROM and TO, include both values
`[FROM;TO[`	Range filter between FROM and TO, include FROM, but exclude TO
`]FROM;TO]`	Range filter between FROM and TO, include TO, but exclude FROM
`]FROM;TO[`	Range filter between FROM and TO, exclude both values

Examples:

[1;5] = range between 1 and 5, including 1 and 5
]1;5[ = range between 1 and 5, excluding 1 and 5
]1;5] = range between 1 and 5, excluding 1, but including 5
[1;5[ = range between 1 and 5, excluding 5, but including 1

Loop filter#

Syntax	Short description
`(FROM;TO;INCREMENT)`	Filter all values by using a loop with an increment.

Example:

(1;5;1) = will filter 1,2,3,4,5
(1;5;2) = will filter 1,3,5
(1;5;3) = will filter 1,4

Please note that the “Loop filter” works only on columns that contains integer values.

Special filter#

Extreme values#

Hint

The documentation regarding “extreme values” filter is still under development. A video is coming soon…