Set up validation rules

Release notes

Use validation rules to check if the data is in line with the defined standards.

To validate data, you can use these validation types:

Mandatory: Makes it mandatory to fill a field.
Blank: Validates if no value is entered in a field.
Range expression: Validates if a field value is within a defined range.
Data pattern: Validates if a field value matches a data pattern.
Web service: Validates if a field value matches a value in another internal or external source, using a web service.
Configurable lookup: Adds a custom lookup to a field and validates if the field value matches a value as defined by the configurable lookup.
Custom: Validates a field value using a custom validation class.

Activities

Name	Responsible	Description
Set up validation rule of type Mandatory or Blank	Data quality administrator	Use validation rules to check if the data is in line with the defined standards. To validate data, you can use several validation types. This topic explains how to set up validation rules of these types: Mandatory: Makes it mandatory to fill the defined field. Blank: Validates if no value is entered in a field. For each validation rule, you can set up: A validation message that is shown if the validation rule is not met. Conditions to define the data to which the rule applies.
Set up validation rule of type Range expression	Data quality administrator	Use validation rules to check if the data is in line with the defined standards. To validate data, you can use several validation types. This topic explains how to set up a validation rule of type Range expression. Use a range expression validation rule to validate if a field value is within a defined range. To define a range expression, you can use a: Fixed value or a range of values using the advanced query syntax. Static method that defines the range. For example, you can use the SysQueryRangeUtil class to apply advanced date queries. For each validation rule, you can set up: A validation message that is shown if the validation rule is not met. Conditions to define the data to which the rule applies.
Set up validation rule of type Data pattern	Data quality administrator	Use validation rules to check if the data is in line with the defined standards. To validate data, you can use several validation types. This flow explains how to set up the Data pattern validation type. Use a data pattern validation to validate if a field value matches a defined pattern. Before you can set up a data pattern validation rule, set up the data pattern to be applied. For each validation rule, you can set up: A validation message that is shown if the validation rule is not met. Conditions to define the data to which the rule applies.
Set up validation rule of type Web service	Data quality administrator	Use validation rules to check if the data is in line with the defined standards. To validate data, you can use several validation types. This topic explains how to set up the Web service validation type. Use a web service validation to validate if a field value matches a value in another internal or external source, using a web service. Before you can set up a web service validation rule, set up the web service to be used. For each validation rule, you can set up: A validation message that is shown if the validation rule is not met. Conditions to define the data to which the rule applies.
Set up validation rule of type Configurable lookup	Data quality administrator	Use validation rules to check if the data is in line with the defined standards. To validate data, you can use several validation types. This topic explains how to set up the Configurable lookup validation type. Use a configurable lookup validation to add a custom lookup to a field and to validate if the field value matches a value as defined by the configurable lookup. Note: If the field, to which the configurable lookup is applied, already has a lookup, the configurable lookup overwrites the existing lookup. Before you can set up a configurable lookup validation rule, set up the configurable lookup to be used. For each validation rule, you can set up: A validation message that is shown if the validation rule is not met. Conditions to define the data to which the rule applies. For example, you can apply a configurable lookup based on the value of another field. So, depending on the value entered for the other field, a different configurable lookup is shown. To do so, set up a separate validation rule for each condition.
Set up validation rule of type Custom	Data quality administrator	Use validation rules to check if the data is in line with the defined standards. To validate data, you can use several validation types. This topic explains how to set up the Custom validation type. Use a custom validation to validate a field value using a custom validation class. Before you can set up a custom validation rule, ensure that the custom validation class is developed. For each validation rule, you can set up: A validation message that is shown if the validation rule is not met. Conditions to define the data to which the rule applies.

Set up validation rule of type Mandatory or Blank

Set up validation rule of type Range expression

Set up validation rule of type Data pattern

Set up validation rule of type Web service

Set up validation rule of type Configurable lookup

Set up validation rule of type Custom

Set up validation rule conditions

Provide feedback