Returns false
if the value is null, an empty string, or an empty list. Otherwise returns true
.
See also:
Keyword | Type | Description |
---|---|---|
|
Any Type |
Value to be checked. |
Boolean
This function is similar to the behavior of using if()
and isnull()
in combination 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
8
9
not(
or(
or(tostring(ri!input) = "", isnull(ri!input)),
if(isnull(ri!input),
true,
length(a!flatten(ri!input)) = 0
)
)
)
Or you could use a!isNotNullOrEmpty()
, which requires fewer lines of code:
1
a!isNotNullOrEmpty(ri!input)
1
a!isNotNullOrEmpty(togroup(null))
Returns false
1
a!isNotNullOrEmpty("")
Returns false
1
a!isNotNullOrEmpty({1,2,3,4})
Returns true
1
a!isNotNullOrEmpty(cast(recordType!Address, null)
Returns false
1
a!isNotNullOrEmpty(recordType!Address)
Returns true
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 | Incompatible | You cannot use this function to configure a process report. |
Process Events | Incompatible | You cannot use this function to configure a process event node, such as a start event or timer event. |
a!isNotNullOrEmpty() Function