Sort action sorts repeating items in results based on a key field and order you choose. Connect a document-type result as the input to Sort.Repeating element to sort | Generally set automatically by Wires to the repeating items in the results from the input. To change this, delete the existing path and use the Path Selector button to find the repeating items you want to sort. See Select Fields or Paths for Block Properties with the Path
Selector for more information. |
Fields to sort on | Choose one or more fields in these repeating items to sort by, in the order you want them sorted. For each field, complete the fields for one sort criteria. Click the + button to add another sort criteria |
left field in sort criteria | Use the Path Selector button to find a field to sort results by. See Select Fields or Paths for Block Properties with the Path
Selector for more information. |
 or  | Click this button to change the sort order for this field. Defaults to ascending. |
datatype | Choose the datatype of the data for this field:  Date = for dates, times or dates and timesNumeric = for numbersString = for text values |
MM/dd/yyyy | If the field is a date or time, select the pattern that represents the format of values in this field. See Date/Time Format Patterns for information on the meaning of the characters used in date/time patterns. |
Case Sensitive | Makes text sorting case sensitive. |
Pattern | Usage |
a | AM or PM for 12-hour times |
dd | 2-digit day of the month, such as 05 |
EEE | 3-character abbreviation of the day of the week, such as Thu |
EEEE | full name of the day of the week, such as Thursday |
HH | 2-digit hour in a 24 hour clock (0-23) |
hh | 2-digit hour in a 12 hour clock (01-12) |
mm | 2-digit minutes |
MM | 2-digit month, such as 12 |
MMM | 3-character month abbreviation, such as Dec |
MMMM | Full month by name, such as December |
ss | 2-digit seconds |
sss | 3-digit milliseconds |
yyyy | 4-digit year, such as 2005 |
z | Timezone |