| Wildcard or Symbol | Description | Example | Results | Supported Portlets |
|---|---|---|---|---|
| ? | Use this wildcard character to match alpha or numeric characters in the position it occupies. Type this wildcard character at the beginning, middle, or end of your search. This wildcard character can be used more than once in the same search. This wildcard character can be used in conjunction with any other symbol. |
cat? ?cat cat?l cat??? |
cats, catalog scat, Scatter catalog catalog |
All summary tables |
p???er |
packer, parser, proper |
|||
| * | Use this wildcard character to match zero, one, or multiple alpha or numeric characters in the position it occupies. Type this symbol at the beginning, middle, or end of your search. This wildcard character can be used more than once in the same search. This wildcard character can be used in conjunction with any other symbol. |
*cat cat*l cat* |
cat, cats, catalog, s catter, wild cat catalog cat, cats, catalog |
All summary tables |
*ews*er |
newscaster, newspaper |
|||
*% |
what is 100%? |
|||
| = | Use this symbol at the beginning of your search to match alpha or numeric characters literally. The search results are case-sensitive. This symbol can be used in conjunction with * and ?. |
=CAT =cat? =Cat* =Cat_ =Cat\? |
CAT cats Cat, Cats, Catalog Cat_ Cat? |
All summary tables |
| \ | Use this symbol in front of a wildcard character so the wildcard is interpreted as a regular character and not as a wildcard. This symbol can be used in conjunction with *, ?, and \. |
*\? =cat\* cat\? |
what is 100%? cat* cat?, Cat? |
All summary tables |
| > | Use this symbol to match any number that is greater than the specified value. This symbol is only used to perform mathematical comparisons. For columns containing percentages, avoid using % in the filter. Type only > and the number. |
>60 | 61, 62, 70, 500, and so on | All summary tables except in the Query Group Setup portlet |
| >= | Use these symbols in conjunction to match values greater than or equal to the specified number. For columns containing percentages, avoid using % in the filter. Type only >= and the number. |
>=60 | 60, 61, 62, 70, 500, and so on | All summary tables except in the Query Group Setup portlet |
| < | Use this symbol to match any number that is less than the specified value. This symbol is only used to perform mathematical comparisons. For columns containing percentages, avoid using % in the filter. Type only < and the number. |
<60 | 59, 58, 50, 8, and so on | All summary tables except in the Query Group Setup portlet |
| <= | Use these symbols in conjunction to match values less than or equal to the specified number. For columns containing percentages, avoid using % in the filter. Type only <= and the number. |
<=60 | 60, 59, 58, 50, 8, and so on | All summary tables except in the Query Group Setup portlet |
| ! | Use this symbol at the beginning of your search to match alpha or numeric characters that do not contain the alpha or numeric characters. This symbol can be used in conjunction with any other symbol or wildcard character. |
!cat33 | cat32, cat34, and so on | All summary tables except in the Space Usage and Query Group Setup portlets |
Use wildcard characters or symbols in a filter to expand or limit the search criteria. Some symbols are used for string filtering and others are used for numeric filtering. String filters are not case-sensitive and an asterisk wildcard is applied to the end of the filter string.