IFUNKNOWNAn alternative notation of the ISUNKOWN function, which increases readability especially for long expressions. This function replaces a value if that value is unknown. The IFUNKNOWN function takes precendence over any other binary operator (except for the "NOT" operator). For example, this means that the expression A.B AND C.D IFUNKNOWN FALSE will be interpreted as A.B AND (C.D IFUNKNOWN FALSE). You can use parentheses to influence this behavior, e.g. by writing (A.B AND C.D) IFUNKNOWN FALSE. For the "NOT" operator the following expression "X AND NOT B IFUNKNOWN FALSE", can also be read as "X AND ((NOT B) IFUNKNOWN FALSE)" Syntax Code Block |
---|
expression IFUNKNOWN value |
Return type Examples Suppose the following data model.
Person.name | Person.SequenceNumber | Person.HasDrivingLicense |
---|
“Bob” | 654 | true | “Jane” | ? | true | “Mary” | 667 | false | “Rick” | ? | ? | “Ron” | ? | false | “Jenny” | 765 | true | ? | 111 | true |
Active Person | Expression | Result | Type |
---|
Jane - ? - true | Person.SequenceNumber IFUNKNOWN 999 | 999 | Integer | Mary - 667 - false | Person.SequenceNumber IFUNKNOWN 999 | 667 | Integer | ? - 111 - true | Person.Name IFUNKNOWN "customer" | "customer" | String | "Rick" - ? - ? | NOT Person.HasDrivingLicense IFUNKOWN false | false | Boolean |
UI Text Box |
---|
| Both parameters of the IFUNKNOWN function must be of the same datatype. If they differ in datatype, you get this validation error in studio: Could not find function: IFUNKNOWN matching arguments System.Collections.ArrayList
|
Include Page |
---|
| _nav_BackToTop |
---|
| _nav_BackToTop |
---|
|
|