Mapping Architect for Visio Guide

10.4.0
- 10.5.9
- 10.5.8
- 10.5.7
- 10.5.6
- 10.5

Back Next

Including or Excluding Rules

When you create a rule, you can include or exclude ports that conform to a rule. If you include ports, Mapping Architect for Visio creates a link for all the starting ports that conform to the rule. If you create more than one rule in a rule set, Mapping Architect for Visio creates links for the list of starting ports that conform to rules, based on the order of the rules.

You can also create rules to exclude ports from the list. The order in which an exclusion rule appears in a rule set is important. An exclusion rule can exclude ports only from the list of included ports. Therefore, an exclusion rule is valid only when it follows one or more rules that create links for ports. You cannot set up a rule set that contains only an exclusion rule. You cannot create a rule set where the first rule is an exclusion rule.

Based on the example ports in Rule Order, Mapping Architect for Visio creates links for the sample rule sets.

The following table shows how Mapping Architect for Visio evaluates the rules in rule sets that contain exclusion rules:

This rule set...	Creates these links...
All Ports Named:ITEM_DESC (TO) DESCRIPTION Named:PRICE (TO) ITEM_PRICE DataType:decimal EXCLUDE Foreign Key	ITEM_ID links to ITEM_ID ITEM_NAME links to ITEM_NAME ITEM_DESC links to DESCRIPTION PRICE links to PRICE DISCONTINUED_FLAG links to DISCONTINUED_FLAG The All Ports rule creates links for all ports. The Named Port rules for ITEM_DESC and PRICE override the All Ports rule. The Datatype rule overrides the Named Port rule for PRICE. The Exclude Foreign Key rule removes the links for the foreign key ports.
Named:ITEM_DESC (TO) DESCRIPTION Named:PRICE (TO) ITEM_PRICE EXCLUDE Pattern:^ITEM.*$ (TO) $0	PRICE links to ITEM_PRICE The Named Port rules create links for ITEM_DESC and PRICE. However, the Exclude Pattern rule removes the link for ports that start with the string ITEM .
Pattern:^ITEM._.$ (TO) $0_IN EXCLUDE Primary Key Foreign Key	ITEM_NAME links to ITEM_NAME_IN ITEM_DESC links to ITEM_DESC_IN MANUFACTURER_ID links to MANUFACTURER_ID DISTRIBUTOR_ID links to DISTRIBUTOR_ID The Pattern rule creates links for ITEM_ID, ITEM_NAME, and ITEM_DESC. However, the Exclude Primary Key rule removes the link for ITEM_ID. The Foreign Key rule creates links for MANUFACTURER_ID and DISTRIBUTOR_ID.

Rename Saved Search

Table of Contents

Mapping Architect for Visio Guide

Mapping Architect for Visio Guide

Including or Excluding Rules

Including or Excluding Rules