Specify Collection Options dialog box

Use this dialog box to set up and maintain specifications for In Collection validators and for IDO Collection list sources.

Field/Option Description
Read Mode This field specifies the isolation level for transactions when loading the collection.

This setting overrides the default value for Collection Read Mode set in the Process Defaults form. The override applies only to this validator or list source.

Filter This field specifies the parameters of the FILTER keyword, which sets query criteria.
Distinct When this option is selected, the DISTINCT keyword is applied to the collection being returned.

Otherwise, clear this check box.

OrderBy This field specifies the parameters of the ORDERBY keyword, which controls the sorting of the collection.