Database Screen

Objective:

Explain what a user is seeing on the Tools>Database Screen.

Rights Needed:

☒Admin ☒ Admin Lite ☐Well Admin ☐Well Control

☐Well Config ☐Well Config Lite ☐Read Only

Versions:

XSPOC: 3.1, 3.2

Purpose:

Familiarize the user with the XSPOC SQL Database Viewer.

Instruction:

1. Open XPOC Client
2. From the navigation panel locate and select the Tools Tab
3. Click Tools Tab > Database Icon
4. The database screen launches and displays the following:
5. At the top right of the screen is the SQL Icon button. Clicking this button opens a SQL Query window.
6. Just below the SQL Icon is the Filter section with the database tables listed below it.
7. Along the top of the screen is the SQL Query Window Tool Bar
   1. Red Exclamation Mark – executes the SQL statement
   2. Columns – dropdown list displaying all columns in the selected table
   3. SQL Arithmetic Operators
   4. SQL Logical Operators
8. Below the SQL tool bar is the SQL Query window.
9. Just below the SQL Query window, or at the top of the screen if the SQL query window is not open, is the table tool bar.
   1. Green Refresh icon
   2. Red cancel button
   3. Copy Icon
   4. Paste Icon
   5. Table Name
   6. On the far right is the Limit box
10. The selected table is displayed in the center of the screen
11. An up/down scroll bar is located at the far right of the screen
12. On the bottom right there are two window control icons.
    1. The lock icon allows the user to lock the screen.
    2. The arrow icon allows the use to float the window and move it to other screens or areas of the same computer screen.