a!isNullOrEmpty() Function

Function

Returns true if the value is null, an empty string, or an empty list. Otherwise returns false.

See also:

• if()
• isnull()
• not()
• a!isNotNullOrEmpty()

Parameters

Returns

Boolean

Usage considerations

Replace if() and isnull() expressions with a!isNullorEmpty

This function is similar to the behavior of using if() and isnull() to check for the absence of a value or an empty string or list.

For example, you could create an expression using if() and isnull():

1
2
3
4
5
6
7
or( 
    or(tostring(ri!input) = "", isnull(ri!input)), 
    if(isnull(ri!input), 
        true, 
        length(a!flatten(ri!input)) = 0
    ) 
)

Or you could use a!isNullorEmpty(), which requires fewer lines of code:

1
a!isNullOrEmpty(ri!input)

Examples

1
a!isNullOrEmpty(togroup(null))

Returns true

1
a!isNullOrEmpty("")

Returns true

1
a!isNullOrEmpty({1,2,3,4})

Returns false

1
a!isNullOrEmpty(cast(recordType!Address, null))

Returns true

1
a!isNullOrEmpty(recordType!Address)

Returns false

Feature compatibility

Feedback