Reference 360

Back Next

Basic rule associations

You can use a basic rule association to validate or transform the attribute values based on the selected predefined function. A validation function validates whether data matches the specified condition. For example, you can set a maximum length condition for a field value. A transformation function transforms data. For example, the uppercase function converts lowercase values to uppercase.

You can group the predefined functions into the following categories:

Validation. Validates whether data matches the specified condition. When you use a validation function, you must configure a validation message or use the default validation message.

Transformation. Transforms data.

The following table lists the rules that you can configure for each attribute type:

Attribute Type	Rules and Descriptions
String	Maximum Length - Validates whether the length of a string is less than or equal to the specified length. Minimum Length - Validates whether the length of a string is greater than or equal to the specified length. Starts With - Validates whether a string starts with the specified string. Ends With - Validates whether a string ends with the specified string. No Spaces - Validates whether a string does not contain spaces. Contains - Validates whether a value contains the specified string in the exact order. Does Not Contain - Validates whether a value does not contain the specified string in the exact order. Allowed Characters - Validates whether a value contains the specified allowed characters. Not Allowed Characters - Validates whether a value contains the specified characters that are not allowed. Regular Match - Validates whether a string matches with the specified regular expression pattern. External Validation - Validates the field data based on an external validation rule that is associated to a Cloud Application Integration process. The Cloud Application Integration process uses external APIs to validate the data. Concatenate - Concatenates two or more strings. Concatenate With Spaces - Concatenates two or more strings with spaces in between. Uppercase - Converts lowercase string characters to uppercase. Lowercase - Converts uppercase string characters to lowercase. Title Case - Capitalizes the first character in each word of a string and converts all other characters to lowercase. Left Trim - Removes spaces from the beginning of a string. Right Trim - Removes spaces at the end of a string. Replace - Replaces a character set in a string with another character set.
Decimal	Minimum Value - Validates whether a numerical value is greater than or equal to the specified value. Maximum Value - Validates whether a numerical value is less than or equal to the specified value. Maximum Decimal Scale - Validates whether the number of decimal places is less than or equal to the specified value. Maximum Precision - Validates whether the total number of digits in a decimal number is less than or equal to the specified value.
Integer	Minimum Value - Validates whether a numerical value is greater than or equal to the specified value. Maximum Value - Validates whether a numerical value is less than or equal to the specified value. Maximum Precision - Validates whether the total number of digits in a decimal number is less than or equal to the specified value.
Date	Date Range - Validates whether a date is in between two specified dates. Greater Than Date - Validates whether a date is greater than the specified date. Less Than Date - Validates whether a date is less than the specified date. No Future Date - Validates whether a date is not a future date.