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.
Guidelines for basic rule associations
Consider the following guidelines when you define basic rule associations:
•When you configure a basic rule association for a field that uses a reference data field, the rule uses the code field of the referenced code value.
•When you import code values in to a code list, date fields that you might use in a concatenate rule for the Code attribute must be in the DD-MM-YYYY format.
•After you configure a basic rule association with a transformation function for the code field, if you import code values, calculate the rule execution result and provide values for the code field. Ensure that the values you provide don't mismatch with the values the rule generates.
•Basic rule associations with external validation functions validate the code values that you add or update through the user interface and REST API.
Add basic rule associations
You can add basic rule associations for code list attributes. When users add or edit code values in a code list that does not meet the business standards, they receive inline validation errors.
1Open a code list.
2Click Definition.
The Definition tab opens.
3In the Attributes section, select the attribute to add a rule.
The Attribute Details panel displays the details of the attribute on the Details tab.
4On the Basic Rules tab, click the Add icon.
A form appears.
5In the General section, enter a unique name for the rule association.
6Optionally, enter a description.
7On the Condition tab, perform the following tasks:
aSelect a function.
bFor the input field, select an option from the list.
cIf you select Select a Field, select an attribute from the list.
dIf you select Enter a Value, type a value for validation.
8If you select a validation function, on the Validation tab, enter an error message or use the default validation message to display when the validation fails.
9To verify the created rule, perform the following tasks:
aClick Test.
The Test dialog box appears.
bEnter values in the Input column, and click Run.
The validation result appears in the Output column.
cClick Reset to reset the values in the Input and Output columns.
dClick Close.
10Click Save.
Changing the execution order of basic rule associations
When you have multiple basic rule associations for an attribute, set their order of execution to obtain clean and correct data.
1On the Rules tab, click Change Order.
The Change Order dialog box appears.
2Use the up and down arrows to change the order of the rule associations.
3Click OK.
The list of rule associations with the updated order of execution appears.