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" defaults, which connects two statements with an "and" condition. You can type 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 might want to select customers based in California and have balances of 50,000 or greater. "Or" conditions are used to establish multiple sets of criteria that are applied separately. For example, you might want to select customers that have credit analyst 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. The following table shows how attribute and "or" group combinations can be 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

The next table shows an example of attributes and or groups being combined to create the following statement: "Include all California-based customers that have credit analyst Smith or with balances of 50,000 or more."

Attribute Value Range Or Group Result Notes
STATE

CA

CA

1
CR ANALYST

SMITH

SMITH

2 And

Attributes = Not Equal

Or Group = Equal

STATE

CA

CA

2 Or

Attributes = Not Equal

Or Group = Not Equal

STATIC AGING 4

50,000

50,000

1 And

Attributes = Not Equal

Or Group = Equal