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.

Syntax

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

Parameters

NameTypeRequiredDescription

list

List of elements of the same type

☑️

a list of values or elements of the same type.

concept_set

A list of concepts

☑️

a list of concepts

Last updated