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.
Integer
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
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.