3.2 Using Filters

Filters enable you to control the objects that appear in the Connections navigator display. The filter can be applied on the following:

• Schema (Connection Tree Node or User Tree Node )
• Object Type (Table,View, Procedure and so on)

To access the Filter pane, right-click a connection node or an object type node (such as Tables) in the Connections navigator and select Apply Filter. Use the pane to limit the number of objects of that type that are displayed, according to one or more filter criteria that you specify. For each criterion, specify the following:

• Name (list always includes NAME, other criteria depend on the object type)

• Operator (for example, LIKE)

• Value for comparison (for example EM%)

• Case-sensitive option for character data comparison

For example, to display only tables with names that start with EM, specify NAME, LIKE, and EM% (with the percent sign as a wildcard character).

The following attributes are applicable for object type filters.

Ignore Schema Filter (object type node filters): If this option is checked, any filter criterion specified at the connection level is ignored. Only the object type node filter criteria are applied.

Include Synonym (object type node filters): If this option is checked, synonyms for objects of this object type are included.

To add another filter criterion, click the Add (+) icon. To delete a criterion, select it and click the Delete (X) icon. To move a criterion up or down in the list, select it and use the arrow icons.

To apply the filter criteria to the Connections navigator display, click OK.

To remove the effects of applying a filter, right-click the object type node in the Connections navigator display and select Clear Filter.