Validating Records 

MDM validations are MDM expressions that return a Boolean success or failure result.

Using MDM validations, you can define complex tests for all types of conditions, and then run those tests against a group of one or more records, all without using a query language.

You can also assign each validation to one or more validation groups. Each validation group is a set of validations that can be conveniently executed as a group with a single selection rather than forcing you to run each individual validation separately.

Validation expressions can be used to perform all sorts of tests that implement sophisticated business logic that goes far beyond simple data integrity checks, including:

●      Making sure required fields and other fields that are required when another field has a particular value all have a non-NULL value.

●      Making sure non-lookup fields that do not have pick lists to enforce data integrity have a legal value (for example Price > 0).

●      Comparing the values of different fields to make sure the relative values are legal (for example Price > Cost).