DuplicateRuleCondition table/entity reference
Note
Unsure about table vs. entity? See Developers: Understand terminology in Microsoft Dataverse.
Condition of a duplicate detection rule.
Messages
| Message | Web API Operation | SDK class or method |
|---|---|---|
| CompoundUpdateDuplicateDetectionRule | CompoundUpdateDuplicateDetectionRule | CompoundUpdateDuplicateDetectionRuleRequest |
| Create | POST /duplicateruleconditions See Create |
CreateRequest or Create |
| Delete | DELETE /duplicateruleconditions(duplicateruleconditionid) See Delete |
DeleteRequest or Delete |
| Retrieve | GET /duplicateruleconditions(duplicateruleconditionid) See Retrieve |
RetrieveRequest or Retrieve |
| RetrieveMultiple | GET /duplicateruleconditions See Query Data |
RetrieveMultipleRequest or RetrieveMultiple |
| Update | PATCH /duplicateruleconditions(duplicateruleconditionid) See Update |
UpdateRequest or Update |
Properties
| Property | Value |
|---|---|
| CollectionSchemaName | DuplicateRuleConditions |
| DisplayCollectionName | Duplicate Rule Conditions |
| DisplayName | Duplicate Rule Condition |
| EntitySetName | duplicateruleconditions |
| IsBPFEntity | False |
| LogicalCollectionName | duplicateruleconditions |
| LogicalName | duplicaterulecondition |
| OwnershipType | None |
| PrimaryIdAttribute | duplicateruleconditionid |
| PrimaryNameAttribute | |
| SchemaName | DuplicateRuleCondition |
Writable columns/attributes
These columns/attributes return true for either IsValidForCreate or IsValidForUpdate (usually both). Listed by SchemaName.
- BaseAttributeName
- DuplicateRuleConditionId
- IgnoreBlankValues
- IsCustomizable
- MatchingAttributeName
- OperatorCode
- OperatorParam
- RegardingObjectId
- UniqueRuleName
BaseAttributeName
| Property | Value |
|---|---|
| Description | Field that is being compared. |
| DisplayName | Base Field |
| FormatName | Text |
| IsLocalizable | False |
| IsValidForForm | True |
| IsValidForRead | True |
| IsValidForUpdate | False |
| LogicalName | baseattributename |
| MaxLength | 128 |
| RequiredLevel | SystemRequired |
| Type | String |
DuplicateRuleConditionId
| Property | Value |
|---|---|
| Description | Unique identifier of the condition. |
| DisplayName | Duplicate Rule Condition |
| IsValidForForm | False |
| IsValidForRead | True |
| IsValidForUpdate | False |
| 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 |
IgnoreBlankValues Choices/Options
| Value | Label | Description |
|---|---|---|
| 1 | True | |
| 0 | False |
DefaultValue: 0
IsCustomizable
Added by: Basic Solution Solution
| 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 |
| FormatName | Text |
| IsLocalizable | False |
| IsValidForForm | True |
| IsValidForRead | True |
| IsValidForUpdate | False |
| LogicalName | matchingattributename |
| MaxLength | 128 |
| RequiredLevel | SystemRequired |
| Type | String |
OperatorCode
| Property | Value |
|---|---|
| Description | Operator for this rule condition. |
| DisplayName | Operator Code |
| IsValidForForm | True |
| IsValidForRead | True |
| IsValidForUpdate | False |
| LogicalName | operatorcode |
| RequiredLevel | SystemRequired |
| Type | Picklist |
OperatorCode Choices/Options
| Value | Label | Description |
|---|---|---|
| 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 |
| Format | None |
| IsValidForForm | True |
| IsValidForRead | True |
| LogicalName | operatorparam |
| MaxValue | 2147483647 |
| MinValue | 1 |
| RequiredLevel | None |
| Type | Integer |
RegardingObjectId
| Property | Value |
|---|---|
| Description | Unique identifier of the object with which the condition is associated. |
| DisplayName | Regarding |
| IsValidForForm | False |
| IsValidForRead | True |
| IsValidForUpdate | False |
| LogicalName | regardingobjectid |
| RequiredLevel | None |
| Targets | duplicaterule |
| Type | Lookup |
UniqueRuleName
Added by: msft_DupDetectionNewColumnsExtension Solution
| Property | Value |
|---|---|
| Description | |
| DisplayName | UniqueRuleName |
| FormatName | Text |
| IsLocalizable | False |
| IsValidForForm | True |
| IsValidForRead | True |
| IsValidForUpdate | False |
| LogicalName | uniquerulename |
| MaxLength | 100 |
| RequiredLevel | SystemRequired |
| Type | String |
Read-only columns/attributes
These columns/attributes return false for both IsValidForCreate or IsValidForUpdate. Listed by SchemaName.
- ComponentIdUnique
- ComponentState
- CreatedBy
- CreatedByName
- CreatedByYomiName
- CreatedOn
- CreatedOnBehalfBy
- CreatedOnBehalfByName
- CreatedOnBehalfByYomiName
- IsManaged
- ModifiedBy
- ModifiedByName
- ModifiedByYomiName
- ModifiedOn
- ModifiedOnBehalfBy
- ModifiedOnBehalfByName
- ModifiedOnBehalfByYomiName
- OverwriteTime
- OwnerId
- OwnerIdType
- OwningBusinessUnit
- OwningUser
- SolutionId
- SupportingSolutionId
ComponentIdUnique
Added by: Basic Solution Solution
| Property | Value |
|---|---|
| Description | For internal use only. |
| DisplayName | Row id unique |
| IsValidForForm | False |
| IsValidForRead | True |
| LogicalName | componentidunique |
| RequiredLevel | SystemRequired |
| Type | Uniqueidentifier |
ComponentState
Added by: Basic Solution Solution
| Property | Value |
|---|---|
| Description | For internal use only. |
| DisplayName | Component State |
| IsValidForForm | False |
| IsValidForRead | True |
| LogicalName | componentstate |
| RequiredLevel | SystemRequired |
| Type | Picklist |
ComponentState Choices/Options
| Value | Label | Description |
|---|---|---|
| 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 |
| Targets | systemuser |
| Type | Lookup |
CreatedByName
| Property | Value |
|---|---|
| Description | |
| DisplayName | |
| FormatName | Text |
| IsLocalizable | False |
| IsValidForForm | False |
| IsValidForRead | True |
| LogicalName | createdbyname |
| MaxLength | 100 |
| RequiredLevel | None |
| Type | String |
CreatedByYomiName
| Property | Value |
|---|---|
| Description | |
| DisplayName | |
| FormatName | Text |
| IsLocalizable | False |
| IsValidForForm | False |
| IsValidForRead | True |
| LogicalName | createdbyyominame |
| MaxLength | 100 |
| RequiredLevel | None |
| Type | String |
CreatedOn
| Property | Value |
|---|---|
| DateTimeBehavior | UserLocal |
| Description | Date and time when the condition was created. |
| DisplayName | Created On |
| Format | DateAndTime |
| IsValidForForm | False |
| IsValidForRead | True |
| LogicalName | createdon |
| RequiredLevel | SystemRequired |
| Type | DateTime |
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 |
| Targets | systemuser |
| Type | Lookup |
CreatedOnBehalfByName
| Property | Value |
|---|---|
| Description | |
| DisplayName | |
| FormatName | Text |
| IsLocalizable | False |
| IsValidForForm | False |
| IsValidForRead | True |
| LogicalName | createdonbehalfbyname |
| MaxLength | 100 |
| RequiredLevel | None |
| Type | String |
CreatedOnBehalfByYomiName
| Property | Value |
|---|---|
| Description | |
| DisplayName | |
| FormatName | Text |
| IsLocalizable | False |
| IsValidForForm | False |
| IsValidForRead | True |
| LogicalName | createdonbehalfbyyominame |
| MaxLength | 100 |
| RequiredLevel | None |
| Type | String |
IsManaged
Added by: Basic Solution Solution
| 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 |
IsManaged Choices/Options
| Value | Label | Description |
|---|---|---|
| 1 | Managed | |
| 0 | Unmanaged |
DefaultValue: 0
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 |
| Targets | systemuser |
| Type | Lookup |
ModifiedByName
| Property | Value |
|---|---|
| Description | |
| DisplayName | |
| FormatName | Text |
| IsLocalizable | False |
| IsValidForForm | False |
| IsValidForRead | True |
| LogicalName | modifiedbyname |
| MaxLength | 100 |
| RequiredLevel | None |
| Type | String |
ModifiedByYomiName
| Property | Value |
|---|---|
| Description | |
| DisplayName | |
| FormatName | Text |
| IsLocalizable | False |
| IsValidForForm | False |
| IsValidForRead | True |
| LogicalName | modifiedbyyominame |
| MaxLength | 100 |
| RequiredLevel | None |
| Type | String |
ModifiedOn
| Property | Value |
|---|---|
| DateTimeBehavior | UserLocal |
| Description | Date and time when the condition was last modified. |
| DisplayName | Modified On |
| Format | DateAndTime |
| IsValidForForm | True |
| IsValidForRead | True |
| LogicalName | modifiedon |
| RequiredLevel | SystemRequired |
| Type | DateTime |
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 |
| Targets | systemuser |
| Type | Lookup |
ModifiedOnBehalfByName
| Property | Value |
|---|---|
| Description | |
| DisplayName | |
| FormatName | Text |
| IsLocalizable | False |
| IsValidForForm | False |
| IsValidForRead | True |
| LogicalName | modifiedonbehalfbyname |
| MaxLength | 100 |
| RequiredLevel | None |
| Type | String |
ModifiedOnBehalfByYomiName
| Property | Value |
|---|---|
| Description | |
| DisplayName | |
| FormatName | Text |
| IsLocalizable | False |
| IsValidForForm | False |
| IsValidForRead | True |
| LogicalName | modifiedonbehalfbyyominame |
| MaxLength | 100 |
| RequiredLevel | None |
| Type | String |
OverwriteTime
Added by: Basic Solution Solution
| Property | Value |
|---|---|
| DateTimeBehavior | UserLocal |
| Description | For internal use only. |
| DisplayName | Record Overwrite Time |
| Format | DateAndTime |
| IsValidForForm | False |
| IsValidForRead | True |
| LogicalName | overwritetime |
| RequiredLevel | SystemRequired |
| Type | DateTime |
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 |
| Targets | systemuser,team |
| Type | Owner |
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
Added by: Basic Solution Solution
| Property | Value |
|---|---|
| Description | Unique identifier of the associated solution. |
| DisplayName | Solution |
| IsValidForForm | False |
| IsValidForRead | True |
| LogicalName | solutionid |
| RequiredLevel | SystemRequired |
| Type | Uniqueidentifier |
SupportingSolutionId
Added by: Basic Solution Solution
| Property | Value |
|---|---|
| Description | For internal use only. |
| DisplayName | Solution |
| IsValidForForm | False |
| IsValidForRead | False |
| LogicalName | supportingsolutionid |
| RequiredLevel | None |
| Type | Uniqueidentifier |
One-To-Many Relationships
Listed by SchemaName.
DuplicateRuleCondition_SyncErrors
Same as the DuplicateRuleCondition_SyncErrors many-to-one relationship for the syncerror table/entity.
| Property | Value |
|---|---|
| ReferencingEntity | syncerror |
| ReferencingAttribute | regardingobjectid |
| IsHierarchical | False |
| IsCustomizable | True |
| ReferencedEntityNavigationPropertyName | DuplicateRuleCondition_SyncErrors |
| AssociatedMenuConfiguration | Behavior: DoNotDisplay Group: Details Label: Order: |
| CascadeConfiguration | Assign: Cascade Delete: Cascade Merge: Cascade Reparent: Cascade Share: Cascade Unshare: Cascade |
Many-To-One Relationships
Each Many-To-One relationship is defined by a corresponding One-To-Many relationship with the related table. Listed by SchemaName.
- lk_duplicaterulecondition_createdonbehalfby
- DuplicateRule_DuplicateRuleConditions
- lk_duplicaterulecondition_modifiedonbehalfby
- lk_duplicateruleconditionbase_modifiedby
- lk_duplicateruleconditionbase_createdby
lk_duplicaterulecondition_createdonbehalfby
See the lk_duplicaterulecondition_createdonbehalfby one-to-many relationship for the systemuser table/entity.
DuplicateRule_DuplicateRuleConditions
See the DuplicateRule_DuplicateRuleConditions one-to-many relationship for the duplicaterule table/entity.
lk_duplicaterulecondition_modifiedonbehalfby
See the lk_duplicaterulecondition_modifiedonbehalfby one-to-many relationship for the systemuser table/entity.
lk_duplicateruleconditionbase_modifiedby
See the lk_duplicateruleconditionbase_modifiedby one-to-many relationship for the systemuser table/entity.
lk_duplicateruleconditionbase_createdby
See the lk_duplicateruleconditionbase_createdby one-to-many relationship for the systemuser table/entity.
See also
Dataverse table/entity reference
Web API Reference
duplicaterulecondition EntityType
Feedback
Coming soon: Throughout 2024 we will be phasing out GitHub Issues as the feedback mechanism for content and replacing it with a new feedback system. For more information see: https://aka.ms/ContentUserFeedback.
Submit and view feedback for