ISACTIVE


Determines if an instance of a specific entity type is currently active.


ISACTIVE instances [WHERE condition]


Inputs

  • 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

Singletons are always active, so ISACTIVE <singleton> will always return TRUE 

Examples

Suppose the following data model.


instance_idPerson.namePerson.Age
Person_1“Bob”14
Person_2“Jane”25
Person_3“Mary”30
Active PersonExpressionResultTypeNote
NoneISACTIVE PersonFALSEboolean
Person_1ISACTIVE PersonTRUEboolean
Person_1ISACTIVE Person WHERE Person.Age >= 18FALSEboolean
NoneISACTIVE systemTRUEboolean
NonePerson.Age >= 18Error
No Person is active
None( ISACTIVE Person ) AND Person.Age >= 18FALSEbooleanThe expression is evaluated left-to-right and fails on ( ISACTIVE Person ) instead of giving an error