Page Description

Use the Query Tool page to view the Copia data that matches your SQL-based search. You may not edit the information displayed on this page.

For more help, click one of the following links:

• Accessing this Page
• Performing SQL Searches
• Saving and Deleting Scripts

Accessing this Page

• Click the Administration menu button, click the Monitor button, and then click the Query Tool submenu link. You must have the necessary security permissions to access the Administration menu button and to view the Query Tool submenu link.

When you click the Administration menu button, Copia opens the main Administration menu, which contains administrative menu buttons, including the Monitor menu. To return to the main menu for Copia, click the Lab Tasks menu button.

[Return to Top]

1. To create your search parameters, you may enter them in the Enter SQL Query field using the Structured Query Language (SQL), or you may select a script from the drop-down list and click the Load button to enter the previously saved search in the Enter SQL Query field.
2. Click the schema link to view the database schema HTML for reference in a new tab or window in your browser.
3. Select either the Formatted Results or the Text Results option to set how Copia should display the matching results.
   • Formatted Results: Displays the results in a formatted table.
   • Text Results: Displays the results in a text format, which allows you to copy and paste the text into another program to review or manipulate the data.
4. Click the Time Conversion button to open the Time Converter dialog that allows you to convert the epoch date value to a time stamp or a time stamp into an epoch date value. Click the Convert To Epoch or Convert To Date button to put the time/date into the query in the desired format.
5. Click the Run Query button to perform the search. Click the Stop Processing button to stop the respective processing and return control to the user. This setting stops long-running queries that are not likely to finish in a relatively short time.
6. Copia displays the status of the query in green text below the search options and above the search results.
7. If you have the necessary security right, Copia displays the Unrestricted Query checkbox. Select this option to perform any query (not just "SELECT" commands) other than an "UPDATE," "DELETE," or "DROP" command. 
8. Use the sliders at the top left corner of the results to configure how many columns and rows Copia displays at a time.
9. Modify your query or load and run another script, if desired, or save the script to run at a later time. See "Saving and Deleting Scripts" below.

[Return to Top]

1. Once you have entered a search, you may save it as a script.
2. To save a script, click the Save button (or press the [Alt] [S] hotkey), and Copia prompts you to enter a name for the script in the Save Script pop-up window. Enter the name and click Save, or click Cancel to cancel the save operation.

When you save a script, Copia only saves the contents of the Enter SQL Query field and the script name. It does not save your selection for Formatted Results or Text Results.

3. Once you save a script, you may select it from the drop-down list to perform that SQL search again. See "Performing SQL Searches" above.
4. To delete a saved script, select the script in the drop-down list, and then press and hold the [Alt] and [Shift] keys while clicking the Delete button. You must press those keys in order to use the Delete button.

[Return to Top]

 © 2017 Orchard Software Corporation