R33860 PropertyValue - Property Value Validity
| Name | Value |
|---|---|
| Code | R33860 |
| Entity | General.PropertyValues Entity |
| Name | PropertyValueValidity |
| Attribute | PropertyValueField |
| Layer | Back-End |
| Events | Commit |
| Priority | Normal |
| Modify | NO |
| Action | if (PropertyValue.PropertyValueField != NULL) && PropertyValue.Property.LimitToAllowedValues == TRUE) { rootProperty = PropertyValue.Property.AllowedValuesRootProperty if (PropertyValue.Property.AllowedValuesEntityName == NULL) { allowedValues = PropertyValue.Property.GetAllowedValues(rootProperty) Validate that allowedValues contains PropertyValue.PropertyValueField } else if (PropertyValue.Property.AllowedValuesFilterXML != NULL) { Get list of all CustomPropertyAllowedValues matching the filter PropertyValue.Property.AllowedValuesFilterXML and validate that the list contains PropertyValue.PropertyValueField } } |
| Description | For each row added or edited and LimitToAllowedValues field of the Property is TRUE, validate that: - if the field AllowedValuesEntityName of the Property is NULL, then allowed values of the Property's root property should contain PropertyValue.PropertyValueField - otherwise (AllowedValuesEntityName != NULL) if the field Property.AllowedValuesFilterXML is not NULL, then PropertyValue.PropertyValueField should be among CustomPropertyAllowedValues that match the filter. |
| Message | '{PropertyValue.PropertyValueField}' is not a valid value for custom property {PropertyValue.Property.Name} for row in table '{PropertyValue.Property.EntityName}'. The value is checked because it is marked that the custom property is limited to the allowed values. Enter valid value and try again. |
| Version | Introduced: 2023 |
| Revocable | NO |
* For more information about the Business Rules Documentation Template and a short explanation of each column, see topic System Business Rules.