Filters in the Administration Explorer

Use the database catalog filter in the Administration Explorer to limit the number of objects that are returned from the database catalog.

For databases that contain a large number of objects, you might get improved performance by specifying a database catalog filter. Only the data objects that meet the conditions and match the dependent object types that you specify in the filter are returned from the database catalog. You can also use a view filter in combination with the database catalog filter to further filter the data objects that display in a view.

Specifying a filter

To specify a database catalog filter, right-click an object type folder in the Administration Explorer and select Database Catalog Filter. You can specify a filter for each object type folder.

You must specify conditions and the types of dependent objects to enable a database catalog filter:
Conditions
Specify a predicate and value for each condition. You can include or exclude data objects based on the characters in the name of the object. The values that you specify are case-sensitive.
Dependent objects
Specify the types of dependent objects to return from the database catalog. These objects are returned from the database catalog only if they are dependent on an object that meets the conditions that you specify in the filter.
Remember: To analyze impact and dependency for data objects, you must either include all dependent object types or disable the database catalog filter.
When a filter is set, the following labels and icon appear in the Administration Explorer:
[FILTERED]
Displays in front of the name of the database where you specified the filter.
[Filtered]
Displays after of the filtered folder Filtered folder where you specified the filter.

To disable a filter, you must delete all the conditions in the database catalog filter.

Restriction: Specifying the data object filter in the Data Source Explorer while the database catalog filter is specified in the Administration Explorer is not supported. Only one of these filters can be enabled in the workbench because each filter overrides the other. For example, if you specify the data object filter, the database catalog filter is automatically disabled and all the conditions are deleted.

Setting a threshold limit for the Object List

To improve performance, you can set a threshold for the number of objects to show in the Object List.

You set that threshold in the Preferences dialog box. If you try to open a list of objects from the Administration Explorer and the number of objects to include in the list exceeds the threshold that you set, the workbench will display a filter dialog box before it populates the Object List. You can choose to use the filter to limit the number of objects that are shown or to view the full list of objects.

Depending on the performance of your Object List, you can increase or decrease the limit in the preference to specify when the filter dialog box is automatically opened: Window > Preferences > Data Management > Administration Explorer.


Feedback