Page History
Learn more about the functions ISNULL, ISUNKNOWN, IFUNKNOWN, IS A, TYPE OF, ISACTIVE, GUID.
Overview
Table of Contents minLevel 2
...
bgColor | white |
---|
ISNULL
This function checks whether a value is unknown
Syntax
Code Block |
---|
ISNULL(expression) |
- expression - Expression that is checked.
Return type
- boolean - TRUE of the attribute is unknown, FALSE otherwise
Examples
Suppose the following data model.
...
- for Bob,
ISNULL ( Person.SequenceNumber )
= FALSE - for Jane,
ISNULL ( Person.SequenceNumber )
= TRUE
Back to top |
---|
...
bgColor | white |
---|
ISUNKNOWN
...
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.
...
- for Jane,
ISUNKNOWN ( Person.SequenceNumber , 999 )
= 999 - for Mary,
ISUNKNOWN ( Person.SequenceNumber , 999 )
= 667
Back to top |
---|
IFUNKNOWN | Alternative notation of the ISUNKNOWN function, which increases readability especially for long expressions. |
IS A | Checks the entity type of an instance. |
TYPE OF | Determines the entity type of an instance. |
ISACTIVE | Determines |
Panel | |||
---|---|---|---|
| |||
IS AUse this function to check the type of an instance. The function returns TRUE if the selected instance is of the specified entity. Syntax
Return type
Examples Suppose a domain model in which there is a singleton entity If you want to determine the number of bedrooms is the residence:
If you want to determine the number of bathrooms is the residence:
|
Panel | |||
---|---|---|---|
| |||
TYPE OFUse this function to determine the type of an instance. The function returns the name of the entity. Syntax
Return type
Examples Suppose a domain model in which there is a singleton entity
|
...
bgColor | white |
---|
ISACTIVE
...
if an instance of a specific entity type is currently active. |
Code Block |
---|
ISACTIVE instances [WHERE condition] |
- instances - instances to search
- condition - optional condition to limit the collection of instances to check
Return type
boolean - TRUE if one of the instances is active, FALSE otherwise
UI Text Box type note Singletons are always active, so ISACTIVE <singleton> will always return TRUE
Examples
Suppose the following data model.
...
- If no instance of Person is activated,
ISACTIVE Person
= FALSE - If
Person_1
is active,ISACTIVE Person
= TRUE - If
Person_1
is active,ISACTIVE Person WHERE Person.Age >= 18
= FALSE (sincePerson_1
is excluded by the condition) ISACTIVE system
= TRUE (system
contains the system attributes and is a singleton. Therefore it is always active)- If no instance of Person is activated, the following expression will fail because Person is not in scope:
Person.Name >= 18
ISACTIVE
function the expression can be evaluated without error:(ISACTIVE Person) AND Person.name >= 18
UI Text Box type note Note that expression above will be evaluated from left to right, so first (ISACTIVE Person) will be evaluated (= FALSE) and therefore the result of the AND will be FALSE as well. The right hand side of the expression (Person.Name >= 18) will not be evaluated, otherwise the expression would still fail.
GUID | Generates a globally unique identifier which can later be used to uniquely mark and recognize a desired element. |
Functions
Include Page Miscellaneous function ISNULL Miscellaneous function ISNULL
Include Page Miscellaneous function ISUNKNOWN Miscellaneous function ISUNKNOWN
Include Page Miscellaneous function IFUNKNOWN Miscellaneous function IFUNKNOWN
Include Page Miscellaneous function IS A Miscellaneous function IS A
Include Page Miscellaneous function TYPE OF Miscellaneous function TYPE OF
Include Page Miscellaneous function ISACTIVE Miscellaneous function ISACTIVE
Include Page Miscellaneous function GUID Miscellaneous function GUID
...