Business Rule Conditions

Business Rule Conditions (Master Data Services)

 

Applies To: SQL Server 2016

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

System_CAPS_ICON_note.jpg Note


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

Condition NameDescription
is equal toThe 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 toThe 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 thanThe 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 toThe 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 thanThe 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 toThe 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 withThe 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 withThe 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 withThe 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 withThe 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.
containsThe selected attribute contains a specific attribute, a specific attribute value, or is blank.

This condition is valid for text and link values.
does not containThe 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 patternThe 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 patternThe 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 subsetThe 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 subsetThe 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 changedThe 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 changedThe 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 betweenThe selected attribute is between two specific attribute values.

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

This condition is valid for text, number, and date values.
System_CAPS_ICON_note.jpg 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.

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

Community Additions

ADD
Show:
© 2016 Microsoft