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
Dates: The oldest dates are at the top of the list.

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.