Or group logic tables

Use the Or Group field on List (MX10.1) to create an AND/OR condition between attributes. This determines if the attributes are grouped or treated individually. If you leave this field blank, AND is the default setting, which connects two statements with an AND condition. You can specify any alphanumeric character in the field to create an OR condition.

You can include combinations of AND and OR conditions. AND conditions link value ranges together as one condition. For example, you can select activities for new store projects that are in the Central region and are larger than 20,000 square feet. OR conditions are used to establish multiple sets of criteria that are applied separately. For example, you can select activities that are managed by Johnson or Smith.

If you have multiple conditions in a list, use an OR in the Or Group field to separate the conditions. Selection criteria above or below an OR condition are applied separately. This table shows how attribute and OR group combinations are combined to create conditional statements.

If the attribute on the preceding or subsequent line is	And the OR group on the preceding or subsequent line is	Result
EQUAL	EQUAL	Not valid
EQUAL	NOT EQUAL	Or condition
NOT EQUAL	EQUAL	And condition
NOT EQUAL	NOT EQUAL	Or condition

This table shows an example of attributes and or groups are combined to create this statement: "Include all projects for Moose Wood Outfitter's New Store activity group that were opened in 2005 or that were remodeled in 2005."

Attribute	Value range	Or group	Result	Notes
Activity Group	MWO-Stores MWO-Stores	1
Date Opened	01/01/2005 12/31/2005	1	And	Attributes = Not Equal Or Group = Equal
Activity Group	MWO-Stores MWO-Stores	2	Or	Attributes = Not Equal Or Group = Not Equal
Date Remodeled	01/01/2005 12/31/2005	2	And	Attributes = Not Equal Or Group = Equal