16.20 - 16.50 - Filtering Objects - Teradata Viewpoint - Teradata Workload Management

Teradata® Viewpoint User Guide

Product
Teradata Viewpoint
Teradata Workload Management
Release Number
16.20
16.50
Release Date
July 2021
Content Type
User Guide
Publication ID
B035-2206-071K
Language
English (United States)

Filtering allows you to display only objects that match your filter criteria in the object browser. Filtering is not case-sensitive.

Filter boxes are located at each branch and sub-branch of the directory tree, under the name of the database object. When you click next to the object, the filter box appears.
  • Filter by entering text in the box.

    For example, if you type dbc in the filter box under a Teradata Database name, objects containing dbc are displayed in the tree. If you use a wildcard, such as *dbc , objects beginning with dbc and DBC are displayed.

  • Filter for all other database object types by entering text in the box under the object type. Object types include Tables, Views, Macros, Functions, and Procedures.

    For example, if you type clear in the filter box under a Macros sub-branch of the tree, macros containing the string Clear are displayed in the tree.

Change the filter criteria by entering new text in the filter box. Unless you type new filter criteria or open other branches, the object browser maintains the state of the tree, including opened branches and applied filter criteria.

You cannot use ? or * as wildcards to match single or multiple characters in filter criteria.

The object browser can display a maximum of 500 objects at each branch of the tree. To display fewer results, enter filter criteria to narrow the list of database objects shown in the browser.