Filter Symbols

Teradata Viewpoint User Guide

brand
Analytical Ecosystem
prodname
Teradata Viewpoint
vrm_release
16.00
category
User Guide
featnum
B035-2206-106K
Use wildcard characters or symbols in a filter to expand or limit 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.
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???

p???er

cats, catalog

scat, Scatter

catalog

catalog

packer, parser, proper

All summary tables
* 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*

*ews*er

*%

cat, cats, catalog, s catter, wild cat

catalog

cat, cats, catalog

n ewscaster, n ewspaper

what is 100%?

All summary tables
= 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