Filter Symbols | Teradata Viewpoint - Filter Symbols - Teradata Viewpoint - Teradata Workload Management

Teradata® Viewpoint User Guide

Product
Teradata Viewpoint
Teradata Workload Management
Release Number
16.50
16.20
Published
July 2021
Language
English (United States)
Last Update
2021-07-27
dita:mapPath
yqb1520516846011.ditamap
dita:ditavalPath
yqb1520516846011.ditaval
dita:id
B035-2206
lifecycle
previous
Product Category
Analytical Ecosystem
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???

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