Enabling and Disabling Filters

JDeveloper provides filters so that you can view defined sets of schemas, tables, views, or other objects.

To create filters for online database objects:

Select View | Connection Navigator.
In the Connection Navigator, select Database .
Expand Database, and select any connection, schema within a connection, or folder within a schema, then perform either of these actions:
- Right-click your selection and choose Apply Filter.
- In the Connection Navigator toolbar, click the filter icon .
A filter dialog appears, appropriate to the object you selected. For connections and schema, a selection box appears. For other objects, type in the text (case-sensitive) which JDeveloper matches to object names in the selected folder. You can use the wildcard character %.
Click OK. Notice that the list of objects is now filtered to display only those names that match the criteria you selected.

Notes

Synonyms hide public synonyms by default. To change this, select a Synonym folder in a schema, right-click and select Apply Filter, and select the Show Public Synonyms checkbox.
Schemas by default hide all schemas except the one corresponding to the user ID that you used to create the connection. To change this, select a connection, right-click and select Apply Filter, then change the default filter setting as needed.

If you create a connection and leave the default filter in place, then edit the connection and change the user name (schema name) in the Authentication page of the Edit Database Connection dialog, the default filter will display only the schema that corresponds to the new user name. If, however, you have altered the default filter, this changed filter remains active and is not reset when you edit the database connection.