JoinOperand Class

An operator that joins persistent objects on a specified condition, and calculates aggregate functions against matching objects.

Namespace: DevExpress.Data.Filtering

Assembly: DevExpress.Data.v19.2.dll

Declaration

C#

public class JoinOperand :
    CriteriaOperator,
    IAggregateOperand,
    ICustomAggregateOperand

VB.NET

Public Class JoinOperand
    Inherits CriteriaOperator
    Implements IAggregateOperand,
               ICustomAggregateOperand

Related API Members

The following members return JoinOperand objects:

• JoinOperand.Avg(CriteriaOperator)
• JoinOperand.Clone()
• JoinOperand.Count()
• JoinOperand.Count(CriteriaOperator)
• JoinOperand.Custom(String, IEnumerable<CriteriaOperator>)
• JoinOperand.Exists()
• JoinOperand.Exists(CriteriaOperator)
• JoinOperand.Max(CriteriaOperator)
• JoinOperand.Min(CriteriaOperator)
• JoinOperand.Sum(CriteriaOperator)

Remarks

The JoinOperand works only with eXpress Persistent Objects. Use the JoinOperand to build criteria and calculate aggregate functions using the properties of persistent objects without explicitly defined associations. Persistent objects applied to the current JoinOperand are called parent objects for the join. To specify the type of persistent objects to be joined with parent objects, use the JoinOperand.JoinTypeName property.

To access parent object properties in a join condition, use the Parent Relating Operator.

The JoinOperand does the following:

• Joins the objects on a condition specified via the JoinOperand.Condition property.
• Calculates aggregate functions using expressions created with property values of matching objects. To specify the aggregate function and aggregated expression, use the JoinOperand.AggregateType and JoinOperand.AggregatedExpression properties.

This example demonstrates how to load all employees who can issue refunds (the Employee and User table should have a one-to-one relationship).

C#

using DevExpress.Xpo;
using DevExpress.Data.Filtering;
// ..

/* create via CriteriaOperator.Parse */
// string expr = "[<User>][[Oid] = [^.Oid] && [Permissions][[Action] = ?]]";
// CriteriaOperator filter = CriteriaOperator.Parse(expr, "Issue Refunds");

/* create via constructor */
CriteriaOperator joinCondition = new OperandProperty(nameof(Employee.Oid)) == new OperandProperty($"^.{nameof(User.Oid)}");
CriteriaOperator filterClause = new ContainsOperator(
    collectionProperty: new OperandProperty(nameof(User.Permissions)),
    condition: new OperandProperty(nameof(Permission.Action)) == new OperandValue("Issue Refunds")
    );
CriteriaOperator filter = new JoinOperand(
        joinTypeName: nameof(User),
        condition: joinCondition & filterClause
    );

XPCollection<Employee> employees = new XPCollection<Employee>(session, filter);

VB.NET

Imports DevExpress.Xpo
Imports DevExpress.Data.Filtering

' create via CriteriaOperator.Parse
' Dim expr As String = "[<User>][[Oid] = [^.Oid] && [Permissions][[Action] = ?]]"
' Dim filter As CriteriaOperator = CriteriaOperator.Parse(expr, "Issue Refunds")

' create via constructor
Dim joinCondition As CriteriaOperator = New OperandProperty(nameof(Employee.Oid)) = New OperandProperty($"^.{nameof(User.Oid)}")
Dim filterClause As CriteriaOperator = New ContainsOperator( _
    collectionProperty:= New OperandProperty(nameof(User.Permissions)), _
    condition:= New OperandProperty(nameof(Permission.Action)) = New OperandValue("Issue Refunds") _
    )
Dim filter As CriteriaOperator = New JoinOperand( _
  joinTypeName:= nameof(User), _
  condition:= joinCondition And filterClause _
  )

Dim employees As New XPCollection(Of Employee)(session, filter)

Refer to the Free Joins help topic for information on how to use the JoinOperand.

Note

• For performance reasons, we recommend that you not use the JoinOperand when filtering or sorting the XPCollection on the client side, as this significantly increases the number of queries sent to the server.
• JoinOperand may produce null instead of zero for an empty collection on a server side.

Related GitHub Examples

The following code snippet (auto-collected from DevExpress Examples) contains a reference to the JoinOperand 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/WindowsApplication3/CriteriaHelper.cs#L35

CriteriaOperator IClientCriteriaVisitor<CriteriaOperator>.Visit(JoinOperand theOperand) {
    CriteriaOperator condition = theOperand.Condition.Accept(this) as CriteriaOperator;

VB.NET

XDL_how-to-delete-all-criteria-corresponding-to-a-particular-field-from-criteriaoperator-e3396/VB/WindowsApplication3/CriteriaHelper.vb#L42

Private Function IClientCriteriaVisitorGeneric_Visit(ByVal theOperand As JoinOperand) As CriteriaOperator Implements IClientCriteriaVisitor(Of CriteriaOperator).Visit
    Dim condition As CriteriaOperator = TryCast(theOperand.Condition.Accept(Me), CriteriaOperator)

Inheritance

Object

CriteriaOperator

JoinOperand