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:
- Click the
(Filter
the contents of the Object List) icon 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.
- 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 Object Name
Search field. When you use the Object Name
Search field, only the objects with a name that meet your
specified criteria are displayed. The Object Name
Search 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 the
(Turn on and off filter for the contents
of the Object List) icon.