LOV Cross-Validation is a condition which specifies legal relationships between the values in two Lists of Values (LOV) attributes. Setting up the 'LOV Cross-Validation' condition requires setting a defining attribute to which the dependent attribute will be compared.
For example, an LOV attribute is named ‘Shirt Color’ with values ‘Blue,’ ‘Black,’ and ‘Red,’ and another LOV attribute is named ‘Shirt Size’ with values 'M,' ‘L’, ‘XL,’ or ‘XXL.' Based on the availability of different sizes of shirt for a particular color, you can make use of the ‘LOV Cross-Validation’ business condition to specify the relationships between the two LOV attributes like ‘Blue’ > L, XL, ‘Black’ > XXL, ‘M,’ and so on.
Important: It is not recommended to use LOVs with duplicate values in cross-validation in both dependent and defining attributes.
Prerequisites
Before using this business condition:
- Verify the Defining and the Dependent attribute LOVs use IDs as values.
- Verify the Defining and the Dependent attribute LOVs are configured so that users cannot add new values. This enables the user to specify that the value of one LOV attribute limits which values are valid for another LOV attribute.
- Verify the Defining and the Dependent attribute LOVs 'Use IDs on values' option is set to Yes.
- Create a business rule as defined in the Creating a Business Rule, Function, or Library topic here.
- Edit the business rule to configure the operation as defined in Editing a Business Rule or Function topic here.
Configuration
- On the Edit Operation dialog, select LOV Cross-Validation from the dropdown.
- For the 'Defining attribute' field, click the ellipsis button (
) to display the Defining Attributes dialog. Use the Browse or Search tab to identify the defining list of values, select the desired single-valued LOV attribute. Click Select to display this attribute as the Defining attribute.
- For the 'Dependent attribute' field, click the ellipsis button () to display the Dependent Attributes dialog. Use the Browse or Search tab to identify the dependent list of values, select the desired single or multi-valued LOV attribute. Click Select to display this attribute as the Dependent attribute.
- Select an attribute in the 'Defining Attribute' column list on the left, and set the valid dependent attribute values in the 'Dependent attribute' column list on the right.
Note: The number in the parentheses next to each attribute name specifies how many values of the dependent attribute are configured to be valid. This provides an overview of the configuration without clicking through every defining value.
- Select the Save button to save this business condition.
Note: The cross validation functionality will also work in the Web UI when the LOV Cross-Validation business condition has been configured for two editable LOV attributes inside a data container.
Important: If one or more attributes are configured in multiple business conditions, the business conditions that share attributes will not work when applied. For instance, if two LOV Cross-Validation business conditions are set and one attribute is configured in both, the cross validation functionality will not work as expected.
To setup business conditions in the Web UI, refer to the Business Conditions in Web UI topic in the Business Rules documentation here.