ObjectWorkflows
Retrieve the workflows of an object or the workflows of an user.
View Specific Information
Note: This View is deprecated, use GetObjectWorkflows stored procedure instead.
ObjectName and RecordId or UserId must be specified in order to query this view.
Note: In this provider vault objects are exposed as separate entities. And the keys of these entities corresponds to RecordId here.
The add-in will use the Vault CRM API to process WHERE clause conditions built with the following columns and operators. The rest of the filter is executed client-side within the add-in.
- 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. |