Filtering data in the data browser

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:

  1. Click
    Graphic of the icon for the Filter button
    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.
  2. 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 (Windows > Preferences > Data Management > SQL Development Results View Options > Max Row Count). 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.
  3. 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.

Feedback