Clicking CNAV Tools, Table Tool provides you with access to raw CNAV data as stored in table form. To view (and possibly subsequently manipulate) the data within a specific CNAV table, select the table from the provided drop-down list and click Select Table.
Taken together, the initial Table Tool screen and the resulting Table/View Information screen allow you to specify a standard SELECT statement having the form:
SELECT table-name
FROM column-name1, column-name2, etc.
WHERE conditions listed apply.
On the initial Table Tool screen, you input the SELECT table-name portion of this command when you selected the target table from the provided drop-down list. To complete the rest of the command, enter the following information:
Select columns FROM drop-down: Use the provided drop-down list to complete the FROM clause of your SELECT statement. To select multiple columns, Control-Click.
Enter WHERE clause: Type in the WHERE conditions you wish to execute for this SELECT statement. Please note that the WHERE is provided by CNAV. Therefore, do NOT type WHERE in your entry. If you do type WHERE, CNAV will return a database error.
Save WHERE clause: Tick this checkbox to save the WHERE clause you entered for the duration of this Table Tool session. If you do not tick this checkbox, when you click Back to return to this screen after viewing the results of this SELECT statement, the WHERE clause entry field will be empty. Using this checkbox allows you to repeatedly return to a modify a complex WHERE statement with minimal typing.
NOTE:
Saving the WHERE clause has effect only for the duration of this Table Tool session. You cannot use this option to save a WHERE clause that you wish to reuse on a continuing basis. For example, if you wish to dump the data in a specific CNAV table each month, you cannot save the WHERE clause here to re-execute next month. In these cases, we suggest that you devise an internal policy for recording and saving the required SELECT statement to be re-input as needed.
Enter description if saving: Use this comment field to enter a short, but useful, description of the WHERE clause you are saving for this Table Tool session.
Select output destination: Tick the appropriate option button to tell CNAV where you wish it to display the results of this SELECT statement. Your options are:
Display and modify data on screen: Use this option to display the results on the screen for immediate review and/or modification.
Save as Microsoft Excel ™ spreadsheet: Use this option to output the results directly into a Microsoft Excel spreadsheet file. If you browser is currently configured for Excel, the file will immediately be opened for use.
Save as CSV formatted file: Use this option to output the results in comma-separated value form for manipulation within another program (such as a data base).
After entering all required information, click Select Columns to execute the completed SELECT statement.
Usage Example:
To return the actual name of a CNAV user for whom you know only the member ID, use the Table Tool as follows:
Select MEMBER as the table from the drop-down list.
Click Select Table.
Control-click to select CNAV_MEMBER_ID and DISPLAY_NAME as the FROM columns.
At Enter WHERE clause, enter the following text:
CNAV_MEMBER_ID=id-number
e.g. CNAV_MEMBER_ID=1145699
Accept the default output destination (on screen).
Click Select Columns.