Duplicate Rule Condition (DuplicateRuleCondition) table/entity reference
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 |
---|---|---|
Create Event: False |
POST /duplicateruleconditionsSee Create |
Create records |
Delete Event: False |
DELETE /duplicateruleconditions(duplicateruleconditionid)See Delete |
Delete records |
Retrieve Event: False |
GET /duplicateruleconditions(duplicateruleconditionid)See Retrieve |
Retrieve records |
RetrieveMultiple Event: False |
GET /duplicateruleconditionsSee 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
- DuplicateRuleConditionId
- IgnoreBlankValues
- IsCustomizable
- MatchingAttributeName
- OperatorCode
- OperatorParam
- RegardingObjectId
- UniqueRuleName
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
- ComponentState
- CreatedBy
- CreatedOn
- CreatedOnBehalfBy
- IsManaged
- ModifiedBy
- ModifiedOn
- ModifiedOnBehalfBy
- OverwriteTime
- OwnerId
- OwnerIdType
- OwningBusinessUnit
- OwningUser
- SolutionId
- SupportingSolutionId
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
- lk_duplicaterulecondition_createdonbehalfby
- lk_duplicaterulecondition_modifiedonbehalfby
- lk_duplicateruleconditionbase_createdby
- lk_duplicateruleconditionbase_modifiedby
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