Toad Data Point 6.0.5

Converse agora com nosso suporte

Create ODBC Connections Create Oracle Connections Create Snowflake Connections Create SQL Server Connections Create SharePoint Connections Understand Toad Connections Troubleshoot SQL Server Connections

Understand

Determine the Best Method to Locate Objects Object Explorer Filter Databases and Objects Understand a Table Using the Database Explorer Search for Objects Create an Database Diagram to Use as a Query Template Browse Data in Related Tables

Query

Tutorial: Build a Query Visually Create Cross-Connection Queries Reverse Engineer Queries Build a Subquery Edit SQL Editor Shortcut Keys View Result Sets Compare Differences in Data Export Data with One Click Export Share Excel Linked Queries

Report

Tutorial: Create a Toad Data Report Manage Reports

About Managing Reports DB2 Reports MySQL Reports ODBC Reports Oracle Reports SQL Server Reports

Publish and Share Reports

Automate

Getting Started with Automation Tutorial: Automate Excel Reports Automate Tasks Use Database Automation Activities Use File Automation Activities Use System Automation Activities Use Variables In Automation Execute/Schedule Automation Scripts

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:

Where clause to specify a selection of the data to view or edit
Columns to include in the data filter. If you do not select any columns, all columns are included in the filter. You can also right-click to select all or none of the columns.
Order in which to fetch data from the server. This is useful for correctly sorting data without fetching it from the database.
Custom SQL

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:

Named filters are set for a given table in a specific schema on a specific connection.

Renaming a table that has a filter results in an orphaned filter.

Orphaned filters are automatically removed unless you used a tool other than Toad to remove them.

Troubleshoot Advanced Filters:

When you set a data filter, the option to limit the number of rows initially fetched is ignored. If you are browsing large tables, the load on the server is higher (before applying the Where clause and Order By) than it is when browsing the unfiltered tables.
If you cannot edit the filtered data, make sure that any columns that contain a primary key are included in the filter.

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:

To clear a filter, click in the bottom left of the Filter pane or right-click each filtered column and select Clear Filter.
To clear all database, object, and data filters, click in the Explorer toolbar.

Selecione seu produto:

Para podermos atendê-lo melhor, informe o Propósito de seu chat:

Soluções recomendadas para seu problema

Toad Data Point 6.0.5 - User Guide

Filter Data

Define Advanced Data Filters

Define Basic Data Filters