has_any
aggregation-functions has_any
syntax
- has_any(a)
definition
has_any(a) is a boolean variant of the pcount function, resulting in the value true if the number of entries of a relation in the related domain-unit is more than zero and false if this number is zero. The has_any(a) function can be defined as pcount(a) > 0.
definition
Use the has_any in stead of the pcount function in cases where not the number of cases but only the fact that cases occur is relevant, as the has_any function uses less memory.
applies to
- attribute a with uint2, uint4, uint8, uint16, uint32, spoint, ipoint or bool value-type
example
attribute<uint32> has_anyReg (Region) := has_any(City/Region_rel);
| City/Region_rel |
|---|
| 0 |
| 1 |
| 2 |
| 1 |
| 3 |
| null |
| 3 |
domain City, nr of rows = 7
| has_anyReg |
|---|
| true |
| true |
| true |
| true |
| false |
domain Region, nr of rows = 5