You are viewing the documentation for Blueriq 15. Documentation for other versions is available in our documentation directory.
ISUNKNOWN
Replaces a value if that value is unknown.
Syntax
ISUNKNOWN ( expression , value )
Inputs
- expression- Expression of which the value has to be returned if that value is known.
- value - Value to return if the expression value is unknown.
Return type
- any type, equals the expression type
Examples
Suppose the following data model.
| Person.name | Person.SequenceNumber |
|---|---|
| “Bob” | 654 |
| “Jane” | ? |
| “Mary” | 667 |
| “Rick” | ? |
| “Ron” | ? |
| “Jenny” | 765 |
| ? | 111 |
| Active Person | Expression | Result | Type |
|---|---|---|---|
| Jane - ? | ISUNKNOWN ( Person.SequenceNumber , 999 ) | 999 | Integer |
| Mary - 667 | ISUNKNOWN ( Person.SequenceNumber , 999 ) | 667 | Integer |
| ? - 111 | ISUNKNOWN ( Person.Name , "customer" ) | "customer" | String |
Both parameters of the ISUNKNOWN function must be of the same datatype. If they differ in datatype, you get this validation error in studio:
Could not find function: ISUNKNOWN matching arguments System.Collections.ArrayList
Overview
Content Tools