2011

Table Of Contents
Use a SQL filter to view only records whose data matches specified conditions.
NOTE You can also filter records based on the location of linked objects. If both
a SQL filter and a spatial filter are defined, the Data View displays only those records
that match both filters.
You can set an option to determine how many filters AutoCAD Map 3D stores.
See also:
Opening a Database Table (page 1052)
Editing a Database (page 1055)
Setting Data View Options (page 237)
Changing the Look of the Data View (page 1057)
Finding Data View Records Based on Object Location (page 1233)
NOTE This procedure applies only to drawing objects. For information on filtering
geospatial feature data, see
Using Expressions to Select Feature Data (page 1131).
To use a SQL filter in the Data View
1 Open a database table in the Data View. See Opening a Database Table
(page 1052).
2 In the Data View, click Records menu SQL Filter.
3 In the
Table Filter dialog box (page 1693), define the condition for the filter.
To select from a list of conditions previously defined for this table, click
History and select the condition.
To define a new condition:
Under Where Condition, select the column to use as a filter.
Finding and Querying Drawing Objects | 1231