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, then the default is set to AND, 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 might want to select cash codes for company 1234 and are in the southeastern region. OR conditions are used to establish multiple sets of criteria that are applied separately. For example, you might want to select cash codes for accounts in Canadian dollars or in US dollars.

If you have multiple conditions in a list, then 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 you can combine attribute and OR group combinations 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 being combined to create this statement: Include all cash codes for company 1234 managed by Jane Doe or for bank entity 888888888.

Attribute	Value range	Or Group	Result	Notes
COMPANY	1234 1234	1
MANAGER	DOE DOE	1	And	Attributes = Not Equal Or Group = Equal
COMPANY	1234 1234	2	Or	Attributes = Not Equal Or Group = Not Equal
BANK ENTITY	888888888 888888888	2	And	Attributes = Not Equal Or Group = Equal