Query Development | Filter with Data Filter | Teradata Studio/Studio Express - Filtering with Data Filter - Teradata Studio

Teradata® Studio™ Express User Guide

Product
Teradata Studio
Release Number
17.00
Published
January 2021
Language
English (United States)
Last Update
2021-01-11
dita:mapPath
ovm1576517377363.ditamap
dita:ditavalPath
ft:empty
dita:id
B035-2042
lifecycle
previous
Product Category
Teradata Tools and Utilities
Use the Data Filter feature to set filter rules that reduce the number of rows loaded into the Table Data Editor.
  1. From the Table Data Editor, click "" .
  2. In Filter, select a filter operator from the list and type a valid value or character string.
    For example, if values in Column2 are type VARCHAR, and you filter to display only rows LIKE product2, the Table Data grid refreshes to show all rows with the value product2 in the data string.
  3. [Optional] To clear all rules and set new filters, click Clear All.
  4. Click OK to show filter results based on your filter rules.
    The SYSUDTLIB database always shows in the filtered list.
  5. When asked to confirm, click OK.
    To redo the filter results, click Revert, change the filter rules in the Data Filter, and then click OK. You can repeat these steps as often as you like.