ISACTIVE
Use this function to determine Determines if an instance of a specific entity type is currently active.
| Code Block |
|---|
ISACTIVE instances [WHERE condition] |
Inputs - instances - instances to search
- condition - optional condition to limit the collection of instances to check
Return type | Info |
|---|
Singletons are always active, so ISACTIVE <singleton> will always return TRUE |
Examples Suppose the following data model. GUIDThis function is able to generate a globally unique identifier which can later be used to uniquely mark and recognize a desired element. The GUIDs are represented as 32 hexadecimal digits, displayed in five groups separated by hyphens, in the form 8-4-4-4-12 for a total of 36 characters. Syntax Return type Examples
| instance_id | Person.name | Person.Age |
|---|
| Person_1 | “Bob” | 14 | | Person_2 | “Jane” | 25 | | Person_3 | “Mary” | 30 |
| Active Person | Expression | Result | Type | Note |
|---|
| None | ISACTIVE Person | FALSE | Booleanboolean |
| | Person_1 | ISACTIVE Person | TRUE | Booleanboolean |
| | Person_1 | ISACTIVE Person WHERE Person.Age >= 18 | FALSE | Booleanboolean |
| | None | ISACTIVE system | TRUE | Booleanboolean |
| | None | Person.Age >= 18 | Error |
| No Person is active | | None | ( ISACTIVE Person ) AND Person.Age >= 18 | FALSE | Booleanboolean | The expression is evaluated left-to-right and fails on ( ISACTIVE Person ) instead of giving an error |
|