Set a filter to display only the data that you are most
interested in.
Before you begin
The table data editor must be open.
Procedure
To filter data in the table data editor:
- Click the
button (Filter the data)
on the editor's toolbar. The Table
Data Filter window opens. The columns that are selected
to be displayed are shown on the right. The columns that are available
to be displayed are shown on the left.The first time that you open
the Table Data Filter window, none of the columns
are selected to be displayed. You must choose the columns to be displayed.
When you reopen the Table Data Filter window,
any filter conditions that were previously set are displayed.
- Define filter conditions. For example, you can:
- Select the columns in the table that will be displayed. You can
also specify whether to sort the columns, and the order in which the
columns are sorted.
- Define conditions so that only the rows that meet those conditions
are returned.
- Specify the maximum number of rows that are returned in the Rows
to Return field. This value overrides the maximum number
that is specified in the Preferences settings for Max
Row Count (). The value that you enter in this
field applies only to the current table data editor.
Tip: If the object has many columns, use the search
text box to specify a filtering pattern for the list of available
column names.
- Click OK. If the generated
query from the filtering condition does not run successfully, an error
is returned. If the query fails, redefine the filter and try again.
If
you click Cancel in the Table Data
Filter window, any input is discarded and the table data
editor is displayed in its previous state.
Results
The table data editor is refreshed to display the filtered
data. The title at the top of the table data editor is appended with
the label
[Filtered] to indicate that a filter is
in effect. To turn the filtering off, open the
Table Data
Filter window, specify that all columns are to be displayed,
and remove any row conditions.