Get Started with Calyx RIM 7.1

Filter Symbols

Oracle is used as the basis for the Set Filter function, and some special characters should be used carefully.

Special characters that should be used with caution in a filter:

Symbol Issue
% (Percent symbol) Oracle perceives the percent sign as a wildcard. When the percent sign is entered as filtering criteria, the results are not filtered.
_ (Underscore) The following occurs when using underscores in a filter:
  • No filtering occurs if you set a filter with only an underscore.
  • Inserting an underscore before or after characters (e.g., _abc, abc_, or _abc_) returns all records that contain the underscore character.
  • Inserting an underscore between characters (i.e., a_b or a_b_c) returns records that contain the characters presented in the designated order that have any single character between them.