Filtering Objects

Teradata® Viewpoint User Guide

brand
Analytical Ecosystem
prodname
Teradata Viewpoint
Teradata Workload Management
vrm_release
16.20
category
User Guide
featnum
B035-2206-107K

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.