Set a filter to have only the data that you are most interested
in seeing retrieved and displayed.
Before you begin
The data browser must be open.
Procedure
To filter data in the data browser:
- Click in the browser'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.
- Define filter conditions. For example, you can:
- Select which columns in the table are to be displayed, whether
to sort the columns, and the order in which the columns are sorted.
Use the buttons to add and remove columns from the list of columns
that are selected to be displayed.
- 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 (). The value that you enter in
this field applies only to the current data browser.
Tip: If the object has many columns, use the search
text box to specify a filtering pattern over the list of available
column names.
- Click OK. If the generated
query from the filtering condition cannot be 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 data
browser is displayed in its previous state.
Results
The data browser is refreshed to display the filtered data.
The title at the top of the data browser 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.