1 of 1

First

The First() function returns the first item in a list or concept set.

This function is NOT SQL compatible. For more information about SQL compatibility, see our documentation.

Returns the first item in the given list or concept_set.

Returns Unknown if one of the parameter values is unknown or outside the common valid date boundaries.

First(list)

First(List("A", "B", "C"))=>Result: "A"

First([Products] where [Product.Price] > 10)=>Result: returns the first row of products that cost more than 10 euro

First()=>Result: unknown

First(concept_set)

First({ Color.Orange, Color.Blue, Color.Red })=>Result: Color.Orange

First()=>Result: unknown

The First() function returns the first item in a list or concept set.

This function is NOT SQL compatible. For more information about SQL compatibility, see our documentation.

Returns the first item in the given list or concept_set.

Returns Unknown if one of the parameter values is unknown or outside the common valid date boundaries.

First(list)

First(List("A", "B", "C"))=>Result: "A"

First([Products] where [Product.Price] > 10)=>Result: returns the first row of products that cost more than 10 euro

First()=>Result: unknown

First(concept_set)

First({ Color.Orange, Color.Blue, Color.Red })=>Result: Color.Orange

First()=>Result: unknown

Name

Type

Required

Description