JDBC Driver for Vault CRM

Build 25.0.9434

WorkflowItemObjects

Contains item-level information about each document or object record associated with a unique instance of a workflow.

View-Specific Information

The active_workflow_item__sys and inactive_workflow_item__sys objects contain item-level information about each document or object record associated with a workflow. A single document or object record can only be in one workflow at a time, but it may be associated with multiple canceled or completed workflow instances. For example, cancelling a workflow associated with three documents would create three unique item instances in the inactive_workflow_item__sys object: one for each document. Starting and completing the same workflow would create another set of unique item instances, for a total of six unique item instances.

Columns

Name Type Description
Id [KEY] String The workflow instance Id.
Workflow String An object reference to the parent workflow__sys.
Type String The type of workflow item, either document__sys, document_version__sys, or object__sys.
Document String The document Id if type__sys is document__sys; otherwise, this value is null. When the workflow is started with unbound document versions, this field has a value, and document_version__sys is null.
DocumentVersion String The document Id if type__sys is document_version__sys; otherwise, this value is null. When the workflow is started with bound document versions, this field has a value, and document__sys is null.
ObjectName String The object record name if type__sys is object__sys, null otherwise.
ObjectRecordId String The object record Id if type__sys is object__sys; otherwise, this value is null.
IsActive Boolean By default, we retrieve data for both active and inactive workflow Item Objects. Set to true to retrieve only active workflow item objects, or set to False to retrieve only inactive workflow item objects.

Copyright (c) 2025 CData Software, Inc. - All rights reserved.
Build 25.0.9434