In Collection validators

In Collection validators determine whether a component's value exists as the value of a property in the IDO that returns the specified collection. Both the IDO name and the property to be matched must be specified as part of the validator definition. Optionally, you can specify a filter to apply to the IDO before the match is attempted. In Collection validators can also output any property of the matched IDO to a variable, property, or component.

In rare cases, you might want to specify a custom load method for querying the IDO. Custom load methods must be defined in an IDO, as methods that return lists of values. If you specify a load method, you might also need to specify the parameters required by this method.

Note: When validating a collection using an IDO property or property class, the existing Domain IDO Collection and Domain IDO Property parameters are used for the In Collection validation.

These parameters are supported for validator output:


Output Parameter	Description
No List Cache	Force the validator to process whether or not its current value was selected from a list. See additional information about this option at the end of this topic.
Output First Time Only	The output is generated only the first time that the validator is fired after the collection was loaded, was saved, or became current. Use this parameter when you want to prevent subsequent executions of the validator from overwriting changes made to the target component by the user.
Output Immediate Only	The output is generated only for immediate validations. Use this parameter when you do not want the validator to change a component at the time the collection is saved or navigated.
Mark Output Targets Validated	This attribute prevents output target components from re-validating unless the user modifies the value of the component. When the validation requires a round trip to the server, use this parameter to improve performance.
Set Property / Variable / Component	Output any property of the matched IDO to a variable, property, or component. Specify the property name of the matched IDO as the source, and specify the variable, property, or component name as the target.
Property	The name of the IDO property which must contain the current component's contents in order to be considered valid. For example, for a customer order validator using the IDO Customer, this field is the name of the customer number IDO property. At runtime, Mongoose generates a load collection through the IDO, constructing a WHERE clause consisting of the property specified here plus the current component's value. For example: CustomerNumber = '1234'.
Filter Etc.	Optional. This parameter specifies a filter expression to apply when validating the domain property.
Exception Text is Back End Msg	This parameter causes exception messages to be displayed as if they are back-end error messages, which can be displayed in the error message string, using the %B substitution keyword.

By default, In Collection validators bypass validating data selected from a list box, drop-down list, or combo box. The assumption is that the list represents a list of valid values. In this case, the component's list source must also contain the properties needed to provide the validator's output values. The validator's output values are taken from the list cache instead of the validator's collection.

This default behavior is important because it eliminates round trips to the server. However, you can force the validator to process whether or not its current value was selected from a list by specifying the No List Cache attribute.