Business Rule Actions (Master Data Services)
Applies to: 
SQL Server - Windows only
Azure SQL Managed Instance
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
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
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
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
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. NOTE: If the first attribute is of type DateTime, then it cannot be used in combination with an attribute of type Numeric or Text attribute. If the first attribute is of type Numeric, then it cannot be used in combination with an attribute of type DateTime. |
| 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 Action
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. |
See Also
Business Rule Conditions (Master Data Services)
Business Rules (Master Data Services)
Create and Publish a Business Rule (Master Data Services)
Feedback
Coming soon: Throughout 2024 we will be phasing out GitHub Issues as the feedback mechanism for content and replacing it with a new feedback system. For more information see: https://aka.ms/ContentUserFeedback.
Submit and view feedback for