Working in the Environment › Filter the Display › Rules for Setting Filters

Rules for Setting Filters

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

Valid wildcard characters are asterisk (*), percentage (%), and question mark (?).

Asterisk: Use an asterisk at the beginning, middle, or end of a string to indicate the minimum acceptable string; for example:

• *XYZ displays anything that ends with the characters XYZ, regardless of what the string begins with.
• ABC*XYZ displays anything that begins with ABC and ends with XYZ, regardless of how many characters are in between.

Percent: Use a % sign to indicate that the position must be occupied by a number; for example:

The filter criterion XYZ%% displays all instances of XYZ followed by two numbers. XYZ30 and XYZ42 satisfy the condition, but XYZ173 and XYZ2A do not.

Question mark: Use a question mark to indicate that a given position must be occupied by any character, regardless of its type.

The filter JOB?A% displays all jobs that have JOB in the first three positions, any character in the fourth, an A in the fifth, and a number in the last position. JOB1A6 and JOB#A7 are displayed, but JOB1Z is not.

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.