Use the Filter notebook to define a set of criteria for displaying a list
of objects in the Control Center. You can limit the number of objects
that are displayed by creating filters for one or more objects. Once
you set the filter for an object, you must explicitly clear the filter to
display all elements in an object, or all objects in the tree. The
Control Center will display only those objects meeting the specified filter
criteria.
When you use a filter, the Control Center searches the database looking for
a particular type of database object requested by the user and matching the
user's filter criteria. The result of the search can return from 0
to all the objects of that type.
Fields and controls
Authorities and privileges
To define a filter:
- Open the Filter notebook.
- On the Locate page, specify the name of the object in the Control Center
that you want to filter.
- Specify a set of filter criteria that are active during the life of this
object until explicitly modified or cleared. The result of your filter
is the current list of objects in the contents pane of the control
center.
- Use the Column, Comparison, and Values fields to specify criteria for up to
five different catalog columns.
- On the Locate page select a radio button to specify whether to meet all the conditions selected in the
fields on the Locate page, or meet at least one
of the conditions.
- Optional. On the Locate page click Clear to clear the filter that you defined.
- Optional. Customize your filter. Select the Advanced tab to
change the WHERE clause generated
from your choices on the Locate page. You can derive your own WHERE
clause, or add more predicate columns to the existing clause.
- Optional. On the Advanced page click Reset to reset the filter criteria to the
values defined on the Locate page.
- Click OK to use the filter criteria that you
defined. The result of filtering is a subset of the list of objects
that can be displayed and an updated folder icon
.
Related information