6.2 Query

As part of developing your project solution, you might want to execute some database (DB) queries from your AquaScripts. The Query tab provides a convenient mechanism for ensuring proper DB connectivity and entering, editing and executing queries for debugging purposes. Prior to using the Query tab, you must register your DB servers in the Servers tab. On this page:

• Pick a Server
• Execute a Query

Keep in mind that working with MongoDB requires that queries be written using MongoSQL. A full description and guide for writing MongoSQL queries can be found in our MongoDB Query Reference.

Pick a Server

Pick a server against which to execute your query. The servers listed are those which have been added within the Servers tab.

After choosing a server, the Query tab will attempt to establish a connection with the DB Server. If a database connection cannot be made, an error message will be displayed. If you receive an error message, please go back to your Servers tab and correct your server's settings. For example, in the screenshot below, clicking on the Northwind connection launches a Query editor for that server. The Query Editor immediately displays a warning message that it could not establish a connection because the login failed. This indicates that the Northwind registered server's login information needs to be corrected before a query can be successfully executed.

Execute a Query

For a valid DB connection, the query window will be opened and queries can be entered in the SQL Editor and executed by pressing the Execute  button in the action bar. Below is an example of a SQL query executed inside the Query Editor and its output. The server connection is to a SQL 2000 Northwind database.

The Execute button executes the entered query. Tip: Keyboard shortcut: Ctrl + E

The Database drop-down list shows all databases residing on the selected server and allows the selecting of a different database for which the the query can be executed.

The Max Results input field limits the number of rows displayed in the Results pane.

Correcting the connection properties by editing this server in the Servers tab, specifically the Login information, allows us to successfully launch the Query Editor without warnings.