Note
Access to this page requires authorization. You can try signing in or changing directories.
Access to this page requires authorization. You can try changing directories.
Applies to: 
SQL Server - Windows only
Azure SQL Managed Instance
Important
Master Data Services (MDS) is removed in SQL Server 2025 (17.x) Preview. We continue to support MDS in SQL Server 2022 (16.x) and earlier versions.
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)