Specify Collection Options

Use this form 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.

When this option is cleared, you can have duplicate entries.

Order By This field specifies the parameters of the ORDERBY keyword, which controls the sorting of the collection.
Group By This field specifies the parameters of the GROUPBY keyword, which controls the grouping of collection items.