Working with relationship filters

The Relationship Filters tab is used to create filters that exclude specific fields from the Relationships tab. The excluded relationships are hidden on the Relationships tab and in the Graphical View. Hiding a relationship from the Graphical View automatically creates a corresponding relationship filter. Filters can be created using the Relationship Filters tab based on:

• ID
• Group ID
• Parent source
• Parent creator/schema
• Parent table/DSN
• Dependent source
• Dependent creator/schema
• Dependent table/DSN
• Name
• Type.

Filters are also used to hide excluded relationships.

To create, enable, disable, or delete a relationship filter

1. Either click the radio button for the desired filter and type your filter criteria in the adjacent field or use the field drop-down list to select an item. If Type is selected, use the field drop-down list to select AR or RI. If Hide excluded relationships is selected, there are no additional criteria to enter. Java regular expressions can also be used in filter fields. For more information, see Entering-Java-regular-expressions-in-filter-fields.
2. Click Add. The specified filter is created and displayed in the Existing filters list. Relationships tab fields matching the filter are excluded from view.
3. To create a filter based on Relationship ID, either right-click the desired relationship line in the Graphical View and select Hide Object, or right-click the desired relationship in the Relationship View and select Hide Relationship. The relationship and its related nodes are hidden, and a relationship filter corresponding to the selected relationship is automatically created and enabled.
4. To disable an existing enabled filter, either double-click it in the Existing filters list, or right-click it and select Disable. To disable multiple filters, Ctrl+click the desired filters, then right-click and select Disable.
5. To enable a disabled filter, either double-click it in the Existing filters list, or right-click it and select Enable. To enable multiple disabled filters, Ctrl+click the desired filters, then right-click and select Enable.
6. To toggle the enabled/disabled status of a filter, right-click the filter in the Existing filters list and select Flip status. To toggle the status of multiple filters, Ctrl+click the desired filters, then right-click and select Flip status.
7. To delete an existing filter, right-click the filter in the Existing filters list and select Delete. To delete multiple filters, Ctrl+click the desired filters, then right-click and select Delete.