LegacyWorkflows
Retrieve all current, cancelled, and completed workflow instances for a specific object record or all workflows available to a particular workflow participant.
Columns
| Name | Type | Description |
| workflow_id__v | String | workflow_id__v |
| workflow_process_version__v | Decimal | workflow_process_version__v |
| workflow_name__v | String | workflow_name__v |
| workflow_initiator__v | String | workflow_initiator__v |
| workflow_status__v | String | workflow_status__v |
| workflow_startDate__v | Datetime | workflow_startDate__v |
| workflow_completionDate__v | Datetime | workflow_completionDate__v |
| workflow_cancelationDate__v | Datetime | workflow_cancelationDate__v |
| workflow_duration__v | Decimal | workflow_duration__v |
| workflow_dueDate__v | Date | workflow_dueDate__v |
| workflow_type__v | String | workflow_type__v |
| workflow_document_major_version_number__v | Decimal | workflow_document_major_version_number__v |
| workflow_document_minor_version_number__v | Decimal | workflow_document_minor_version_number__v |
| workflow_process_instance_group__v | String | workflow_process_instance_group__v |
| task_id__v | String | task_id__v |
| task_name__v | String | task_name__v |
| task_assignee__v | String | task_assignee__v |
| task_delegate__v | String | task_delegate__v |
| task_queueGroup__v | String | task_queueGroup__v |
| task_status__v | String | task_status__v |
| task_verdict__v | String | task_verdict__v |
| task_capacity__v | String | task_capacity__v |
| task_creationDate__v | Datetime | task_creationDate__v |
| task_last_modified_date__v | Datetime | task_last_modified_date__v |
| task_assignmentDate__v | Datetime | task_assignmentDate__v |
| task_completionDate__v | Datetime | task_completionDate__v |
| task_cancelationDate__v | Datetime | task_cancelationDate__v |
| task_duration__v | Decimal | task_duration__v |
| task_dueDate__v | Date | task_dueDate__v |
| task_comment__v | String | task_comment__v |
| task_instructions__v | String | task_instructions__v |
| task_document_capacity__v | String | task_document_capacity__v |
| task_document_major_version_number__v | Decimal | task_document_major_version_number__v |
| task_document_minor_version_number__v | Decimal | task_document_minor_version_number__v |
| task_document_verdict_comment__v | String | task_document_verdict_comment__v |
| task_document_verdict_reason__v | String | task_document_verdict_reason__v |
| workflow_document_id__v | String | workflow_document_id__v |
| workflow_initiator_name__v | String | workflow_initiator_name__v |
| task_assignee_name__v | String | task_assignee_name__v |
Pseudo-Columns
Pseudo-column fields are used in the WHERE clause of SELECT statements and offer more granular control over the tuples that are returned from the data source.
| Name | Type | Description |
| ExternalIdColumn | String | Specifies the External Id column to be used for Update and Upsert operations. Should be set to an unique column different from Id |