Skip to main content
hamburger menu Created with Sketch.
Updates were made to the Support and Services ticketing processes. Click the link below the search bar for more information.

Search the Knowledge Base

How to Retrieve the Value of Document-Object Relationship Fields Through Vault VQL?

  • Updated

 

Question:

How to retrieve the value of document-object relationship fields through Vault VQL?

Answer:

Document-object relationship fields are the document fields that reference objects.

A query in VQL is different and depends on whether or not the field is a multiple-values field.

mceclip0.png

  • If the field is the single-value field, the field value can be retrieved by the form:  document_{field_name}__vr for standard objects or document_{field_name}__cr for custom objects in VQL.

    Example: SELECT document_department__cr.name__v FROM documents
  • If the field is the multiple-values field, the user needs to retrieve the value through the inner query in the VQL.

    Example: SELECT (SELECT name__v FROM document_department__cr) FROM documents

Related Documentation:

N/A   

Powered by Zendesk