ODBC Driver for Veeva Vault

Build 20.0.7587

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.

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