You are viewing the documentation for Blueriq 16. 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.namePerson.SequenceNumber
“Bob”654
“Jane”?
“Mary”667
“Rick”?
“Ron”?
“Jenny”765
?111
Active PersonExpressionResultType
Jane - ?ISUNKNOWN ( Person.SequenceNumber , 999 )999Integer
Mary - 667ISUNKNOWN ( Person.SequenceNumber , 999 )667Integer
? - 111ISUNKNOWN ( 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

Back to Top