ObjectWorkflows
Retrieve the workflows of an object or the workflows of an user.
View Specific Information
ObjectName and RecordId or UserId 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 here.
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.
- UserId 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 ObjectWorkflows WHERE UserId IN (SELECT id FROM Users)
SELECT * FROM ObjectWorkflows WHERE UserId IN ('1069977', '115731')
SELECT * FROM ObjectWorkflows WHERE UserId = '1069977'
SELECT * FROM ObjectWorkflows WHERE UserId = '349101' AND Status = 'completed__v'
SELECT * FROM ObjectWorkflows WHERE ObjectName = 'product__v' AND RecordId = '00P000000000201'
Columns
| Name | Type | Description |
| Id [KEY] | String | Identifier of the workflow. |
| Label | String | Label of the workflow. |
| Status | String | Status of the workflow. |
| Initiator | String | Identifier of the user who initiated the workflow. |
| StartedDate | Datetime | Datetime when the workflow started. |
| DueDate | Datetime | Datetime when the workflow is due. |
| CompletedDate | Datetime | Datetime when the workflow was completed. |
| RecordId | String | Identifier of the record of the object. |
| ObjectName | String | Name of the object. Required if UserId not specified. |
| UserId | String | Identifier of the user. Required if ObjectName not specified. |