Order By
For example, if you select CreateDate as the property for this field, the application sorts the collection according to the dates on which transactions were recorded.
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 application 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 Event Actions form, the application "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):
to return to theORDERBY( "property1 [ ASC | DESC
] [, property2 [ ASC | DESC ] ] ... ")