length() Function

This function returns the number of elements in an array.

Syntax

length( array )

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

Returns

Integer

Notes

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.

Examples

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

FEEDBACK