DbAggregate constants
The DbAggregate constants identify the SQL aggregate functions for a field in a schema.
| Constant | Value | Description |
|---|---|---|
| _DB_AGGR_COUNT | 1 | Returns the count of records that have somevalue in the field. |
| _DB_AGGR_SUM | 2 | Returns the sum of the values of a field. |
| _DB_AGGR_AVG | 3 | Returns the average value of a field. |
| _DB_AGGR_MIN | 4 | Returns the minimum value of a field. |
| _DB_AGGR_MAX | 5 | Returns the maximum value of a field. |
Note: SUM & AVG are supported only
for numeric fields (that is, integer or float field types). The other functions
work for for any field type.