Edit

Business Rule Conditions (Master Data Services)

  • Article

Applies to: SQL Server - Windows only Azure SQL Managed Instance

In Master Data Services, business rule conditions determine the conditions that must be true for one or more actions to be taken.

Note

Conditions are optional. If you do not specify a condition, then actions are taken any time data is validated against business rules.

Business Rule Conditions

Condition Name Description
is equal to The selected attribute is equal to a specific attribute, a specific attribute value, or is blank.

This condition is valid for text, number, date, and link values.
is not equal to The selected attribute is not equal to a specific attribute, a specific attribute value, or is blank.

This condition is valid for text, number, date, and link values.
is greater than The selected attribute is greater than a specific attribute, a specific attribute value, or is blank.

This condition is valid for text, number, and date values.
is greater than or equal to The selected attribute is greater than or equal to a specific attribute, a specific attribute value, or is blank.

This condition is valid for text, number, and date values.
is less than The selected attribute is less than a specific attribute, a specific attribute value, or is blank.

This condition is valid for text, number, and date values.
is less than or equal to The selected attribute is less than or equal to a specific attribute, a specific attribute value, or is blank.

This condition is valid for text, number, and date values.
starts with The selected attribute starts with a specific attribute, a specific attribute value, or is blank.

This condition is valid for text and link values.
does not start with The selected attribute does not start with a specific attribute, a specific attribute value, or is blank.

This condition is valid for text and link values.
ends with The selected attribute ends with a specific attribute, a specific attribute value, or is blank.

This condition is valid for text and link values.
does not end with The selected attribute does not end with a specific attribute, a specific attribute value, or is blank.

This condition is valid for text and link values.
contains The selected attribute contains a specific attribute, a specific attribute value, or is blank.

This condition is valid for text and link values.
does not contain The selected attribute does not contain a specific attribute, a specific attribute value, or is blank.

This condition is valid for text and link values.
contains the pattern The selected attribute contains the pattern of a specific attribute, a specific attribute value, or is blank. Use .NET Framework regular expressions to specify the pattern.

For more information about regular expressions, see Regular Expression Language Elements in the MSDN Library.

This condition is valid for text and link values.
does not contain the pattern The selected attribute does not contain the pattern of a specific attribute, a specific attribute value, or is blank. Use .NET Framework regular expressions to specify the pattern.

For more information about regular expressions, see Regular Expression Language Elements in the MSDN Library.

This condition is valid for text and link values.
contains the subset The selected attribute contains the subset of a specific attribute or a specific attribute value. You must specify the starting position for the search (for example, 1 means start searching at the first character).

This condition is valid for text and link values.
does not contain the subset The selected attribute does not contain the subset of a specific attribute or a specific attribute value. You must specify the starting position for the search (for example, 1 means start searching at the first character).

This condition is valid for text and link values.
has changed The selected attribute has changed since the last time business rules were applied to the member. You must specify the change group the attribute is a member of.

For more information on change tracking groups, see Add Attributes to a Change Tracking Group (Master Data Services).

This condition is valid for text, number, date, and link values.
has not changed The selected attribute has not changed since the last time business rules were applied to the member. You must specify the change group the attribute is a member of.

For more information on change tracking groups, see Add Attributes to a Change Tracking Group (Master Data Services).

This condition is valid for text, number, date, and link values.
is between The selected attribute is between two specific attribute values.

This condition is valid for text, number, and date values.
is not between The selected attribute is not between two specific attribute values.

This condition is valid for text, number, and date values.

Note

When a business rule contains a condition that compares two values, and the rule is applied to a member for which both values are NULL, that member will fail validation.

See Also

Business Rule Actions (Master Data Services)
Business Rules (Master Data Services)
Create and Publish a Business Rule (Master Data Services)