Appendix : Legacy Presto components : Mashables and Mashups : Mashups in Business Analytics Wires : Creating Mashups in Wires : Add Actions or Other Blocks : Sort Results
Sort Results
The 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 times
*Numeric = for numbers
*String = 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.
Date/Time Format Patterns
The following characters are used in date/time format patterns:
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
Copyright © 2013-2017 Software AG, Darmstadt, Germany. (Innovation Release)

Product LogoContact Support   |   Community   |   Feedback