Filtering data in the table data editor

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:

  1. Click the Graphic of the icon for the Filter the data button 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.

  2. 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 (Window > Preferences > Data Management > SQL Development > SQL Results View Options). 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.
  3. 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.

Feedback