Book Image

Microsoft SQL Server 2008 R2 Master Data Services

Book Image

Microsoft SQL Server 2008 R2 Master Data Services

Overview of this book

Table of Contents (18 chapters)
Microsoft SQL Server 2008 R2 Master Data Services
Credits
Foreword
About the Authors
About the Reviewers
www.PacktPub.com
Preface
Index

Conditions and actions


As mentioned, the conditions and actions are the components that make up MDS business rules. We will now cover the conditions and actions that are available in MDS, before we encounter them when creating our own business rules.

Conditions

There are a variety of different conditions in MDS, as different businesses will need rules to be triggered in different ways. While the conditions are a key part of the business rules, they are actually optional. If a condition is omitted, this will effectively create a business rule with an action that is executed every time the business rules are run.

The full list of conditions supported by MDS is shown below:

Condition

Description

Is equal to

Checks if an attribute is equal to a given value, another attribute, or blank.

Is not equal to

Checks if an attribute is not equal to a given value, another attribute, or blank.

Is greater than

Checks if an attribute is greater than a given value, another attribute, or blank.

Is...