JoinOperator Enum

Definition

Namespace:

Microsoft.Xrm.Sdk.Query

Assembly:

Microsoft.Xrm.Sdk.dll

Package:

Microsoft.PowerPlatform.Dataverse.Client v1.1.17

Contains the possible values for a join operator in a LinkEntity.

public enum class JoinOperator

[System.Runtime.Serialization.DataContract(Name="JoinOperator", Namespace="http://schemas.microsoft.com/xrm/2011/Contracts")]
public enum JoinOperator

[<System.Runtime.Serialization.DataContract(Name="JoinOperator", Namespace="http://schemas.microsoft.com/xrm/2011/Contracts")>]
type JoinOperator = 

Public Enum JoinOperator

Inheritance

Enum

JoinOperator

Attributes

DataContractAttribute

Fields

All	8	This join operator is used to filter values on related records. Restricts results to parent rows where rows with matching LinkEntity.LinkToAttributeName column values exist in the related table, but none of those matching rows satisfy the additional filters defined for this LinkEntity. You need to invert the additional filters to find parent rows where every matching related table row satisfies some additional criteria.
Any	6	This join operator is used to filter values on related records. Restricts results to parent rows with any matching rows in the related table.
Exists	5	A variant of Inner that can provide performance benefits. Uses an EXISTS condition in the WHERE clause. Use this when multiple copies of the parent row are not necessary in the results.
In	4	A variant of Inner that can provide performance benefits. Uses an IN condition in the WHERE clause. Use this when multiple copies of the parent row are not necessary in the results.
Inner	0	Restricts results to rows with matching values in both tables.
LeftOuter	1	Includes results from the parent row that don't have a matching value.
MatchFirstRowUsingCrossApply	3	A variant of Inner that can provide performance benefits. Use this type when only a single example of a matching row from the linked entity is sufficient and multiple copies of the parent row in the results aren't necessary.
Natural	2	Only one value of the two joined columns is returned if an equal-join operation is performed and the two values are identical.
NotAll	9	This join operator is used to filter values on related records. Restricts results to parent rows with any matching rows in the related table. Despite the name, this link type is equivalent to Any
NotAny	7	This join operator is used to filter values on related records. Restricts results to parent rows with no matching rows in the related table.