Add Multiple Conditions to a Business Rule (Master Data Services)
Applies to: 
SQL Server - Windows only
Azure SQL Managed Instance
In Master Data Services, add multiple AND or OR conditions to a business rule when you want a more complex rule.
Note
If you create a business rule that uses the OR operator, consider creating a separate rule for each conditional statement that can be evaluated independently. You can then exclude rules as needed, providing more flexibility and easier troubleshooting.
Prerequisites
To perform this procedure:
You must have permission to access the System Administration functional area.
You must be a model administrator. For more information, see Administrators (Master Data Services).
A business rule must exist. For more information, see Create and Publish a Business Rule (Master Data Services).
To add multiple conditions to a business rule
In Master Data Manager, click System Administration.
From the menu bar, point to Manage and click Business Rules.
On the Business Rules/ page, from the Model drop-down list, select a model.
From the Entity drop-down list, select an entity.
From the Member Types drop-down list, select a type of member.
Click the row for the business rule you want to edit.
Click Edit.
Under the If block, on the left side from the logical operator drop-down list select AND/OR/ NOT.
Click Add. A panel will be displayed.
From the Attribute drop-down list, select an attribute.
From the Operator drop-down list, select a condition.
Complete any required fields.
Click Save. A new row will be added to the If grid.
Optionally, to add more conditions, complete steps 8-13.
Tip
To delete a condition, select the condition and right-click on it and click Delete.
Tip
You can select multiple conditions and right-click to group them inside a logical operator, or to ungroup conditions inside a specific logical operator.
See Also
Business Rules (Master Data Services)
Change a Business Rule Name (Master Data Services)
Configure Business Rules to Send Notifications (Master Data Services)