length() Function

This function returns the number of elements in an array.


length( array )

array: (Any Type Array) The array in which to calculate the number of elements.




This function does not count null elements.

For example, if used on a null result of a query from the Query Database Smart Service,, the expression fails to evaluate and causes an error. To avoid an error, first check the result set for a null value using the isnull() function before attempting to count the result set using the length() function.


length({10, 20, 30}) returns 3

See Also

isnull(): Use this function to determine if the process variable or array contains null values.

count(): Use this function to include null elements in the number of elements in a process variable or array.

Open in Github Built: Sat, Jul 02, 2022 (01:50:09 AM)

On This Page