MongoDB · Types · Queries
ArxAggregateOperator
Definition
- Namespace
ARX.SDK.Query- Package
ARX.SDK
public enum ArxAggregateOperatorThe value an aggregate column computes: a count, the minimum, maximum, sum or average, a standard deviation or a variance.
Values
None= 0No aggregate.
Count= 1The number of rows (or of non-null values of the attribute).
CountDistinct= 2The number of distinct non-null values.
CountBig= 3As Count, as a 64-bit number where the database distinguishes it.
CountBigDistinct= 4As CountDistinct, as a 64-bit number where the database distinguishes it.
Min= 5The smallest value.
Max= 6The largest value.
Sum= 7The sum of the values.
Avg= 8The average of the values.
StDev= 9The sample standard deviation.
StDevP= 10The population standard deviation.
Var= 11The sample variance.
VarP= 12The population variance.
Usage
A line from a verified sample; the full, runnable code is on its page.
query.AggregateInfo.AddAggregateColumn("accounts", "", ArxAggregateOperator.Count);A report by industry, scenario 1
Used in:
- A report by industryRetrieveMultiple