Count of Items in List | ARRAY_LENGTH

Syntax

ARRAY_LENGTH( [value] )

Parameters

value
The ARRAY whose length is being calculated.

Return Value

The number of items in VALUE or 0 if VALUE is not an array.

Description

Counts the items in an array.

Examples

ARRAY_LENGTH([1, 2, 3]) # returns 3

ARRAY_LENGTH([]) # returns 0

ARRAY_LENGTH(null) # returns 0