16.00 - Data Filter - Teradata Studio

Teradata Studio User Guide

Teradata Studio
March 2017
User Guide
The Data Filter dialog enables you to define data filters for the Table Data Editor. Use filtering to reduce the number of rows loaded into the Table Data Editor and to display only data of interest. You can determine which data displays by:
  • Sorting column order
  • Filtering on data values within columns

Filter Tab

Move column names from the Table Column list to the Sort Column list to indicate on which columns to sort to display data in the Table Data grid.

Option Description
Column Names Lists names of columns in table.
Types Lists data type for each column in Column Names.
Select By Select a filter operator from the list and type a valid value or character string. For example, if values in Column1 are type INTEGER, and you filter to display only rows greater than (>) 5999, the Table Data grid refreshes to show all rows with the value 6000 or above.

Sort Tab

Use fields and radio buttons in this section to indicate how you want columns sorted.

Option Description
Table Columns Lists all columns by name in the table.
Ascending Orders the Table Columns list from the smallest or lowest to the largest or higher value. For example, A to Z or 1 to 100.
Descending Orders the Table Columns list from the largest or higher value to the smallest or lowest value. For example, Z to A or 100 to 1.
Sort Columns Lists one or more columns in the order on which to sort.
Up Select a column in the Sort Columns list and click Up to move it up in the list order.
Down Select a column in the Sort Columns list and click Up to move it up in the list order.


Use the action buttons at the bottom of the dialog to clear or save your settings.

Option Description
Clear All Click to revert all selections in the Select By column to the default None.
OK Click to save your Filter and Sort settings.