ascending( )

Adds a sort to an aggregation, sorting by the items or groups by the specified properties in ascending order.

The ascending() function refines a WixDataAggregate to sort the resulting items or groups in ascending order. If you specify more than one property, ascending() sorts the results in ascending order by each property in the order they are listed.

You can sort the following types:

• Number: Sorts numerically.
• Date: Sorts by date and time.
• String: Sorts lexicographically, so "abc" comes after "XYZ".
• Reference: Compares by the ID of the referenced item as a String.

If a property contains a number as a String, that value will be sorted alphabetically and not numerically. Items that do not have a value for the specified sort property are ranked lowest.