Query Explorer
The Database Explorer window can also be used to display your existing queries, saved-results and saved-charts. This can be done by clicking on the Queries button in the toolbar (or View > Queries).
A window such as the following is displayed:
Query Directory
This display shows the queries and saved-results within your Query directory. The Query directory is the default location for saved queries, and is set with Options > File Locations. Queries not within this directory structure will not be shown on this display.
Window Layout
The Query explorer has the following layout.
- the left panel gives you the sub-directories within your Query directory.
- the middle pane shows you the queries, saved-results and saved-charts within the directory selected in the left panel.
- the right panel shows your query text, query contents (right-click the query to select this) or chart details.
The Query Explorer will show you Queries (which have a file type of sql), Saved-Results (which have a file type of grd) or Saved-Charts (which have a file type of xcf). Files with other suffixes (ddl, txt etc) are not shown.
The drop-down list above the query-list allows you to select which types of files you wish to see.
What you can do
After selecting a query or saved-result:
- click on the Display button to display the data
- click on the Run SQL button to edit the SQL text in the Run SQL window
- click on the Query Builder button to edit the query in the Query Builder window
- click on the Export button to Export the data
- the buttons at the top of the middle-panel allow you to edit / rename or delete files
After selecting a saved-chart, you can right-click the chart for options. This will include:
- Refresh. This will refresh the chart with current data. AQT will rerun the query which provides the data for the chart; you need to be signed onto the database this query uses in order to refresh the chart.
- Save. If you have refreshed the chart, you can update the saved-chart with the current version of the chart.
- Save as. This allows you to save the chart with as a different file name. Note that you will not see this new file in the list-of-queries until you hit the Refresh button or hit F5.
- View / Edit chart in Chart window. This opens the chart in the Chart window. This allows you to manipulate or alter the chart.
- Print, Export. The options allow you to export or print the chart.
Notes
- This window displays all queries, irrespective of which database they were run against. If you try to display a query when you are connected to a different database, it may not run successfully.
- You cannot Display or Export a query that contains action SQL (such as Inserts, Updates etc). To run these, click on the Run SQL button then run them from there.