Vault Navigator

The Vault Navigator is available in the VQL view, to the left of the dqMan screen. You can open or close it using the Vault Navigator from the View menu or by using the Navigator button on the toolbar.

The Vault Navigator displays the document types and objects hierarchy, the favorites tree and the local tables.

Whenever a tree item is expanded, the appropriate data is fetched dynamically from the vault. Therefore, you can easily update a part of the tree by collapsing and re-expanding the parent object.

Objects

The Objects tab allows users to navigate through the available document types hierarchy (under Base Document node) and the objects hierarchy (under Vault Objects).

Create a VQL query on the fly Click the desired node in the Vault Navigator to create a VQL query for the object contents, placed in the VQL command input area without executing it. The query is created using the Default Query Template that you can modify in the Options dialog box.

View the folder content Center mouse click to create a VQL similar to the above, but automatically executed.

Context menu Right-click a object to open the context menu:

Favorites Panel

Load a favorite query Click a favorite to load the VQL query of the favorite into the VQL command input area without executing it. To execute it, use the center mouse button.

Context menu Right-click a favorite to open the context menu with the following options:

Local Tables

This view displays and allows all user-created local tables to be managed.

Local tables are usually created for caching the data in a local database engine and can be queried later by using a more advanced syntax (GROUP BY, HAVING, MAX, MIN, COUNT, etc). This reduces repeated calls to Veeva Vault for working with data which is not expected to change frequently and can be cached locally, for example for development and testing purposes.

For more information about creating and querying local tables see querying local tables.