JDBC Driver for Veeva Vault

Build 20.0.7587

Lifecycles

Retrieve brief details for the available lifecycles.

View Specific Information

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.

  • Lifecycle supports the '=' operator.
  • Role supports the '=' operator.

For example, the following queries are processed server side:

SELECT * FROM Lifecycles WHERE lifecycle = 'draft_to_effective_lifecycle_supporting__c'
SELECT * FROM Lifecycles WHERE Role = 'qa__vs'

You can turn off client-side execution by setting SupportEnhancedSQL to false, in which case any search criteria that refers to other columns will result in unfiltered data being pushed.

Columns

Name Type Description
Lifecycle String Name of the lifecycle.
Role String Role of the user that can use the lifecycle.
AllowedUsers String Comma-separated list of names of the allowed users.
AllowedGroups String Comma-separated list of names of the allowed groups.
AllowedDefaultUsers String Comma-separated list of names of the default allowed users.
AllowedDefaultGroups String Comma-separated list of names of the default allowed groups.

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