Filtering database objects in the Object List

You can use a filter to limit the number of objects that are displayed in the Object List.

About this task

To reduce the number of objects that display in the views of the workbench, you can specify a database catalog filter, Object List filter, or both.
Tip: If the database catalog filter is enabled, some data objects are not returned from the database catalog. To display all objects in the Object List, you must disable the database catalog filter.

Procedure

To apply an Object List filter, complete the following steps:

  1. Click Graphic of the icon to filter the contents of the Object List. (Filter the contents of the Object List) to open a dialog box so that you can apply a filter to any of the properties that are shown in the Object List columns.
  2. Specify a filter and click OK. You can create multiple conditions that involve any number of properties. You can also choose whether to include objects for which all the conditions are true or any one of the conditions are true. Only one filter can be applied at a time.
    Tip: In addition to using the object list filter, you can apply a quick filter by using the Name Like field. When you use the Name Like field, only the objects with a name that meet your specified criteria are displayed. The Name Like field is not case-sensitive. Use one or more percent (%) characters for a wildcard search character, and use one or more underscore (_) characters to match a single character. For example, the search string S_SIBMINT_RNAL returns SYSIBMINTERNAL as a result.

Results

Turn the filter on and off by clicking Graphic of the icon to turn on and off the filter for the contents of the Object List. (Turn on and off filter for the contents of the Object List).


Feedback