Data Validation Rules

WATCH THE VIDEO

Microsoft Dynamics AX administrators can manage data validation directly in Microsoft Dynamics AX.

Use the Data validation rules form to manage validation rules of the appropriate tables and related fields. This form can be used to configure validation rules which affect data retrieving. For instance, you can configure validation rules which define if a product is orderable or a customer is allowed to order. Only data which satisfies the selected criteria can be processed.

To open the Data validation rules form, in Microsoft Dynamics AX click: Webshop > Setup > Data validation rules.


To add a data validation rule, create a new record in the Data validation rules form.

The table below provides the description of the fields.

Field

Description

Table ID

The table for which the data validation rules should be set. All existing in the database tables are available.

Table name

The table name which is selected in the Table ID dropdown.

Modified by

NOTE

Applies to
: Sana Commerce Cloud 10.0.70 and higher in Microsoft Dynamics AX.

Use these fields to see who and when changed a certain rule. If a data validation rule has been changed and it affects some functionality or operation of the webstore, you can check when and by whom this change was made.

Modified date and time

Active

Use this checkbox to enable / disable data validation rules of the related table.

Field ID

The related table field for which the data validation rule should be set. All fields of the related table are available.

Field name

The field name which is selected in the Field ID dropdown.

Criteria operator

An operator that indicates a specific data validation expression.
The combination of criteria operator and value defines the validation rule for the related table field.

Value

The available filed values.

Error message

The error message of the related validation rule which will be shown if some data does not pass validation.

The error messages are predefined but it is possible to overwrite them.

The following error messages are also used to show the non-orderable reason of a product in the Webshop catalog overview form.

NOTE

There is the Custom function criteria operator. Using this criteria operator you can create more complex data validation rules.

The lookup values for Custom function are formed from the current table methods with the correct signature and prefix VR_.

Use Defaults for the current table or Reset all to defaults for all tables to restore the default data validation rules.