Learn more about Toad for SQL Server
at Dell Software

Find solutions and downloads at the
Toad for SQL Server Support Portal

Toad for SQL Server 6.6

You are here: Work with Data > Filter Data

Filter Data

You can filter data to reduce the amount of time required to query the data and display results. You can define an advanced data filter, which re-executes the query, or can define a basic data filter for a column, which does not re-execute the query.

Define Advanced Data Filters

When defining advanced filters, you can specify the following:

To define an advanced filter

» Click in the top left above the columns of data and select a filtering option.

Consider the following when using named filters:

Troubleshoot Advanced Filters:

Define Basic Data Filters

You can define basic filters to display a subset of records from a data grid. When filtered, the records that display are restricted to those that meet the current filter criteria. You can filter data against a single column or multiple columns.

Note: This feature is only available when using the Grid view.

To define a basic filter

Click to the right of the column header and select a filtering option.

When filtering is applied to columns, the arrow for the column header is highlighted. A Filter pane also displays in the bottom of the grid, which describes any applied filters, in the order applied, as illustrated in the following:

Tips:

 

Related Topics

About Working with Data 

of