Edit Validators, In Collection Validator page
When you select the option and then click , the In Collection Validator page displays. Use this page to select the IDO and IDO property that are to be set on a successful validation.
On this page, use the grid to provide these specifications:
- IDO Name
- Select the IDO that contains the property to be validated.
- Property Name
- Select the property that you want to validate from the IDO collection named in the IDO Name field.
- Filter
- Optionally, specify a filter to be used during validation.
This filter eventually becomes the WHERE clause for the query that returns the valid values.
For example, suppose you have an IDO named Orders and it has OrderNumber and OrderStatus properties. You want to make an In Collection validator that will check to see if an OrderNumber exists AND if the OrderStatus is OPEN.
If you specify the IDO name (Orders) and the IDO property (OrderNumber), that is sufficient to determine whether the order number is valid. However, to figure out whether the status is OPEN, you would need a filter to restrict the set of all valid OrderNumbers to just those whose status is OPEN. In that case, you would use a filter like this: OrderStatus = 'OPEN'
- Target Property
- After clicking , select the
property to which the new value is to be assigned if the validation is successful.
Optionally, select any additional properties to be set if the validation is successful.
- Source Property
- Select the property from the IDO being used for validation that contains data to be copied into the target property.
Optionally, select an error message to be displayed if the validation fails. You can use any valid application message or create your own.