SQL Object Tool
The SQL Object Tool enables users to manipulate the database directly from the PIA.
Navigation: Manage GT eForms 3.0 > GT Utilities > SQL Object Tool
With the SQL Object Tool, we can select from a list of SQL objects from a Lookup Table by selecting the magnifying lens located to the right of the field named SQL Name.
Using the SQL Object Tool
| Field | Value/Use |
|---|---|
| SQL Name | Used to insert SQL objects from a lookup table |
| SQL Text | Use this text box to enter SQL commands to call data tables and manipulate the data structures and entries to the database |
| SQL Bind Variable | This tool is used in conjunction with text entered into the SQL commands. The Bind Variable field is used to exchange values entered into the SQL Text box with alternative definitions without changing the SQL Name definition. |
| Run SQL | Runs the current SQL object in the text field |
| Clear SQL | Clears all SQL code in the SQL Text |
| Save SQL | Stores SQL as a new entry in the Lookup Table for future use |
| Fetch All/Fetch Rows | The user can select between “Fetch All” or “Fetch Rows” for the display to limit how many rows will be displayed on the view that generates when the RUN SQL button is clicked |
| SQL View Option | SQL View Option allows the user to select between the Grid or Table view |
SQL Name Lookup
The Look Up table will pop up when you click the magnifying lens. This Look Up allows results to be limited by the user to quickly find an existing SQL object. This option can be enabled by selecting from a drop-down list at the top.
| Field | Value/Use |
|---|---|
| Search By | User chooses from Last Update User ID, Object Owner ID, SQL Name, and SQL Object Type to personalize the search |
| Look Up | Searches with the given parameters entered by the user in the search by field |
| Cancel | Closes the Lookup window and takes the user back to the SQL Object Tool |
| SQL Name | Name of the SQL Object |
| Last Update User ID | The latest user that has updated the SQL object |
| Object Owner ID | A Particular group for which the SQL Object references |