length( array )
This function returns the number of elements in an array.
See also:
Keyword | Type | Description |
---|---|---|
|
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
Feature | Compatibility | Note |
---|---|---|
Portals | Compatible | |
Offline Mobile | Compatible | |
Sync-Time Custom Record Fields | Compatible | Can be used to create a custom record field that only evaluates at sync time. |
Real-Time Custom Record Fields | Incompatible | |
Process Reports | Compatible | |
Process Events | Compatible |
length() Function