How Flow Designer sorts data
Flow Designer applies the ASCII standard to sort fields, strings, and characters into ascending and descending order.
Ascending order
The smallest or first or earliest items appear at the top of the list.
- Numbers or amounts: Sorts smallest to largest; lower numbers or amounts are at the top of the list.
- Letters or strings: From A to Z
- Combination strings, such as address lines: 0-9 then A-Z
Descending order
The largest or last items appear at the top of the list:
- Numbers or amounts: Sorts largest to smallest. Higher numbers or amounts are at the top of the list.
- Letters or strings: From Z to A
- Combination strings, such as address lines: Z-A then 9-0
- Dates: Most recent dates are at the top of the list.
Sort order precedence
This chart (source: ecisolutions.com) shows characters processed in ascending order.
Reverse the characters to determine the order for descending sorts.