Configuring filters

Overview

You can configure custom filters to filter database objects in the Database Navigator and Database Object Editor.

Set filters

To configure a custom filter:

1. Open the filter settings:

   • In the Database Navigator: right-click the object, then click Filter -> Configure [objects] filter in the context menu.
   • In the Database Object Editor:
   • in the bottom toolbar of the Properties tab, click the Filter settings button ()
   • Alternatively, right-click the content area, and click Filter -> Configure [objects] filter in the context menu.

   The Filtering window opens:

   

2. Select the Enable checkbox to activate the fields of the window.

3. If you want the filter to apply to all objects of a certain type (for example, all schemas), click Show global filter. Otherwise, the filter will apply only to the current object.

   Note

   After applying a global filter, you can’t switch back to a local filter in the same window. To create a local filter, reopen the Filtering window (see step 1).

4. To include or exclude objects, click Add next to the Include or Exclude field, then enter the name or pattern in the field.

   Info

   You can use wildcard characters:

   • % for any number of characters.
   • _ for a single character.
   • * may work in some systems too (check your DB’s documentation).

5. To remove one filter value, select it and click Remove. To remove all values, click Clear next to the field.

6. To save the filter for reuse, enter its name in the Name field in the Saved filter area, then click Save. To delete a saved filter, open the Name drop-down, select the filter, and click Remove.

7. Click OK to apply the filter, or Cancel to discard the changes.