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. |
GroupBy | This field specifies the parameters of the GROUPBY keyword, which specifies the groups into which collection rows are to be placed. |