2011

Sort By
Click the down arrow and select the column in the table to sort by. Columns
with binary or user-defined data types are not listed.
Ascending
Sort from the beginning of the alphabet, the lowest number, or the earliest
date.
Descending
Sort from the end of the alphabet, the highest number, or the latest date.
Table Filter dialog box
Use this dialog box to select records from the database table.
To use a SQL filter in the Data View (page 1231)
In the Data View: Records ➤ SQL Filter
NOTE Data View displays attribute data linked to drawing objects. For information
about viewing attribute data for geospatial features, see
Overview of the Data
Table
(page 1125).
When you apply the filter, the Data View searches the current database table
and displays only records that match the specified conditions.
To edit an existing condition, select the line in the SQL Filter list. Edit the
information in the Where Condition area. When you finish editing, click
Update.
To add a new line, select a joining operator (And/Or/Not). Select a column
and an operator and specify a value. When you finish, click Add.
SQL Filter area
View the current filter. If lines in the filter were grouped, the group is
indented.
Group
Group the selected conditions. Conditions in the group are evaluated before
other conditions.
Table Filter dialog box | 1693