ObjectWorkflowTasks
Retrieve the workflows of an object or the workflows of an user.
View Specific Information
ObjectName and RecordId or AssigneeId must be specified in order to query this view.
Note: In this provider vault objects are exposed as views. And the keys of these views corresponds to RecordId.
The driver will use the Veeva Vault API to process WHERE clause conditions built with the following columns and operators. The rest of the filter is executed client-side within the driver.
- AssigneeId supports the '=' and 'IN' operators.
- ObjectName supports the '=' operator.
- RecordId supports the '=' operator.
- Status supports the '=' operator.
For example, the following queries are processed server-side:
Some query examples:
SELECT * FROM ObjectWorkflowTasks WHERE AssigneeId IN (SELECT id FROM Users)
SELECT * FROM ObjectWorkflowTasks WHERE AssigneeId IN ('1069977', '115731')
SELECT * FROM ObjectWorkflowTasks WHERE AssigneeId = '1069977'
SELECT * FROM ObjectWorkflowTasks WHERE AssigneeId = '349101' AND Status = 'completed__v'
SELECT * FROM ObjectWorkflowTasks WHERE ObjectName = 'product__v' AND RecordId = '00P000000000201'
Columns
| Name | Type | Description |
| Id [KEY] | String | Identifier of the workflow task. |
| WorkflowId | String | Identifier of the workflow the task is in. |
| Label | String | Label of the workflow task. |
| Status | String | Status of the workflow task. |
| Instructions | String | Instructions to follow. |
| CreatedDate | Datetime | Datetime when the task was created. |
| DueDate | Datetime | Datetime when the task is due. |
| AssignedDate | Datetime | Datetime when the task was assigned. |
| RecordId | String | Identifier of the record of the object. |
| ObjectName | String | Name of the object. Required if UserId not specified. |
| AssigneeId | String | Identifier of the user. Required if ObjectName not specified. |