Scalar FunctionsDynamic / JSON Functions

array_index_of

Return the zero-based index of the first occurrence of `lookup` in `array`, optionally starting at `start_index`.

Returns -1 when not found, or when the input is not a dynamic array.

Syntax

array_index_of(array, lookup, start_index)

Prop

Type

Returns: long

print array_index_of(dynamic([1, 2, 3, 2]), 2)

print_0 (long)
1

array_iff

Element-wise select between two values based on a boolean-array condition.

array_length

Return the number of elements in an array.