AggregateOperand Class

An aggregate operator which calculates aggregate expressions (MIN, MAX, SUM, etc.)

Namespace: DevExpress.Data.Filtering

Assembly: DevExpress.Data.v19.1.dll

Declaration

C#

public class AggregateOperand :
    CriteriaOperator,
    IAggregateOperand

VB.NET

Public Class AggregateOperand
    Inherits CriteriaOperator
    Implements IAggregateOperand

Related API Members

The following members return AggregateOperand objects:

Show 12 links

• AggregateOperand.Avg(CriteriaOperator)
• AggregateOperand.Clone()
• AggregateOperand.Count()
• AggregateOperand.Count(CriteriaOperator)
• AggregateOperand.Exists()
• AggregateOperand.Exists(CriteriaOperator)
• AggregateOperand.Max(CriteriaOperator)
• AggregateOperand.Min(CriteriaOperator)
• AggregateOperand.Single(CriteriaOperator)
• AggregateOperand.Sum(CriteriaOperator)
• AggregateOperand.TopLevel(Aggregate, CriteriaOperator)
• OperandProperty.Item[CriteriaOperator]

Remarks

The AggregateOperand is used to compose criteria which are based on the collection properties (the “many” end of a one-to-many or many-to-many relationship) to filter the XPCollection. It represents the results of aggregate operations performed on these types of properties.

Note

• AggregateOperand does not support nested expressions and complex property paths like Max(Document.<PersonID>LastName). Only names of owned properties are supported: Max(Document).

• AggregateOperand may produce null instead of zero for an empty collection on a server side.

For more information and examples, see How to: Build Complex Criteria.

Related GitHub Examples

The following code snippet (auto-collected from DevExpress Examples) contains a reference to the AggregateOperand class.

Note

The algorithm used to collect these code examples remains a work in progress. Accordingly, the links and snippets below may produce inaccurate results. If you encounter an issue with code examples below, please use the feedback form on this page to report the issue.

C#

XDL_how-to-delete-all-criteria-corresponding-to-a-particular-field-from-criteriaoperator-e3396/CS/PatchCriteriaExample/Filtering/CriteriaPatcherSkipProperties.cs#L26

public override CriteriaOperator Visit(AggregateOperand theOperand) {
    CriteriaOperator collectionProperty = Visit(theOperand.CollectionProperty);

VB.NET

XDL_how-to-delete-all-criteria-corresponding-to-a-particular-field-from-criteriaoperator-e3396/VB/PatchCriteriaExample/Filtering/CriteriaPatcherSkipProperties.vb#L40

Public Overrides Function Visit(ByVal theOperand As AggregateOperand) As CriteriaOperator
    Dim collectionProperty As CriteriaOperator = Visit(theOperand.CollectionProperty)

Inheritance

Object

CriteriaOperator

AggregateOperand

ContainsOperator