JDBC Driver for Veeva Vault

Build 22.0.8462

DocumentRelationships

Returns all relationships per each document.

View Specific Information

DocumentId, MajorVersion and MinorVersion must be specified in order to query this view. To find these values, you can execute the following query:

SELECT version_id FROM Documents
And version_id values are of this pattern: {DocumentId}_{MajorVersion}_{MinorVersion}

Some query examples:
SELECT * FROM DocumentRelationships WHERE SourceDocumentId = '122' AND MajorVersion = 1 AND MinorVersion = 0
SELECT * FROM DocumentRelationships WHERE SourceDocumentId = '101' AND MajorVersion = 0 AND MinorVersion = 1

Columns

Name Type Description
Id [KEY] Integer The Id of the relationship.
SourceDocumentId Integer Identifier of the source document.
TargetDocumentId Integer Identifier of the target document.
Type String Type of the relationship.
CreatedDate Datetime The datetime of when the relationship was created.
CreatedBy Integer Identifier of the user who created the relationship.
MajorVersion Integer Major version of the source document.
MinorVersion Integer Minor version of the source document.

Copyright (c) 2023 CData Software, Inc. - All rights reserved.
Build 22.0.8462