Export (0) Print
Expand All
This topic has not yet been rated - Rate this topic

Business Rule Conditions (Master Data Services)

SQL Server 2012

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

Note Note

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

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.

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.

contains

The selected attribute contains 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.

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.

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.

is between

The selected attribute is between two specific attribute values.

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

Note 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.

Did you find this helpful?
(1500 characters remaining)
Thank you for your feedback

Community Additions

ADD
Show:
© 2014 Microsoft. All rights reserved.