Versions Compared

Old Version 13

changes.mady.by.user Unknown User (m.schadd)

Saved on

compared with

New Version 14

changes.mady.by.user Unknown User (m.schadd)

Saved on

Key

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

...

Panel
bgColorwhite

ISUNKNOWN

This function replaces a value if that value is unknown.

Syntax

Code Block
ISUNKNOWN(expression, value)
  • expression- Expression of which the value has to be returned if that value is known.
  • value - Value to return if the attribute value is unknown.

Return type

  • any type, equals the attribute type

Examples

Suppose the following data model.

 

Person.namePerson.SequenceNumber
“Bob”654
“Jane”?
“Mary”667
“Rick”?
“Ron”?
“Jenny”765

 

  • for Jane, ISUNKNOWN ( Person.SequenceNumber , 999 ) = 999
  • for Mary, ISUNKNOWN ( Person.SequenceNumber , 999 ) = 667
UI Text Box
typenote

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

 

Include Page
_nav_BackToTop
_nav_BackToTop

...