Using the Filter Row

Use

To define a filter, show the filter row in the list. Here you formulate the filter criteria for each column.

Prerequisites

  • In the toolbar there is a button with tooltip Display Filter Row

  • To be able to define a filter in this filter row, the cell of the column must have a white background. Otherwise filtering is not permitted for this column.

Setting Filters

  1. To define a filter using the filter row, in the application toolbar for the list, choose with tooltip Display Filter Row.

    The filter row is shown as the first row in the list.

  2. Define the appropriate filter criteria in the relevant columns.

  3. To apply the filter or filters to the list, press Enter or choose with the tooltip Filter at the beginning of the filter row.

    The list is restricted to those data records that fulfill the filter criteria defined in the filter row.

Removing Filters

  1. To remove single filters, delete the filter criteria for the column in the filter row.

  2. To hide the filter row and thereby delete all filters in it, in the application toolbar for the list, choose with the quick info text Delete Filter and Close Filter Row.

Defining Complex Filters

Syntax

To define a filter, use the following syntax in the filter row:

To display only those data sets in the current column...

use...

Example

...has the value [comparison value]

[empty] or

=

123  or

= 123

...have a value larger than [comparison value]

>

> 123

...has a value less than [comparison value]

<

< 123

...has a value that is either greater than or equal to [Comparison Value]

>=

>= 123

...has a value that is either smaller or equal to [comparison value]

<=

<= 123

...has any value other than [comparison value]

! .

! 123

...has any value between [lower limit] and [upper limit] (including these limit values)

. - .

100 – 123

...has a value under [lower limit] or over [upper limit], but not a value between the two (nor the precise limit value)

! . - .

! 100 – 123

...fulfills at least one of the filter criteria

. ; .

a – d; p - s

Using Replacement Characters

In comparison values, you can use a special replacement character for one or more characters; this replacement character is a wildcard character. This makes it possible for you to find multiple terms with one comparison value. Use the asterisk * as the wildcard in the filter row.

Escaping Wildcard Characters

To filter the list for a comparison value that contains the character *, you have to tell the system not to interpret the character as a wildcard: You escape the wildcard. To do this, enter the escape character \ in front of the character for which you are searching.