Null Check Operators
Operators for testing null and empty values.
Null
Returns true if the value is null.
| Property | Value |
|---|---|
| Category | Boolean/Unary Logical |
| Min Arguments | 1 |
| Max Arguments | 1 |
| Returns | boolean |
Arguments:
| # | Name | Type | Description |
|---|---|---|---|
| 0 | Value | any | Value to check |
Example:
Null(MiddleName) → true if no middle name provided
Null(ApprovalDate) → true if not yet approved
Not Null
Returns true if the value is NOT null.
| Property | Value |
|---|---|
| Category | Boolean/Unary Logical |
| Min Arguments | 1 |
| Max Arguments | 1 |
| Returns | boolean |
Example:
Not Null(Email) → true if email is provided
Not Null(ManagerId) → true if has a manager assigned
Null Or Empty String
Returns true if text is null or empty.
| Property | Value |
|---|---|
| Category | Boolean/Unary Logical |
| Min Arguments | 1 |
| Max Arguments | 1 |
| Returns | boolean |
Arguments:
| # | Name | Type | Description |
|---|---|---|---|
| 0 | Text | string | String to check |
Description: Returns true if the string is null, empty (""), or contains only whitespace.
Example:
Null Or Empty String(Description) → true if no description
Null Or Empty String("") → true
Null Or Empty String(" ") → true (whitespace only)
Null Or Empty String("Hello") → false
Not Null Or Empty String
Returns true if text is NOT null and NOT empty.
| Property | Value |
|---|---|
| Category | Boolean/Unary Logical |
| Min Arguments | 1 |
| Max Arguments | 1 |
| Returns | boolean |
Example:
Not Null Or Empty String(FirstName) → true if first name has a value
Is True
Returns true if the boolean value is true.
| Property | Value |
|---|---|
| Category | Boolean/Unary Logical |
| Min Arguments | 1 |
| Max Arguments | 1 |
| Returns | boolean |
Arguments:
| # | Name | Type | Description |
|---|---|---|---|
| 0 | Boolean Value | boolean | Value to check |
Description: Explicitly checks if a boolean field is true. Useful when the field might be null.
Example:
Is True(IsActive) → true if IsActive is true
Is True(HasAcceptedTerms) → true if terms accepted
Is False
Returns true if the boolean value is false.
| Property | Value |
|---|---|
| Category | Boolean/Unary Logical |
| Min Arguments | 1 |
| Max Arguments | 1 |
| Returns | boolean |
Description: Explicitly checks if a boolean field is false. Useful when the field might be null.
Example:
Is False(IsDeleted) → true if not deleted
Is False(IsLocked) → true if account is unlocked
Any
Returns true if a list contains at least one non-null value.
| Property | Value |
|---|---|
| Category | Boolean/Unary Logical |
| Min Arguments | 1 |
| Max Arguments | 1 |
| Returns | boolean |
Arguments:
| # | Name | Type | Description |
|---|---|---|---|
| 0 | List | list | Collection to check |
Description: Returns true if the list has at least one item. Returns false for empty lists or lists containing only null values.
Example:
Any(RelatedContacts) → true if has any related contacts
Any(LineItems) → true if order has line items
Any(Attachments) → true if has attachments
Null Check Quick Reference
| Operator | Use When |
|---|---|
| Null | Checking if a value has not been set |
| Not Null | Checking if a value has been set |
| Null Or Empty String | Checking if text is missing or blank |
| Not Null Or Empty String | Checking if text has meaningful content |
| Is True | Checking a boolean that might be null |
| Is False | Checking a boolean that might be null |
| Any | Checking if a collection has items |
Common Patterns
Required Field Validation:
Not Null Or Empty String(FirstName)
And(Not Null(Email), Not Null(Phone))
Conditional Logic:
If Condition(Null(Discount), 0, Discount)
→ returns 0 if Discount is null, otherwise returns Discount
If Condition(Any(LineItems), "Has items", "Empty order")
→ message based on whether order has items
Safe Field Access:
And(Not Null(Customer), Not Null(Customer.Email))
→ check customer exists before accessing email