Versions Compared

Old Version 7

changes.mady.by.user Felix Janssen

Saved on

compared with

New Version Current

changes.mady.by.user Tijmen Daatselaar

Saved on

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.
note


Panel
bgColorwhite

ISUNKNOWN


Replaces a value if that value is unknown.


Syntax

Code Block
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
UI Text Box
type
Info

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