Edit

REVERSE ER function

  • Article

The REVERSE function returns the specified list as a Record list value in reversed sort order.

Syntax

REVERSE (list)

Arguments

list: Record list

The valid path of a data source of the Record list data type.

Return values

Record list

The resulting list of records.

Example 1

If you enter data source DS of the Calculated field type, and it contains the expression SPLIT ("C|B|A", "|"), the expression FIRST( REVERSE( ORDERBY( DS, DS. Value))).Value returns the text value "C".

Example 2

If Vendor is configured as an Electronic reporting (ER) data source that refers to the VendTable table, the expression REVERSE (ORDERBY (Vendors, Vendors.'name()')) returns a list of vendors that is sorted by name in descending order.

Additional resources

List functions