Using Filter Rows 

Use

To define a filter, first display the filter row in the list. In the filter row, you specify the filter criteria for each column.

If you define filter criteria in multiple columns, only those data records that fulfill each of these criteria are displayed.

Syntax

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

Syntax for Filters in the Filter Row

To display only those data records that...	Use…	Example
…contain the value [comparison value]	[empty] or =	123 or = 123
…contain a value that is greater than [comparison value]	>	> 123
…contain a value that is less than [comparison value]	<	< 123
…contain a value that is either greater than or equal to [comparison value]	>=	>= 123
…contain a value that is either less than or equal to [comparison value]	<=	<= 123
…contain any value, but not [comparison value]	! .	! 123
…contain any value between [lower limit] and [upper limit] (including these limit values)	. - .	100 – 123
...contain any value below [lower limit] or above [upper limit], but no value in between (and also not the limit values)	! . - .	! 100 – 123
...fulfill at least one of the filter criteria	. ; .	a – d; p - s

If you want to use a character string as a filter and this character string contains one of the special characters listed above (such as C-1025), you need to place the entire character string in quotation marks ("C-1025", for example).

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 enables you to find multiple terms when using just one comparison value. You use the asterisk (*) as the wildcard character in the filter row.

You want to identify all data records in the current column that end with ouse, such as House and Mouse.

To do this, you enter *ouse as the comparison value.

Escaping Wildcard Characters

To sort the list according to a comparison value that contains an asterisk (*), you need to indicate to the system that the character is not to be interpreted as a wildcard character: you need to escape the wildcard character. To do this, you precede the search character with a backslash (\) as the escape character.

To identify all data records in the current column that contain *ouse, you use \*ouse as the comparison value.

Prerequisites

●      The pushbutton  with the quick info text Display Filter Row is displayed in the application toolbar.

●      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.

Procedure

...

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

The filter row is displayed 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 quick info text 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.

       4.      To delete specific filters, delete the filter criteria for the column in the filter row.

       5.      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.