This is the old version of our wiki. We advice to visit: https://www.geodms.nl

Max

From ObjectVision

Jump to: navigation, search

Aggregation functions max(imum)

Contents

syntax

  • max(a)
  • max(a, relation)

definition

description

The max function is not defined for boolean data items, use the all function instead.

applies to

conditions

  1. The values unit of the resulting data item should match with regard to value type and metric with the values unit of attribute a.
  2. The domain of argument a and relation must match.

since version

5.15

example

parameter<uint32> maxNrInh := max(City/NrInhabitants); result = 550
parameter<uint32> maxCity    := max(City/CityName); result = ‘Utrecht’
attribute<uint32>    maxNrInhRegion        (Region) := max(City/NrInhabitants, City/Region_rel);  
attribute<uint32>    maxCityNameRegion (Region) := max(City/CityName, City/Region_rel);   
City/NrInhabitants City/CityName City/Region_rel
550 Amsterdam 0
525 Rotterdam 1
300 Utrecht 2
500 DenHaag 1
200 Eindhoven 3
175 Haarlem null
null null 3

domain City, nr of rows = 7

maxNrInhRegion maxCityNameRegion
550 Amsterdam
525 Rotterdam
300 Utrecht
200 Eindhoven
0

domain Region, nr of rows = 5

see also

Personal tools