Επεξεργασία

Κοινή χρήση μέσω

Process Log (WorkflowLog) table/entity reference

  • Άρθρο

Log used to track process execution.

Messages

The following table lists the messages for the Process Log (WorkflowLog) 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 /workflowlogs
See Create		 Create records
Delete
Event: False		 DELETE /workflowlogs(workflowlogid)
See Delete		 Delete records
Retrieve
Event: False		 GET /workflowlogs(workflowlogid)
See Retrieve		 Retrieve records
RetrieveMultiple
Event: False		 GET /workflowlogs
See Query data		 Query data
Update
Event: False		 PATCH /workflowlogs(workflowlogid)
See Update		 Update records
Upsert
Event: False		 PATCH /workflowlogs(workflowlogid)
See Upsert a table row		 UpsertRequest

Properties

The following table lists selected properties for the Process Log (WorkflowLog) table.

Property Value
DisplayName Process Log
DisplayCollectionName Process Logs
SchemaName WorkflowLog
CollectionSchemaName WorkflowLogs
EntitySetName workflowlogs
LogicalName workflowlog
LogicalCollectionName workflowlogs
PrimaryIdAttribute workflowlogid
TableType Standard
OwnershipType None

Writable columns/attributes

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

ActivityName

Property Value
Description Name of the activity which the process step is currently processing.
DisplayName Activity Name
IsValidForForm True
IsValidForRead True
LogicalName activityname
RequiredLevel None
Type String
Format Text
FormatName Text
ImeMode Auto
IsLocalizable False
MaxLength 160

AsyncOperationId

Property Value
Description Unique identifier of the parent record.
DisplayName Parent record
IsValidForForm True
IsValidForRead True
LogicalName asyncoperationid
RequiredLevel SystemRequired
Type Lookup
Targets asyncoperation, processsession

ChildWorkflowInstanceId

Property Value
Description Unique identifier of the system job.
DisplayName Child Workflow System Job
IsValidForForm True
IsValidForRead True
LogicalName childworkflowinstanceid
RequiredLevel None
Type Lookup
Targets asyncoperation, processsession

ChildWorkflowInstanceObjectTypeCode

Property Value
Description Object Type Code of the entity that is associated with the child workflow.
DisplayName Entity
IsValidForForm False
IsValidForRead True
LogicalName childworkflowinstanceobjecttypecode
RequiredLevel None
Type EntityName

CompletedOn

Property Value
Description Date and time when the operation was completed.
DisplayName Completed On
IsValidForForm True
IsValidForRead True
LogicalName completedon
RequiredLevel None
Type DateTime
CanChangeDateTimeBehavior False
DateTimeBehavior UserLocal
Format DateAndTime
ImeMode Inactive
SourceTypeMask 0

Description

Property Value
Description Description of the process step.
DisplayName Step Description
IsValidForForm True
IsValidForRead True
LogicalName description
RequiredLevel None
Type Memo
Format Text
FormatName Text
ImeMode Auto
IsLocalizable False
MaxLength 100000

ErrorCode

Property Value
Description Error code related to process.
DisplayName Error Message
IsValidForForm True
IsValidForRead True
LogicalName errorcode
RequiredLevel None
Type Integer
MaxValue 2147483647
MinValue -2147483648

ErrorText

Property Value
Description The string representation of the error.
DisplayName ErrorText
IsValidForForm True
IsValidForRead True
LogicalName errortext
RequiredLevel None
Type String
Format Text
FormatName Text
ImeMode Auto
IsLocalizable False
MaxLength 1000

InteractionActivityResult

Property Value
Description String specifying the result of an interaction activity.
DisplayName Interaction Activity Result
IsValidForForm False
IsValidForRead True
LogicalName interactionactivityresult
RequiredLevel None
Type Memo
Format Text
FormatName Text
ImeMode Auto
IsLocalizable False
MaxLength 100000

IterationCount

Property Value
Description The iteration count for the action when in a do until loop.
DisplayName IterationCount
IsValidForForm True
IsValidForRead True
LogicalName iterationcount
RequiredLevel None
Type Integer
MaxValue 2147483647
MinValue -2147483648

Message

Property Value
Description Message related to process.
DisplayName Message
IsValidForForm True
IsValidForRead True
LogicalName message
RequiredLevel None
Type Memo
Format Text
FormatName Text
ImeMode Auto
IsLocalizable False
MaxLength 100000

ObjectTypeCode

Property Value
Description Type of entity with which the process is associated.
DisplayName Entity
IsValidForForm False
IsValidForRead True
LogicalName objecttypecode
RequiredLevel SystemRequired
Type EntityName

RegardingObjectId

Property Value
Description Unique identifier of the associated record.
DisplayName Regarding
IsValidForForm True
IsValidForRead True
LogicalName regardingobjectid
RequiredLevel None
Type Lookup
Targets

RegardingObjectTypeCode

Property Value
Description
DisplayName Regarding Object Type Code
IsValidForForm False
IsValidForRead True
LogicalName regardingobjecttypecode
RequiredLevel None
Type EntityName

RepetitionCount

Property Value
Description The count of repetitions of the action when in a loop.
DisplayName RepetitionCount
IsValidForForm True
IsValidForRead True
LogicalName repetitioncount
RequiredLevel None
Type Integer
MaxValue 2147483647
MinValue -2147483648

RepetitionId

Property Value
Description The string representation of the repetition and iteration / level of the action.
DisplayName RepetitionId
IsValidForForm True
IsValidForRead True
LogicalName repetitionid
RequiredLevel None
Type String
Format Text
FormatName Text
ImeMode Auto
IsLocalizable False
MaxLength 1000

StageName

Property Value
Description Name of the process stage.
DisplayName Process Stage
IsValidForForm True
IsValidForRead True
LogicalName stagename
RequiredLevel None
Type String
Format Text
FormatName Text
ImeMode Auto
IsLocalizable False
MaxLength 256

StartedOn

Property Value
Description Date and time when the operation was started.
DisplayName Started On
IsValidForForm True
IsValidForRead True
LogicalName startedon
RequiredLevel None
Type DateTime
CanChangeDateTimeBehavior False
DateTimeBehavior UserLocal
Format DateAndTime
ImeMode Inactive
SourceTypeMask 0

Status

Property Value
Description Status of the process step for which process log record has been created: In Progress, Successfully Completed, or Failed.
DisplayName Status
IsValidForForm False
IsValidForRead True
LogicalName status
RequiredLevel SystemRequired
Type Picklist
DefaultFormValue 1
GlobalChoiceName workflowlog_status

Status Choices/Options

Value Label
1 In Progress
2 Succeeded
3 Failed
4 Canceled
5 Waiting

StepName

Property Value
Description Name of the process step.
DisplayName Step Name
IsValidForForm True
IsValidForRead True
LogicalName stepname
RequiredLevel None
Type String
Format Text
FormatName Text
ImeMode Auto
IsLocalizable False
MaxLength 160

WorkflowLogId

Property Value
Description Unique identifier of the process log entry.
DisplayName Process Log
IsValidForForm False
IsValidForRead True
LogicalName workflowlogid
RequiredLevel SystemRequired
Type Uniqueidentifier

Read-only columns/attributes

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

CreatedBy

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

CreatedOn

Property Value
Description Date and time when the process log entry was created.
DisplayName Started On
IsValidForForm True
IsValidForRead True
LogicalName createdon
RequiredLevel None
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 process log.
DisplayName Created By (Delegate)
IsValidForForm True
IsValidForRead True
LogicalName createdonbehalfby
RequiredLevel None
Type Lookup
Targets systemuser

Duration

Property Value
Description Duration between completed on and started on, used by business process flow.
DisplayName Duration
IsValidForForm True
IsValidForRead True
LogicalName duration
RequiredLevel None
Type Integer
MaxValue 2147483647
MinValue -2147483648

Inputs

Property Value
Description Inputs required by the workflow step.
DisplayName Inputs
IsValidForForm True
IsValidForRead True
LogicalName inputs
RequiredLevel None
Type File
MaxSizeInKB 32768

Inputs_Name

Property Value
Description
DisplayName
IsValidForForm False
IsValidForRead True
LogicalName inputs_name
RequiredLevel None
Type String
Format Text
FormatName Text
ImeMode Disabled
IsLocalizable False
MaxLength 200

ModifiedBy

Property Value
Description Unique identifier of the user who last modified the process log entry.
DisplayName Modified By
IsValidForForm True
IsValidForRead True
LogicalName modifiedby
RequiredLevel SystemRequired
Type Lookup
Targets systemuser

ModifiedOn

Property Value
Description Date and time when the process log entry was last modified.
DisplayName Modified On
IsValidForForm True
IsValidForRead True
LogicalName modifiedon
RequiredLevel None
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 process log.
DisplayName Modified By (Delegate)
IsValidForForm True
IsValidForRead True
LogicalName modifiedonbehalfby
RequiredLevel None
Type Lookup
Targets systemuser

Outputs

Property Value
Description Outputs generated by the workflow step.
DisplayName Outputs
IsValidForForm True
IsValidForRead True
LogicalName outputs
RequiredLevel None
Type File
MaxSizeInKB 32768

Outputs_Name

Property Value
Description
DisplayName
IsValidForForm False
IsValidForRead True
LogicalName outputs_name
RequiredLevel None
Type String
Format Text
FormatName Text
ImeMode Disabled
IsLocalizable False
MaxLength 200

OwnerId

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

OwnerIdType

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

OwningBusinessUnit

Property Value
Description Unique identifier of the business unit that owns the process.
DisplayName Owning Business Unit
IsValidForForm False
IsValidForRead True
LogicalName owningbusinessunit
RequiredLevel None
Type Lookup
Targets businessunit

OwningTeam

Property Value
Description Unique identifier of the team who owns the process log.
DisplayName Owning Team
IsValidForForm False
IsValidForRead True
LogicalName owningteam
RequiredLevel None
Type Lookup
Targets team

OwningUser

Property Value
Description Unique identifier of the user who owns the process.
DisplayName Owning User
IsValidForForm False
IsValidForRead True
LogicalName owninguser
RequiredLevel None
Type Lookup
Targets systemuser

Many-to-One relationships

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

business_unit_workflowlogs

One-To-Many Relationship: businessunit business_unit_workflowlogs

Property Value
ReferencedEntity businessunit
ReferencedAttribute businessunitid
ReferencingAttribute owningbusinessunit
ReferencingEntityNavigationPropertyName owningbusinessunit
IsHierarchical
CascadeConfiguration Archive: NoCascade
Assign: NoCascade
Delete: NoCascade
Merge: NoCascade
Reparent: NoCascade
RollupView: NoCascade
Share: NoCascade
Unshare: NoCascade

FileAttachment_WorkflowLog_Inputs

One-To-Many Relationship: fileattachment FileAttachment_WorkflowLog_Inputs

Property Value
ReferencedEntity fileattachment
ReferencedAttribute fileattachmentid
ReferencingAttribute inputs
ReferencingEntityNavigationPropertyName inputs
IsHierarchical
CascadeConfiguration Archive: RemoveLink
Assign: NoCascade
Delete: RemoveLink
Merge: NoCascade
Reparent: NoCascade
RollupView: NoCascade
Share: NoCascade
Unshare: NoCascade

FileAttachment_WorkflowLog_Outputs

One-To-Many Relationship: fileattachment FileAttachment_WorkflowLog_Outputs

Property Value
ReferencedEntity fileattachment
ReferencedAttribute fileattachmentid
ReferencingAttribute outputs
ReferencingEntityNavigationPropertyName outputs
IsHierarchical
CascadeConfiguration Archive: RemoveLink
Assign: NoCascade
Delete: RemoveLink
Merge: NoCascade
Reparent: NoCascade
RollupView: NoCascade
Share: NoCascade
Unshare: NoCascade

lk_expiredprocess_workflowlogs

One-To-Many Relationship: expiredprocess lk_expiredprocess_workflowlogs

Property Value
ReferencedEntity expiredprocess
ReferencedAttribute businessprocessflowinstanceid
ReferencingAttribute asyncoperationid
ReferencingEntityNavigationPropertyName ExpiredProcess_asyncoperationid
IsHierarchical
CascadeConfiguration Archive: NoCascade
Assign: Cascade
Delete: Cascade
Merge: Cascade
Reparent: Cascade
RollupView: NoCascade
Share: Cascade
Unshare: Cascade

lk_newprocess_workflowlogs

One-To-Many Relationship: newprocess lk_newprocess_workflowlogs

Property Value
ReferencedEntity newprocess
ReferencedAttribute businessprocessflowinstanceid
ReferencingAttribute asyncoperationid
ReferencingEntityNavigationPropertyName NewProcess_asyncoperationid
IsHierarchical
CascadeConfiguration Archive: NoCascade
Assign: Cascade
Delete: Cascade
Merge: Cascade
Reparent: Cascade
RollupView: NoCascade
Share: Cascade
Unshare: Cascade

lk_translationprocess_workflowlogs

One-To-Many Relationship: translationprocess lk_translationprocess_workflowlogs

Property Value
ReferencedEntity translationprocess
ReferencedAttribute businessprocessflowinstanceid
ReferencingAttribute asyncoperationid
ReferencingEntityNavigationPropertyName TranslationProcess_asyncoperationid
IsHierarchical
CascadeConfiguration Archive: NoCascade
Assign: Cascade
Delete: Cascade
Merge: Cascade
Reparent: Cascade
RollupView: NoCascade
Share: Cascade
Unshare: Cascade

lk_workflowlog_asyncoperation_childworkflow

One-To-Many Relationship: asyncoperation lk_workflowlog_asyncoperation_childworkflow

Property Value
ReferencedEntity asyncoperation
ReferencedAttribute asyncoperationid
ReferencingAttribute childworkflowinstanceid
ReferencingEntityNavigationPropertyName childworkflowinstanceid_asyncoperation
IsHierarchical
CascadeConfiguration Archive: NoCascade
Assign: NoCascade
Delete: NoCascade
Merge: NoCascade
Reparent: NoCascade
RollupView: NoCascade
Share: NoCascade
Unshare: NoCascade

lk_workflowlog_asyncoperations

One-To-Many Relationship: asyncoperation lk_workflowlog_asyncoperations

Property Value
ReferencedEntity asyncoperation
ReferencedAttribute asyncoperationid
ReferencingAttribute asyncoperationid
ReferencingEntityNavigationPropertyName asyncoperationid_asyncoperation
IsHierarchical
CascadeConfiguration Archive: NoCascade
Assign: Cascade
Delete: Cascade
Merge: Cascade
Reparent: Cascade
RollupView: NoCascade
Share: Cascade
Unshare: Cascade

lk_workflowlog_createdby

One-To-Many Relationship: systemuser lk_workflowlog_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_workflowlog_createdonbehalfby

One-To-Many Relationship: systemuser lk_workflowlog_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_workflowlog_modifiedby

One-To-Many Relationship: systemuser lk_workflowlog_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

lk_workflowlog_modifiedonbehalfby

One-To-Many Relationship: systemuser lk_workflowlog_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_workflowlog_processsession

One-To-Many Relationship: processsession lk_workflowlog_processsession

Property Value
ReferencedEntity processsession
ReferencedAttribute processsessionid
ReferencingAttribute asyncoperationid
ReferencingEntityNavigationPropertyName asyncoperationid_processsession
IsHierarchical
CascadeConfiguration Archive: NoCascade
Assign: Cascade
Delete: Cascade
Merge: Cascade
Reparent: Cascade
RollupView: NoCascade
Share: Cascade
Unshare: Cascade

lk_workflowlog_processsession_childworkflow

One-To-Many Relationship: processsession lk_workflowlog_processsession_childworkflow

Property Value
ReferencedEntity processsession
ReferencedAttribute processsessionid
ReferencingAttribute childworkflowinstanceid
ReferencingEntityNavigationPropertyName childworkflowinstanceid_processsession
IsHierarchical
CascadeConfiguration Archive: NoCascade
Assign: NoCascade
Delete: NoCascade
Merge: NoCascade
Reparent: NoCascade
RollupView: NoCascade
Share: NoCascade
Unshare: NoCascade

team_workflowlog

One-To-Many Relationship: team team_workflowlog

Property Value
ReferencedEntity team
ReferencedAttribute teamid
ReferencingAttribute owningteam
ReferencingEntityNavigationPropertyName owningteam
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.

workflowlog_FileAttachments

Many-To-One Relationship: fileattachment workflowlog_FileAttachments

Property Value
ReferencingEntity fileattachment
ReferencingAttribute objectid
ReferencedEntityNavigationPropertyName workflowlog_FileAttachments
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
workflowlog