JoinOperator Enum

Reference

Definition

Namespace:: Microsoft.Xrm.Sdk.Query

Assembly:: Microsoft.Xrm.Sdk.dll

Package:: Microsoft.PowerPlatform.Dataverse.Client v1.0.9

Important

Some information relates to prerelease product that may be substantially modified before it’s released. Microsoft makes no warranties, express or implied, with respect to the information provided here.

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
Any	6	Link-entity is generated as Subquery. The outer entity uses the “in” operator on the Subquery.
Exists	5	Link-entity is generated as a Correlated Subquery. The outer entity uses “exists” operator on the Correlated Subquery.
In	4
Inner	0	The values in the attributes being joined are compared using a comparison operator. Value = 0.
LeftOuter	1	All instances of the entity in the FROM clause are returned if they meet WHERE or HAVING search conditions. Value = 1.
MatchFirstRowUsingCrossApply	3	Link-entity is generated as Correlated Subquery. The outer entity uses the “cross apply” operator on the Correlated Subquery. Pick the top 1 row.
Natural	2	Only one value of the two joined attributes is returned if an equal-join operation is performed and the two values are identical. Value = 2.
NotAll	9
NotAny	7

Applies to