FIRST ER function

The FIRST function returns the first record of the specified list as a Container (record) value, if that list isn't empty. If the list is empty, this function throws an exception.

Syntax

FIRST (list)

Arguments

list: Record list

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

Return values

Container (record)

The resulting record value.

Example 1

The expression FIRST(SPLIT("ABC",1)).Value returns the text value "A".

Example 2

The expression FIRST(SPLIT("",1)).Value throws an exception at runtime.

Additional resources

List functions