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.


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.


To perform this procedure:

To add multiple conditions to a business rule

  1. In Master Data Manager, click System Administration.

  2. From the menu bar, point to Manage and click Business Rules.

  3. On the Business Rules/ page, from the Model drop-down list, select a model.

  4. From the Entity drop-down list, select an entity.

  5. From the Member Types drop-down list, select a type of member.

  6. Click the row for the business rule you want to edit.

  7. Click Edit.

  8. Under the If block, on the left side from the logical operator drop-down list select AND/OR/ NOT.

  9. Click Add. A panel will be displayed.

  10. From the Attribute drop-down list, select an attribute.

  11. From the Operator drop-down list, select a condition.

  12. Complete any required fields.

  13. Click Save. A new row will be added to the If grid.

  14. Optionally, to add more conditions, complete steps 8-13.


    To delete a condition, select the condition and right-click on it and click Delete.


    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)