Database Viewer
The Database Viewer provides direct access to Site data. Use it to select and display the data you want to work with, to generate and print custom reports, and to make the data available to other users by saving it in CSV or HTML format. To open a view, double-click its entry in the Console. To create a view, right-click an operation and choose Create Database View.
Vector AM is supplied with a range of customizable, pre-defined views that enable you to access your data right away, or you can use SQL (Structured Query Language) statements to create your own views to retrieve specific items of data.
To create a view:
1 Right-click an operation in the Console and choose Create Database view from the shortcut menu. The View Wizard is displayedClick Finish to close the Wizard and create the view.
To change the column order in a view:
1 Click and hold the mouse on the column you want to move, and, without releasing the mouse button, drag the column to its new location. A black vertical line is displayed indicating the column's position.
2 Drag the line to the new position and release the mouse button.
To resize columns in a view:
1 Position the mouse pointer over the right edge of the column you want to resize. The cursor changes to a double-arrow symbol.
2 Click and drag the edge of the column to the appropriate position, then release the mouse button.
To sort the records in a view:
Click on the heading of the column you want to use to order the table.
To select data for the view:
Click Details to show the Details view and modify the SQL Statement settings.
Related Topics
Selecting Data for the Database Viewer