Any

Aggregation functions any

syntax

• any(a)
• any(a, relation)

definition

1. any(a) results in a boolean parameter, with the value True if any value of boolean attribute a is True and the value False in all other cases.
2. any(a, relation) results in a boolean attribute, with the values True if any value of boolean attribute a is True and as values False in all other cases, grouped by relation. The domain unit of the resulting attribute is the values unit of the relation.

applies to

• attribute a with bool value type
• relation with value type of the group CanBeDomainUnit

conditions

The domain of arguments a and relation must match.

performance

• Without relation: O(n) where n = number of elements in the domain of a. May short-circuit when first True is found.
• With relation: O(n) where n = number of elements in the domain of a. Evaluates all elements to determine result per group.

example

parameter<bool> anyA := any(A); result = True
parameter<bool> anyB := any(B); result = True
parameter<bool> anyC := any(C); result = False

A	B	C
True	True	False
True	False	False
True	True	False
True	False	False
True	True	False

ADomain, nr of rows = 5

see also

• all