Customize dqMan Veeva Vault Edition

Go to the Extras menu>Options to adapt the features and functionalities of dqMan.

The last open category is saved when leaving the options dialog and restored on the next visit.

General

The General category has four subsections:

• Settings

• Login

• Favorites

• Documentation

Settings

Setting Name	What It Does
Open session at startup	Automatically opens a session window at start up. Select the start view from the Start with list.
Restore last executed query from history	Restores the last executed VQL query from the history.
Show toolbar	Displays the toolbar.
Show tabs for open windows	Displays an additional toolbar with buttons for all open windows.
Always open/update "Compare Objects" tab in background	Whether or not to bring the comparison window to the foreground when adding a new object.
Save History Data	Saves VQL and MDL history data on local disk for later use. History size limits the size to the selected value. This limit is valid per session window.
Autosize row heights	Auto resizes the cells in the history list to Max Rows lines, if multi-line commands are displayed.
Read Timeout (s)	Specifies the response reading timeout for the REST API request.
Session Timeout (s)	The keep_alive requests are executed at the specified interval.
API version	Select the API Version.

Login

Option	What It Does
Save login info	Saves the login information, either with or without password. If the option always show next unused login is activated, the login dialog initializes with the credentials used for the most recent login.
Order login history by	Sorts the displayed order of saved logins in the login history.
Edit history	Modify the saved logins in the login history.

Favorites

Object Functions and the VQL favorites are stored locally, therefore every instance of dqMan uses its own data. However, Favorites can be shared if the full paths to the shared favorite files are supplied. The XML files which contain the favorites and Object Functions (Favorites.xml) need to be copied to a network drive for sharing. If the shared files are not available, local versions will be used instead.

Documentation

You can add and manage links to documents, URLs or program files to the Documentation menu using the function bar:

Add documentation to the selected Job

Function Bar Element	What It Does
	Add item. When entering a URL or program file, type it into the cell manually.
	Delete the selected entry.
	Add a menu separator
	Move selected entry upwards
	Move selected entry downwards

The VQL Command View

Settings

Setting	What It Does
VQL syntax help	Enables syntax help for VQL commands and functions.
Auto indent	Indents the cursor in new lines. Leading tabs and spaces will be copied from the proceeding line.
Restore column order and width	If the names and number of columns are not changed, the VQL result list settings (column width, column order and visible columns) will not change if VQL queries are executed again.
Move focus to VQL Result List after query execution	Moves the focus to the VQL Result grid if the query was successfully executed; If cleared, the focus remains in the VQL area.
Autosize columns	Column widths are adapted to the length of the represented data, with the limitation defined in the Max. Characters field.
Autosize rows	Row heights are adapted to the maximum number of lines of repeating attributes, with the limitation defined in the Max. Rows field. This option does only apply if the VQL query contains repeating attributes and their values are separated by carriage return.
Results grid	Maximum number of rows load in the Results grid when executing a query. Over this limit the user is warned so he can decide if all rows will be loaded.
Cached objects records	The number of records per object that will be cached when object data is loaded in the Object Navigator
Separate repeating attributes	Values of repeating attributes can be separated by comma/semicolon/carriage return/tab/custom string.
Enclose single values with	Encloses values of repeating attributes with single/double quotes or with no character at all if nothing is selected.

Code Editor

Command	How It Affects
Font Name & Font size	You can change the font and its size.
Auto-complete	Auto-complete code completion. If disabled, use CTRL + Space for manual code completion.
Number of lines in code completion list	The autocomplete suggestions window displays the selected number of lines. If the list contains more than can fit, a scrollbar will be displayed.
Show Line Numbers	Displays or not the number of lines in the editor.
Show Line State	Displays or not the status of the lines in the editor.
Auto-complete Matching Pairs	Automatically completes the open bracket.

Code Editor: Grid Colors

Command	How It Affects Grid Colors
Highlight even lines (background)	Background color for even lines.
Marked lines (background)	Background color for marked rows.
Different columns (background)	Background color for cells with different content (from Compare data function)

Describe Options

When utilizing the "describe" command on an object or document, you have the option to select and display specific attributes of your preference in the results list.

The Vault Navigator

In the Vault Navigator, you can manage the Objects Hierarchy behavior.

Objects	What It Does
Autoformat queries	Generated queries from query templates get formatted automatically.
Query templates	Allows to configure the query templates for Document Types and for Vault Objects

The Script Views

Setting	What It Does
Clear script log at restart	Clears the script log area every time a script is executed.
Copy comments to script log	Copies comments in the script to the script log.
Add line numbers to script log	The line number of the command is added to the script log. If line numbers are stored, the context menu function Show command enables you to jump from any line in the log to the corresponding command in the script.
Synchronize log to file	Enables allows copying all log messages into a file. If selected, the user has to choose a target file every time a script is started. If an existing file is selected, the additional content will be appended to the existing file.
Log everything	Logs everything.
Log results only	Only logs results or error messages.
Log errors only	Only logs error messages.
Log nothing	Nothing is logged.
CSV format for query results	(Only valid for VQL script log) Results of VQL queries are logged in CSV format.
Fixed width for query results	(Only valid for VQL script log) Results of VQL queries are logged as lists with fixed width. If too long, the values can be truncated.
Next line	Color of the next script command to be executed (in debug mode only).
Error	Color of an incorrect script command (in debug mode only).