Returns true
if the value is null, an empty string, or an empty list. Otherwise returns false
.
See also:
Keyword | Type | Description |
---|---|---|
|
Any Type |
Value to be checked. |
Boolean
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)
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