Previous Topic

Next Topic

Book Contents

Book Index

Viewing Charts in the Query Explorer

Once you have saved some charts, you can view these charts in the Query Explorer.

This provides a very simple and quick way of viewing all the charts you have developed.

Note: that you can see the date / time the chart was created in the system-generated footer. You can also see this information by changing the drop-down at the top of the panel to Details of Chart.

Refresh Data

Clicking on Refresh Data will rerun the query to refresh the chart with the current data . Note that you need to be signed onto the database this query runs against before you can do this. You can then click on Save to update the saved-chart with this more recent data.

This provides a powerful mechanism for developing reports, and having the result displayed in graphical format.

Refresh Data (against this database)

Normally, Refresh Data runs the chart-query against the database the chart was defined as using. You may wish to run the chart against a different database. Some circumstances in which you may wish to do this are:

When you click on Refresh Data (against this database), the chart-query will be run against the current database.

If you then right-click the chart and select Save, the chart details will be amended to have the chart database being the current database.

Show Data Values

This will show you the Data Values which are behind the chart.

Deploying Charts to other Users

Once you have developed a chart, you can send them to others users for them to view and run. All the information for a chart is contained in the chart (*.xcf) file. You can send this file to another user; once they have copied it into their AQT query directory, they will be able to see it in their Query Explorer window.

Favorites

You can define a chart file as a Favorite.

Advanced Query Tool
https://www.querytool.com
© 2023 Cardett Associates Ltd. All rights reserved.