Edit

Share via

Duplicate Rule Condition (DuplicateRuleCondition) table/entity reference (Microsoft Dataverse)

Condition of a duplicate detection rule.

Messages

The following table lists the messages for the Duplicate Rule Condition (DuplicateRuleCondition) table. Messages represent operations that can be performed on the table. They may also be events.

Name
Is Event?		 Web API Operation SDK for .NET
Associate
Event: True		 Associate records Associate records
Create
Event: False		 POST /duplicateruleconditions
See Create		 Create records
Delete
Event: False		 DELETE /duplicateruleconditions(duplicateruleconditionid)
See Delete		 Delete records
Disassociate
Event: True		 Disassociate records Disassociate records
Retrieve
Event: False		 GET /duplicateruleconditions(duplicateruleconditionid)
See Retrieve		 Retrieve records
RetrieveMultiple
Event: False		 GET /duplicateruleconditions
See Query data		 Query data
Update
Event: False		 PATCH /duplicateruleconditions(duplicateruleconditionid)
See Update		 Update records
Upsert
Event: False		 PATCH /duplicateruleconditions(duplicateruleconditionid)
See Upsert a table row		 UpsertRequest

Properties

The following table lists selected properties for the Duplicate Rule Condition (DuplicateRuleCondition) table.

Property Value
DisplayName Duplicate Rule Condition
DisplayCollectionName Duplicate Rule Conditions
SchemaName DuplicateRuleCondition
CollectionSchemaName DuplicateRuleConditions
EntitySetName duplicateruleconditions
LogicalName duplicaterulecondition
LogicalCollectionName duplicateruleconditions
PrimaryIdAttribute duplicateruleconditionid
TableType Standard
OwnershipType None

Writable columns/attributes

These columns/attributes return true for either IsValidForCreate or IsValidForUpdate (usually both). Listed by SchemaName.

BaseAttributeName

Property Value
Description Field that is being compared.
DisplayName Base Field
IsValidForForm True
IsValidForRead True
LogicalName baseattributename
RequiredLevel SystemRequired
Type String
Format Text
FormatName Text
ImeMode Auto
IsLocalizable False
MaxLength 128

DuplicateRuleConditionId

Property Value
Description Unique identifier of the condition.
DisplayName Duplicate Rule Condition
IsValidForForm False
IsValidForRead True
LogicalName duplicateruleconditionid
RequiredLevel SystemRequired
Type Uniqueidentifier

IgnoreBlankValues

Property Value
Description Determines whether to consider blank values as non-duplicate values
DisplayName Ignore Blank Values
IsValidForForm True
IsValidForRead True
LogicalName ignoreblankvalues
RequiredLevel None
Type Boolean
GlobalChoiceName duplicaterulecondition_ignoreblankvalues
DefaultValue False
True Label True
False Label False

IsCustomizable

Property Value
Description For internal use only.
DisplayName Is Customizable
IsValidForForm False
IsValidForRead True
LogicalName iscustomizable
RequiredLevel SystemRequired
Type ManagedProperty

MatchingAttributeName

Property Value
Description Field that is being compared with the base field.
DisplayName Matching Field
IsValidForForm True
IsValidForRead True
LogicalName matchingattributename
RequiredLevel SystemRequired
Type String
Format Text
FormatName Text
ImeMode Auto
IsLocalizable False
MaxLength 128

OperatorCode

Property Value
Description Operator for this rule condition.
DisplayName Operator Code
IsValidForForm True
IsValidForRead True
LogicalName operatorcode
RequiredLevel SystemRequired
Type Picklist
DefaultFormValue -1
GlobalChoiceName duplicaterulecondition_operatorcode

OperatorCode Choices/Options

Value Label
0 Exact Match
1 Same First Characters
2 Same Last Characters
3 Same Date
4 Same Date and Time
5 Exact Match (Pick List Label)
6 Exact Match (Pick List Value)

OperatorParam

Property Value
Description Parameter value of N if the operator is Same First Characters or Same Last Characters.
DisplayName Operator Parameter
IsValidForForm True
IsValidForRead True
LogicalName operatorparam
RequiredLevel None
Type Integer
MaxValue 2147483647
MinValue 1

RegardingObjectId

Property Value
Description Unique identifier of the object with which the condition is associated.
DisplayName Regarding
IsValidForForm False
IsValidForRead True
LogicalName regardingobjectid
RequiredLevel None
Type Lookup
Targets duplicaterule

UniqueRuleName

Property Value
Description
DisplayName UniqueRuleName
IsValidForForm True
IsValidForRead True
LogicalName uniquerulename
RequiredLevel SystemRequired
Type String
Format Text
FormatName Text
ImeMode Auto
IsLocalizable False
MaxLength 100

Read-only columns/attributes

These columns/attributes return false for both IsValidForCreate and IsValidForUpdate. Listed by SchemaName.

ComponentIdUnique

Property Value
Description For internal use only.
DisplayName Row id unique
IsValidForForm False
IsValidForRead True
LogicalName componentidunique
RequiredLevel SystemRequired
Type Uniqueidentifier

ComponentState

Property Value
Description For internal use only.
DisplayName Component State
IsValidForForm False
IsValidForRead True
LogicalName componentstate
RequiredLevel SystemRequired
Type Picklist
DefaultFormValue
GlobalChoiceName componentstate

ComponentState Choices/Options

Value Label
0 Published
1 Unpublished
2 Deleted
3 Deleted Unpublished

CreatedBy

Property Value
Description Unique identifier of the user who created the condition.
DisplayName Created By
IsValidForForm False
IsValidForRead True
LogicalName createdby
RequiredLevel None
Type Lookup
Targets systemuser

CreatedOn

Property Value
Description Date and time when the condition was created.
DisplayName Created On
IsValidForForm False
IsValidForRead True
LogicalName createdon
RequiredLevel SystemRequired
Type DateTime
CanChangeDateTimeBehavior False
DateTimeBehavior UserLocal
Format DateAndTime
ImeMode Inactive
SourceTypeMask 0

CreatedOnBehalfBy

Property Value
Description Unique identifier of the delegate user who created the duplicate rule condition.
DisplayName Created By (Delegate)
IsValidForForm False
IsValidForRead True
LogicalName createdonbehalfby
RequiredLevel None
Type Lookup
Targets systemuser

IsManaged

Property Value
Description Indicates whether the solution component is part of a managed solution.
DisplayName Is Managed
IsValidForForm False
IsValidForRead True
LogicalName ismanaged
RequiredLevel SystemRequired
Type Boolean
GlobalChoiceName ismanaged
DefaultValue False
True Label Managed
False Label Unmanaged

ModifiedBy

Property Value
Description Unique identifier of the user who last modified the condition.
DisplayName Modified By
IsValidForForm False
IsValidForRead True
LogicalName modifiedby
RequiredLevel None
Type Lookup
Targets systemuser

ModifiedOn

Property Value
Description Date and time when the condition was last modified.
DisplayName Modified On
IsValidForForm True
IsValidForRead True
LogicalName modifiedon
RequiredLevel SystemRequired
Type DateTime
CanChangeDateTimeBehavior False
DateTimeBehavior UserLocal
Format DateAndTime
ImeMode Inactive
SourceTypeMask 0

ModifiedOnBehalfBy

Property Value
Description Unique identifier of the delegate user who last modified the duplicate rule condition.
DisplayName Modified By (Delegate)
IsValidForForm False
IsValidForRead True
LogicalName modifiedonbehalfby
RequiredLevel None
Type Lookup
Targets systemuser

OverwriteTime

Property Value
Description For internal use only.
DisplayName Record Overwrite Time
IsValidForForm False
IsValidForRead True
LogicalName overwritetime
RequiredLevel SystemRequired
Type DateTime
CanChangeDateTimeBehavior False
DateTimeBehavior UserLocal
Format DateAndTime
ImeMode Inactive
SourceTypeMask 0

OwnerId

Property Value
Description Unique identifier of the user or team who owns the duplicate rule condition.
DisplayName Owner
IsValidForForm False
IsValidForRead True
LogicalName ownerid
RequiredLevel ApplicationRequired
Type Owner
Targets systemuser, team

OwnerIdType

Property Value
Description
DisplayName
IsValidForForm False
IsValidForRead True
LogicalName owneridtype
RequiredLevel SystemRequired
Type EntityName

OwningBusinessUnit

Property Value
Description Unique identifier of the business unit that owns the condition.
DisplayName Owning Business Unit
IsValidForForm False
IsValidForRead True
LogicalName owningbusinessunit
RequiredLevel ApplicationRequired
Type Uniqueidentifier

OwningUser

Property Value
Description Unique identifier of the user who owns the condition.
DisplayName Owning User
IsValidForForm False
IsValidForRead True
LogicalName owninguser
RequiredLevel ApplicationRequired
Type Uniqueidentifier

SolutionId

Property Value
Description Unique identifier of the associated solution.
DisplayName Solution
IsValidForForm False
IsValidForRead True
LogicalName solutionid
RequiredLevel SystemRequired
Type Uniqueidentifier

SupportingSolutionId

Property Value
Description For internal use only.
DisplayName Solution
IsValidForForm False
IsValidForRead False
LogicalName supportingsolutionid
RequiredLevel None
Type Uniqueidentifier

Many-to-One relationships

These relationships are many-to-one. Listed by SchemaName.

DuplicateRule_DuplicateRuleConditions

One-To-Many Relationship: duplicaterule DuplicateRule_DuplicateRuleConditions

Property Value
ReferencedEntity duplicaterule
ReferencedAttribute duplicateruleid
ReferencingAttribute regardingobjectid
ReferencingEntityNavigationPropertyName regardingobjectid
IsHierarchical
CascadeConfiguration Archive: NoCascade
Assign: NoCascade
Delete: Cascade
Merge: NoCascade
Reparent: NoCascade
RollupView: NoCascade
Share: NoCascade
Unshare: NoCascade

lk_duplicaterulecondition_createdonbehalfby

One-To-Many Relationship: systemuser lk_duplicaterulecondition_createdonbehalfby

Property Value
ReferencedEntity systemuser
ReferencedAttribute systemuserid
ReferencingAttribute createdonbehalfby
ReferencingEntityNavigationPropertyName createdonbehalfby
IsHierarchical
CascadeConfiguration Archive: NoCascade
Assign: NoCascade
Delete: NoCascade
Merge: NoCascade
Reparent: NoCascade
RollupView: NoCascade
Share: NoCascade
Unshare: NoCascade

lk_duplicaterulecondition_modifiedonbehalfby

One-To-Many Relationship: systemuser lk_duplicaterulecondition_modifiedonbehalfby

Property Value
ReferencedEntity systemuser
ReferencedAttribute systemuserid
ReferencingAttribute modifiedonbehalfby
ReferencingEntityNavigationPropertyName modifiedonbehalfby
IsHierarchical
CascadeConfiguration Archive: NoCascade
Assign: NoCascade
Delete: NoCascade
Merge: NoCascade
Reparent: NoCascade
RollupView: NoCascade
Share: NoCascade
Unshare: NoCascade

lk_duplicateruleconditionbase_createdby

One-To-Many Relationship: systemuser lk_duplicateruleconditionbase_createdby

Property Value
ReferencedEntity systemuser
ReferencedAttribute systemuserid
ReferencingAttribute createdby
ReferencingEntityNavigationPropertyName createdby
IsHierarchical
CascadeConfiguration Archive: NoCascade
Assign: NoCascade
Delete: NoCascade
Merge: NoCascade
Reparent: NoCascade
RollupView: NoCascade
Share: NoCascade
Unshare: NoCascade

lk_duplicateruleconditionbase_modifiedby

One-To-Many Relationship: systemuser lk_duplicateruleconditionbase_modifiedby

Property Value
ReferencedEntity systemuser
ReferencedAttribute systemuserid
ReferencingAttribute modifiedby
ReferencingEntityNavigationPropertyName modifiedby
IsHierarchical
CascadeConfiguration Archive: NoCascade
Assign: NoCascade
Delete: NoCascade
Merge: NoCascade
Reparent: NoCascade
RollupView: NoCascade
Share: NoCascade
Unshare: NoCascade

One-to-Many relationships

These relationships are one-to-many. Listed by SchemaName.

DuplicateRuleCondition_SyncErrors

Many-To-One Relationship: syncerror DuplicateRuleCondition_SyncErrors

Property Value
ReferencingEntity syncerror
ReferencingAttribute regardingobjectid
ReferencedEntityNavigationPropertyName DuplicateRuleCondition_SyncErrors
IsCustomizable True
AssociatedMenuConfiguration AvailableOffline: True
Behavior: DoNotDisplay
Group: Details
Label:
MenuId: null
Order:
QueryApi: null
ViewId: 00000000-0000-0000-0000-000000000000

See also

Dataverse table/entity reference
Dataverse Web API Reference
duplicaterulecondition