Export (0) Print
Expand All
0 out of 1 rated this helpful - Rate this topic

Business Rule Actions (Master Data Services)

SQL Server 2012

In Master Data Services, business rule actions are the consequence of business rule condition evaluations. If a condition is true, the action is initiated.

Note Note

For default value and change value actions, if the generated value exceeds the maximum length of the attribute, the generated value is truncated.

Default value actions set the default value of a specified attribute. Users with permission can change these default values.

Value Name

Description

defaults to

The selected attribute defaults to a specific attribute, a specific attribute value, or is blank.

This action is valid for text, number, date, and link values.

defaults to a generated value

The selected attribute defaults to a generated value that is determined by entering a starting and incremental value.

This action is valid for text and number values.

defaults to a concatenated value

The selected attribute defaults to a concatenated value that is determined by specifying multiple attributes.

This action is valid for text and link values.

Change value actions update the value of a specified attribute or attribute value. Users can change these values only if the new value causes the action to be true.

Value Name

Description

Equals

The selected attribute is changed to a defined attribute value, another attribute, or blank.

This action is valid for text, number, date, and link values.

equals a concatenated value

The selected attribute is changed to a concatenated value, which is determined by specifying multiple attributes.

This action is valid for text and link values.

Validation actions, when they do not evaluate to true, send email to a specified user or group. To commit a version, all validation actions must evaluate to true.

The only exceptions are the is mandatory and is not valid actions. These actions must be combined with a change value action, so that the data can successfully be validated and the version committed.

Validation Name

Description

is required

The selected attribute is required, which means it cannot be null or blank.

This action is valid for text, number, date, and link values.

is not valid

The selected attribute is not valid.

This action is valid for text, number, date, and link values.

must contain the pattern

The selected attribute must contain the pattern that is specified. 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 action is valid for text and link values.

must be unique

The selected attribute must be unique independently or in combination with defined attributes.

Best Practice: Combine this action with a mandatory condition to ensure validity of index fields in subscribing systems.

This action is valid for text, number, date, and link values.

must have one of the following values

The selected attribute must have one of the values specified in a list.

This action is valid for text values.

must be greater than

The selected attribute must be greater than a specific attribute, a specific attribute value, or blank.

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

must be equal to

The selected attribute must be equal to a defined attribute value, another attribute, or blank.

This action is valid for text, number, date, and link values.

must be greater than or equal to

The selected attribute must be greater than or equal to a specific attribute, a specific attribute value, or blank.

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

must be less than

The selected attribute must be less than a specific attribute, a specific attribute value, or blank.

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

must be less than or equal to

The selected attribute must be less than or equal to a specific attribute, a specific attribute value, or blank.

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

must be between

The selected attribute must be between two specific attribute or attribute values.

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

must have a minimum length of

The selected attribute must have a minimum length of the specified value.

This action is valid for text and link values.

must have a maximum length of

The selected attribute must have a maximum length of the specified value.

This action is valid for text and link values.

External actions interact with applications outside of Master Data Services.

Action Name

Description

start workflow

Initiates an external workflow. The data that caused this action to occur is passed to the workflow. For more information, see SharePoint Workflow Integration with Master Data Services.

This action is valid for text, number, date, and link values.

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

Community Additions

ADD
Show:
© 2014 Microsoft. All rights reserved.