You are viewing the documentation for Blueriq 17. Documentation for other versions is available in our documentation directory.
ISNULL
This function checks whether a value is unknown.
Syntax
ISNULL ( expression )
Input
- expression - Expression that is checked.
Return type
- boolean - TRUE of the attribute is unknown, FALSE otherwise
Examples
Suppose the following data model.
| Person.name | Person.SequenceNumber |
|---|---|
| “Bob” | 654 |
| “Jane” | ? |
| Active Person | Expression | Result | Type |
|---|---|---|---|
| Bob | ISNULL ( Person.SequenceNumber ) | FALSE | boolean |
| Jane | ISNULL ( Person.SequenceNumber ) | TRUE | boolean |
Overview
Content Tools