Event Action Load Collection

Note:  You can access this form only from the Event Actions form.

Use this form to construct an event action that loads a specified collection associated with an IDO. You can use various options on this form to limit the amount of data returned by this event action.

The data retrieved by this action is held in a "result set", which you must then refer to for further action.

The primary goal of the Load IDO Collection action type is to see the properties retrieved, so a Load IDO Collection action is generally followed by one or more PROPERTY() or FILTERPROPERTY() expressions.

A ROWS() expression is necessary when you do not know ahead of time how many rows will be retrieved based on the FILTER(). In this case, you use it to limit the values passed into PROPERTY() and FILTERPROPERTY() for the row number argument. This is especially useful when you have executed multiple Load IDO Collection actions and must keep their results separate.

Select Distinct so that the event action returns unique property combinations only.

Note: The Load Collection action type is similar to the Dispatch Load Collection action type. The primary difference is that the Load Collection action type executes the Load Collection request on the system from which it is initiated; the Dispatch Load Collection executes the Load Collection request on a remote system.