Previous Topic: Filter the DisplayNext Topic: Filter Example


Rules for Setting Filters

Use any of the following operands to filter information in a panel:

Operand

Description

>

greater than

<

less than

=

equals; the default

¬

not equal to

¢

not equal to

~

not equal to

>=

greater than or equal to

<=

less than or equal to

Wildcard characters are allowed in filters. For a list of valid wildcards, see Wildcard Characters.

If you use a wildcard within a numeric value, that number is treated as a character string. For example, you can use the filter ??9 to filter a field to show only three-digit numeric values that end with the number 9.

If more than one filter is established for a panel, both conditions must be satisfied for the data to appear. If you want to use a filter that is wider than a column, you must use screen customization.