SORTDOWNBY

Use SORTDOWNBY to sort the objects of a series based on a component that the objects contain. The SORTDOWNBY function returns the input series, sorted in descending order by the value of the specified component.
  • When the character set of the data is ASCII, the objects are sorted in ASCII descending order.
  • For all other character sets, the objects are sorted in binary descending order.

The SORTDOWNBY function does not sort the output of the EXTRACT, REJECT, or UNIQUE functions.

Syntax:
SORTDOWNBY (series-item-expression, single-item-expression)
Meaning:
SORTDOWNBY (group_series_to_sort, group_component_to_sort_by)
Returns:
A series object

SORTDOWNBY returns a series of instances of a group, sorted in descending order by the value of an item that the group contains.

Example

In this example, the group Soldier contains the items:
  • Name
  • Rank
  • Serial number
The following command returns the instances of Soldier, sorted in descending order by Rank:
SORTDOWNBY (Soldier:Army, Rank:Soldier:Army) 

Related functions

  • SEARCHDOWN
  • SEARCHUP
  • SORTDOWN
  • SORTUP
  • SORTUPBY