Edit Validators, In Collection Validator page

When you select the In IDO Collection option and then click Next, 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 Add, 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.