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
https://aka.ms/ContentUserFeedback.
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:Submit and view feedback for