Event Action Load Collection

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

Use this form to construct an application 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 Collection action type is to see the properties retrieved, so a Load Collection action is generally followed by one or more PROPERTY() or FILTERPROPERTY() expressions.

If you do not know ahead of time how many rows will be retrieved based on the FILTER(), a ROWS() expression is required. 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.

So instruct the event action to return only unique property combinations, select Distinct.

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