KnowledgeBaseRecord table/entity reference

Note

Unsure about table vs. entity? See Developers: Understand terminology in Microsoft Dataverse.

Metadata of knowledge base (KB) articles associated with Microsoft Dynamics 365 entities.

Messages

Message Web API Operation SDK class or method
Assign PATCH /knowledgebaserecords(knowledgebaserecordid)
Update ownerid property.
AssignRequest
Create POST /knowledgebaserecords
See Create
CreateRequest or
Create
Delete DELETE /knowledgebaserecords(knowledgebaserecordid)
See Delete
DeleteRequest or
Delete
GrantAccess GrantAccess GrantAccessRequest
ModifyAccess ModifyAccess ModifyAccessRequest
Retrieve GET /knowledgebaserecords(knowledgebaserecordid)
See Retrieve
RetrieveRequest or
Retrieve
RetrieveMultiple GET /knowledgebaserecords
See Query Data
RetrieveMultipleRequest or
RetrieveMultiple
RetrievePrincipalAccess RetrievePrincipalAccess RetrievePrincipalAccessRequest
RetrieveSharedPrincipalsAndAccess RetrieveSharedPrincipalsAndAccess RetrieveSharedPrincipalsAndAccessRequest
RevokeAccess RevokeAccess RevokeAccessRequest
SetState PATCH /knowledgebaserecords(knowledgebaserecordid)
Update statecode and statuscode properties.
SetStateRequest
Update PATCH /knowledgebaserecords(knowledgebaserecordid)
See Update
UpdateRequest or
Update

Properties

Property Value
CollectionSchemaName KnowledgeBaseRecords
DisplayCollectionName Knowledge Base Records
DisplayName Knowledge Base Record
EntitySetName knowledgebaserecords
IsBPFEntity False
LogicalCollectionName knowledgebaserecords
LogicalName knowledgebaserecord
OwnershipType OrganizationOwned
PrimaryIdAttribute knowledgebaserecordid
PrimaryNameAttribute title
SchemaName KnowledgeBaseRecord

Writable columns/attributes

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

KnowledgeBaseRecordId

Property Value
Description This field will be used to store the Unique ID of the associated Knowledge Base records
DisplayName ID
IsValidForForm False
IsValidForRead True
IsValidForUpdate False
LogicalName knowledgebaserecordid
RequiredLevel SystemRequired
Type Uniqueidentifier

PrivateUrl

Property Value
Description Shows the internal Parature service desk URL of the knowledge base records.
DisplayName Private URL
FormatName Url
IsLocalizable False
IsValidForForm True
IsValidForRead True
LogicalName privateurl
MaxLength 256
RequiredLevel ApplicationRequired
Type String

PublicUrl

Property Value
Description Shows the public Parature portal URL of the knowledge base records.
DisplayName Public URL
FormatName Url
IsLocalizable False
IsValidForForm True
IsValidForRead True
LogicalName publicurl
MaxLength 256
RequiredLevel None
Type String

TimeZoneRuleVersionNumber

Property Value
Description For internal use only.
DisplayName Time Zone Rule Version Number
Format None
IsValidForForm False
IsValidForRead True
LogicalName timezoneruleversionnumber
MaxValue 2147483647
MinValue -1
RequiredLevel None
Type Integer

Title

Property Value
Description Shows the title of the knowledge base (KB) Record.
DisplayName KB Record Title
FormatName TextArea
IsLocalizable False
IsValidForForm True
IsValidForRead True
LogicalName title
MaxLength 4000
RequiredLevel ApplicationRequired
Type String

TransactionCurrencyId

Property Value
Description Exchange rate for the currency associated with the Knowledge Base Record with respect to the base currency.
DisplayName Currency
IsValidForForm True
IsValidForRead True
LogicalName transactioncurrencyid
RequiredLevel None
Targets transactioncurrency
Type Lookup

UniqueId

Property Value
Description Shows the unique ID of the linked knowledge base (KB) article.
DisplayName Unique ID
FormatName Text
IsLocalizable False
IsValidForForm True
IsValidForRead True
IsValidForUpdate False
LogicalName uniqueid
MaxLength 256
RequiredLevel SystemRequired
Type String

Read-only columns/attributes

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

CreatedBy

Property Value
Description Unique identifier of the user who created the record.
DisplayName Created By
IsValidForForm True
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 SystemRequired
Type String

CreatedOn

Property Value
DateTimeBehavior UserLocal
Description Date and time when the record was created.
DisplayName Created On
Format DateAndTime
IsValidForForm True
IsValidForRead True
LogicalName createdon
RequiredLevel None
Type DateTime

CreatedOnBehalfBy

Property Value
Description Unique identifier of the delegate user who created the record.
DisplayName Created By (Delegate)
IsValidForForm True
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 SystemRequired
Type String

ExchangeRate

Property Value
Description Exchange rate for the currency associated with the knowledge base record with respect to the base currency.
DisplayName ExchangeRate
IsValidForForm True
IsValidForRead True
LogicalName exchangerate
MaxValue 100000000000
MinValue 0.000000000001
Precision 12
RequiredLevel None
Type Decimal

ModifiedBy

Property Value
Description Unique identifier of the user who modified the record.
DisplayName Modified By
IsValidForForm True
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 SystemRequired
Type String

ModifiedOn

Property Value
DateTimeBehavior UserLocal
Description Date and time when the record was modified.
DisplayName Modified On
Format DateAndTime
IsValidForForm True
IsValidForRead True
LogicalName modifiedon
RequiredLevel None
Type DateTime

ModifiedOnBehalfBy

Property Value
Description Unique identifier of the delegate user who modified the record.
DisplayName Modified By (Delegate)
IsValidForForm True
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 SystemRequired
Type String

OrganizationId

Property Value
Description Unique identifier for the organization
DisplayName Organization Id
IsValidForForm False
IsValidForRead True
LogicalName organizationid
RequiredLevel None
Targets organization
Type Lookup

OrganizationIdName

Property Value
Description
DisplayName
FormatName Text
IsLocalizable False
IsValidForForm False
IsValidForRead True
LogicalName organizationidname
MaxLength 100
RequiredLevel SystemRequired
Type String

TransactionCurrencyIdName

Property Value
Description
DisplayName
FormatName Text
IsLocalizable False
IsValidForForm False
IsValidForRead True
LogicalName transactioncurrencyidname
MaxLength 100
RequiredLevel None
Type String

VersionNumber

Property Value
Description
DisplayName
IsValidForForm False
IsValidForRead True
LogicalName versionnumber
MaxValue 9223372036854775807
MinValue -9223372036854775808
RequiredLevel None
Type BigInt

One-To-Many Relationships

Listed by SchemaName.

KnowledgeBaseRecord_ActivityPointers

Same as the KnowledgeBaseRecord_ActivityPointers many-to-one relationship for the activitypointer table/entity.

Property Value
ReferencingEntity activitypointer
ReferencingAttribute regardingobjectid
IsHierarchical False
IsCustomizable True
ReferencedEntityNavigationPropertyName KnowledgeBaseRecord_ActivityPointers
AssociatedMenuConfiguration Behavior: UseCollectionName
Group: Details
Label:
Order:
CascadeConfiguration Assign: NoCascade
Delete: RemoveLink
Merge: NoCascade
Reparent: NoCascade
Share: NoCascade
Unshare: NoCascade

KnowledgeBaseRecord_Appointments

Same as the KnowledgeBaseRecord_Appointments many-to-one relationship for the appointment table/entity.

Property Value
ReferencingEntity appointment
ReferencingAttribute regardingobjectid
IsHierarchical False
IsCustomizable True
ReferencedEntityNavigationPropertyName KnowledgeBaseRecord_Appointments
AssociatedMenuConfiguration Behavior: UseCollectionName
Group: Details
Label:
Order:
CascadeConfiguration Assign: NoCascade
Delete: Cascade
Merge: NoCascade
Reparent: NoCascade
Share: NoCascade
Unshare: NoCascade

KnowledgeBaseRecord_Emails

Same as the KnowledgeBaseRecord_Emails many-to-one relationship for the email table/entity.

Property Value
ReferencingEntity email
ReferencingAttribute regardingobjectid
IsHierarchical False
IsCustomizable True
ReferencedEntityNavigationPropertyName KnowledgeBaseRecord_Emails
AssociatedMenuConfiguration Behavior: UseCollectionName
Group: Details
Label:
Order:
CascadeConfiguration Assign: NoCascade
Delete: Cascade
Merge: NoCascade
Reparent: NoCascade
Share: NoCascade
Unshare: NoCascade

KnowledgeBaseRecord_Faxes

Same as the KnowledgeBaseRecord_Faxes many-to-one relationship for the fax table/entity.

Property Value
ReferencingEntity fax
ReferencingAttribute regardingobjectid
IsHierarchical False
IsCustomizable True
ReferencedEntityNavigationPropertyName KnowledgeBaseRecord_Faxes
AssociatedMenuConfiguration Behavior: UseCollectionName
Group: Details
Label:
Order:
CascadeConfiguration Assign: NoCascade
Delete: Cascade
Merge: NoCascade
Reparent: NoCascade
Share: NoCascade
Unshare: NoCascade

KnowledgeBaseRecord_Letters

Same as the KnowledgeBaseRecord_Letters many-to-one relationship for the letter table/entity.

Property Value
ReferencingEntity letter
ReferencingAttribute regardingobjectid
IsHierarchical False
IsCustomizable True
ReferencedEntityNavigationPropertyName KnowledgeBaseRecord_Letters
AssociatedMenuConfiguration Behavior: UseCollectionName
Group: Details
Label:
Order:
CascadeConfiguration Assign: NoCascade
Delete: Cascade
Merge: NoCascade
Reparent: NoCascade
Share: NoCascade
Unshare: NoCascade

KnowledgeBaseRecord_PhoneCalls

Same as the KnowledgeBaseRecord_PhoneCalls many-to-one relationship for the phonecall table/entity.

Property Value
ReferencingEntity phonecall
ReferencingAttribute regardingobjectid
IsHierarchical False
IsCustomizable True
ReferencedEntityNavigationPropertyName KnowledgeBaseRecord_PhoneCalls
AssociatedMenuConfiguration Behavior: UseCollectionName
Group: Details
Label:
Order:
CascadeConfiguration Assign: NoCascade
Delete: Cascade
Merge: NoCascade
Reparent: NoCascade
Share: NoCascade
Unshare: NoCascade

KnowledgeBaseRecord_Tasks

Same as the KnowledgeBaseRecord_Tasks many-to-one relationship for the task table/entity.

Property Value
ReferencingEntity task
ReferencingAttribute regardingobjectid
IsHierarchical False
IsCustomizable True
ReferencedEntityNavigationPropertyName KnowledgeBaseRecord_Tasks
AssociatedMenuConfiguration Behavior: UseCollectionName
Group: Details
Label:
Order:
CascadeConfiguration Assign: NoCascade
Delete: Cascade
Merge: NoCascade
Reparent: NoCascade
Share: NoCascade
Unshare: NoCascade

KnowledgeBaseRecord_RecurringAppointmentMasters

Same as the KnowledgeBaseRecord_RecurringAppointmentMasters many-to-one relationship for the recurringappointmentmaster table/entity.

Property Value
ReferencingEntity recurringappointmentmaster
ReferencingAttribute regardingobjectid
IsHierarchical False
IsCustomizable True
ReferencedEntityNavigationPropertyName KnowledgeBaseRecord_RecurringAppointmentMasters
AssociatedMenuConfiguration Behavior: UseCollectionName
Group: Details
Label:
Order:
CascadeConfiguration Assign: NoCascade
Delete: Cascade
Merge: NoCascade
Reparent: NoCascade
Share: NoCascade
Unshare: NoCascade

KnowledgeBaseRecord_SocialActivities

Same as the KnowledgeBaseRecord_SocialActivities many-to-one relationship for the socialactivity table/entity.

Property Value
ReferencingEntity socialactivity
ReferencingAttribute regardingobjectid
IsHierarchical False
IsCustomizable True
ReferencedEntityNavigationPropertyName KnowledgeBaseRecord_SocialActivities
AssociatedMenuConfiguration Behavior: UseCollectionName
Group: Details
Label:
Order:
CascadeConfiguration Assign: NoCascade
Delete: Cascade
Merge: NoCascade
Reparent: NoCascade
Share: NoCascade
Unshare: NoCascade

KnowledgeBaseRecord_connections1

Same as the KnowledgeBaseRecord_connections1 many-to-one relationship for the connection table/entity.

Property Value
ReferencingEntity connection
ReferencingAttribute record1id
IsHierarchical False
IsCustomizable True
ReferencedEntityNavigationPropertyName KnowledgeBaseRecord_connections1
AssociatedMenuConfiguration Behavior: UseCollectionName
Group: Details
Label:
Order: 100
CascadeConfiguration Assign: NoCascade
Delete: Cascade
Merge: NoCascade
Reparent: NoCascade
Share: NoCascade
Unshare: NoCascade

KnowledgeBaseRecord_connections2

Same as the KnowledgeBaseRecord_connections2 many-to-one relationship for the connection table/entity.

Property Value
ReferencingEntity connection
ReferencingAttribute record2id
IsHierarchical False
IsCustomizable True
ReferencedEntityNavigationPropertyName KnowledgeBaseRecord_connections2
AssociatedMenuConfiguration Behavior: UseCollectionName
Group: Details
Label:
Order:
CascadeConfiguration Assign: NoCascade
Delete: Cascade
Merge: NoCascade
Reparent: NoCascade
Share: NoCascade
Unshare: NoCascade

KnowledgeBaseRecord_DuplicateMatchingRecord

Same as the KnowledgeBaseRecord_DuplicateMatchingRecord many-to-one relationship for the duplicaterecord table/entity.

Property Value
ReferencingEntity duplicaterecord
ReferencingAttribute duplicaterecordid
IsHierarchical False
IsCustomizable True
ReferencedEntityNavigationPropertyName KnowledgeBaseRecord_DuplicateMatchingRecord
AssociatedMenuConfiguration Behavior: UseCollectionName
Group: Details
Label:
Order:
CascadeConfiguration Assign: NoCascade
Delete: Cascade
Merge: NoCascade
Reparent: NoCascade
Share: NoCascade
Unshare: NoCascade

KnowledgeBaseRecord_DuplicateBaseRecord

Same as the KnowledgeBaseRecord_DuplicateBaseRecord many-to-one relationship for the duplicaterecord table/entity.

Property Value
ReferencingEntity duplicaterecord
ReferencingAttribute baserecordid
IsHierarchical False
IsCustomizable True
ReferencedEntityNavigationPropertyName KnowledgeBaseRecord_DuplicateBaseRecord
AssociatedMenuConfiguration Behavior: UseCollectionName
Group: Details
Label:
Order:
CascadeConfiguration Assign: NoCascade
Delete: Cascade
Merge: NoCascade
Reparent: NoCascade
Share: NoCascade
Unshare: NoCascade

KnowledgeBaseRecord_Annotations

Same as the KnowledgeBaseRecord_Annotations many-to-one relationship for the annotation table/entity.

Property Value
ReferencingEntity annotation
ReferencingAttribute objectid
IsHierarchical False
IsCustomizable True
ReferencedEntityNavigationPropertyName KnowledgeBaseRecord_Annotations
AssociatedMenuConfiguration Behavior: UseCollectionName
Group: Details
Label:
Order:
CascadeConfiguration Assign: NoCascade
Delete: Cascade
Merge: NoCascade
Reparent: NoCascade
Share: NoCascade
Unshare: NoCascade

KnowledgeBaseRecord_AsyncOperations

Same as the KnowledgeBaseRecord_AsyncOperations many-to-one relationship for the asyncoperation table/entity.

Property Value
ReferencingEntity asyncoperation
ReferencingAttribute regardingobjectid
IsHierarchical False
IsCustomizable True
ReferencedEntityNavigationPropertyName KnowledgeBaseRecord_AsyncOperations
AssociatedMenuConfiguration Behavior: UseCollectionName
Group: Details
Label:
Order:
CascadeConfiguration Assign: NoCascade
Delete: NoCascade
Merge: NoCascade
Reparent: NoCascade
Share: NoCascade
Unshare: NoCascade

KnowledgeBaseRecord_ProcessSession

Same as the KnowledgeBaseRecord_ProcessSession many-to-one relationship for the processsession table/entity.

Property Value
ReferencingEntity processsession
ReferencingAttribute regardingobjectid
IsHierarchical False
IsCustomizable True
ReferencedEntityNavigationPropertyName KnowledgeBaseRecord_ProcessSession
AssociatedMenuConfiguration Behavior: UseCollectionName
Group: Details
Label:
Order:
CascadeConfiguration Assign: NoCascade
Delete: NoCascade
Merge: NoCascade
Reparent: NoCascade
Share: NoCascade
Unshare: NoCascade

KnowledgeBaseRecord_BulkDeleteFailures

Same as the KnowledgeBaseRecord_BulkDeleteFailures many-to-one relationship for the bulkdeletefailure table/entity.

Property Value
ReferencingEntity bulkdeletefailure
ReferencingAttribute regardingobjectid
IsHierarchical False
IsCustomizable True
ReferencedEntityNavigationPropertyName KnowledgeBaseRecord_BulkDeleteFailures
AssociatedMenuConfiguration Behavior: UseCollectionName
Group: Details
Label:
Order:
CascadeConfiguration Assign: NoCascade
Delete: Cascade
Merge: NoCascade
Reparent: NoCascade
Share: NoCascade
Unshare: NoCascade

KnowledgeBaseRecord_PrincipalObjectAttributeAccess

Same as the KnowledgeBaseRecord_PrincipalObjectAttributeAccess many-to-one relationship for the principalobjectattributeaccess table/entity.

Property Value
ReferencingEntity principalobjectattributeaccess
ReferencingAttribute objectid
IsHierarchical False
IsCustomizable True
ReferencedEntityNavigationPropertyName KnowledgeBaseRecord_PrincipalObjectAttributeAccess
AssociatedMenuConfiguration Behavior: UseCollectionName
Group: Details
Label:
Order:
CascadeConfiguration Assign: NoCascade
Delete: Cascade
Merge: NoCascade
Reparent: NoCascade
Share: NoCascade
Unshare: NoCascade

KnowledgeBaseRecord_SyncErrors

Same as the KnowledgeBaseRecord_SyncErrors many-to-one relationship for the syncerror table/entity.

Property Value
ReferencingEntity syncerror
ReferencingAttribute regardingobjectid
IsHierarchical False
IsCustomizable True
ReferencedEntityNavigationPropertyName KnowledgeBaseRecord_SyncErrors
AssociatedMenuConfiguration Behavior: DoNotDisplay
Group: Details
Label:
Order:
CascadeConfiguration Assign: Cascade
Delete: Cascade
Merge: Cascade
Reparent: Cascade
Share: Cascade
Unshare: Cascade

knowledgebaserecord_chats

Added by: Activities Patch Solution

Same as the knowledgebaserecord_chats many-to-one relationship for the chat table/entity.

Property Value
ReferencingEntity chat
ReferencingAttribute regardingobjectid
IsHierarchical False
IsCustomizable True
ReferencedEntityNavigationPropertyName knowledgebaserecord_chats
AssociatedMenuConfiguration Behavior: DoNotDisplay
Group: Details
Label:
Order:
CascadeConfiguration Assign: NoCascade
Delete: Cascade
Merge: NoCascade
Reparent: NoCascade
Share: NoCascade
Unshare: NoCascade

knowledgebaserecord_adx_inviteredemptions

Added by: Active Solution Solution

Same as the knowledgebaserecord_adx_inviteredemptions many-to-one relationship for the adx_inviteredemption table/entity.

Property Value
ReferencingEntity adx_inviteredemption
ReferencingAttribute regardingobjectid
IsHierarchical False
IsCustomizable True
ReferencedEntityNavigationPropertyName knowledgebaserecord_adx_inviteredemptions
AssociatedMenuConfiguration Behavior: DoNotDisplay
Group: Details
Label:
Order:
CascadeConfiguration Assign: NoCascade
Delete: Cascade
Merge: NoCascade
Reparent: NoCascade
Share: NoCascade
Unshare: NoCascade

knowledgebaserecord_adx_portalcomments

Added by: Active Solution Solution

Same as the knowledgebaserecord_adx_portalcomments many-to-one relationship for the adx_portalcomment table/entity.

Property Value
ReferencingEntity adx_portalcomment
ReferencingAttribute regardingobjectid
IsHierarchical False
IsCustomizable True
ReferencedEntityNavigationPropertyName knowledgebaserecord_adx_portalcomments
AssociatedMenuConfiguration Behavior: DoNotDisplay
Group: Details
Label:
Order:
CascadeConfiguration Assign: NoCascade
Delete: Cascade
Merge: NoCascade
Reparent: NoCascade
Share: NoCascade
Unshare: NoCascade

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_KnowledgeBaseRecord_createdby

See the lk_KnowledgeBaseRecord_createdby one-to-many relationship for the systemuser table/entity.

lk_KnowledgeBaseRecord_createdonbehalfby

See the lk_KnowledgeBaseRecord_createdonbehalfby one-to-many relationship for the systemuser table/entity.

lk_KnowledgeBaseRecord_modifiedby

See the lk_KnowledgeBaseRecord_modifiedby one-to-many relationship for the systemuser table/entity.

lk_KnowledgeBaseRecord_modifiedonbehalfby

See the lk_KnowledgeBaseRecord_modifiedonbehalfby one-to-many relationship for the systemuser table/entity.

organization_KnowledgeBaseRecord

See the organization_KnowledgeBaseRecord one-to-many relationship for the organization table/entity.

TransactionCurrency_KnowledgeBaseRecord

See the TransactionCurrency_KnowledgeBaseRecord one-to-many relationship for the transactioncurrency table/entity.

See also

Dataverse table/entity reference
Web API Reference
knowledgebaserecord EntityType