Applying Filters to Oracle Database Explorer and IntelliSense Suggestions

You can apply filters to limit the amount of database schema objects that are shown in the Oracle Database Explorer tree control and that are offered as IntelliSense (autocomplete) suggestions.

Filters are applied on existing Oracle Database Explorer connections. To create a filter, follow these steps:

1. If needed, first create a connection by clicking the plus (+) sign to create a new connection, and following the steps in Connecting to Oracle Database or Connecting to Oracle Autonomous Database (ADB).

2. Right click on the connection node and select Filters to open the Filters dialog.

3. From the list on the left side of the dialog, select the filter type, for example Tables or Procedures. If you wish to create a filter that applies to all object types, then select the Connection filter type.

4. Under Filter Properties select Match Any or Match All. Match Any means that any filter property, if evaluated to be true, results in the object being displayed or suggested by IntelliSense (autocomplete). Match All means that all Filter Properties must be evaluated to be true for the object to be displayed or suggested in IntelliSense (autocomplete).

5. If no Filter Properties are shown click Add Filter to begin adding one.

6. Select the Property and Condition drop down boxes and enter a value in the Value field. If the value is a string, check the Case Sensitive check box if the value should be used exactly as entered (without being uppercased first).

7. Once you have entered the value, click the Add Filter button if you wish to add add additional Filter Properties.

8. To delete filter properties, click the X on the right of the filter property.

9. Check or uncheck the checkboxes labelled Enable filters for database explorer and Enable filters for intellisense as desired. You can enable/disable all of your filters across all object types for database explorer, intellisense or both by going to the top of the dialog and clicking the Enable/Disable All Filters dropdown and selecting one of the options.

10. If you wish this filter to override any connection filter, then check the Override filter properties checkbox specified at the Connection level.

11. When you are finished, save your work by pressing the Save button.

12. A Filter icon (funnel) will appear next to Filter Types shown on the left side of the Filters dialog if the Filter Type has an enabled filter on it.

13. Icons in Oracle Database Explorer will change to include a small funnel image to indicate that a filter is being applied

14. To permanently delete all filters and start over fresh, click the Delete All Filters button near the top right portion of this filters dialog.