ODBC Driver for Veeva Vault

Build 20.0.7587

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.

Copyright (c) 2020 CData Software, Inc. - All rights reserved.
Build 20.0.7587