Order By

Use this field to specify an expression that resolves to the name of a valid property of the selected IDO, or a comma-separared list of valid properties, to be used for the sort order on the collection when it is loaded and displayed. For example, if you select CreateDate as the property for this field, the system sorts the collection according to the dates on which transactions were recorded.

Note: This parameter is not valid with custom load methods.

To use the Event Action Parameter Properties form to select the property from a list of properties associated with the selected IDO, click the button to the left of this field.

The contents of this field must be a literal value or expression that resolves to this syntax:

property1 [ ASC | DESC ] [, property2 [ ASC | DESC ] ] ...

where property# is the name of a property to be used as the basis for the sort order. If more than one property is specified, the properties must be presented as a comma-delimited list. "ASC" following a property signifies ascending sorting is to be used on that property, while "DESC" signifies descending sorting.

The system prioritizes multiple properties in the order in which they are listed. In other words, property1 would be the primary property for sorting; property2 the secondary property for sorting; and so on.

When you click OK to return to the Event Actions form, the system "wraps" this content within an ORDERBY( ) parameter, which yields the following final syntax if a literal value was entered (or selected from the Event Action Parameter Properties form):

ORDERBY( "property1 [ ASC | DESC ] [, property2 [ ASC | DESC ] ] ... ")

Note: If a literal value was entered, the system automatically encloses it in double quotation marks when returning it to the Event Actions form. If an expression was entered, the system does not enclose it in quotation marks.