Navigation:  Query Builder >

Interface

 

The Query Builder may be loaded from within HGA in several ways:

Select Modules / Query Builder from the menu bar

Select the icon from the Main Toolbar.

Right-click on the Queries branch of the Project Tree (or any branch under it) you can select New Query... to launch the Query builder.

Right-click on a query in the Project Tree and select Edit Query... the Query Builder will open displaying the selected query.

 

The Query Builder tab is shown below and displays the options available for a General Query.

 

The Query Builder tab contains the following sections:

Available Fields: Select fields for the query from the tables in the database shown in the tree.

Display Fields: The fields in this section will be displayed when the query is executed.

Conditions: The fields in this section are used to set conditions for the query.

Toolbar: Contains buttons to most of the functions in the Query Builder.

Source Conditions: Provides options for adjusting the source for the query.

Group Conditions: Specifies grouping options when using an aggregate function.

SQL Statement: Allows user to generate their own custom SQL Statement (other sections will become inactive).

 

Please Note: The Display Fields and the Group Conditions sections are not available when creating a Dynamic Station Group or Sample Set query.

 

Query Toolbar Items

The toolbar provides access to most functions of the Query Builder. Toolbar buttons are context sensitive, if there a button is "greyed-out" this indicates that that functionality is not currently available (based on what has been selected).

 

New button creates a new query.

Open button opens an existing query.

Delete button deletes the currently open query.

Save Query button saves changes to the query.

Save As button saves the query under a new name.

Execute SQL Statement button executes/runs the current query.

 

Query Component Field Toolbar Items

The components of a query, including the Display Fields, Conditions, and Group Conditions have toolbars that help you construct the required components of a query.  Toolbar buttons are context sensitive, if there a button is "greyed-out" this indicates that that functionality is not currently available (based on what has been selected).

 

Adds a display field, condition, or group condition

Adds a sub-query (condition only)

Deletes button the currently selected display field(s), condition(s), or group condition(s).

Moves the currently selected display field, condition, or group condition up in the order of its list

Moves the currently selected display field, condition, or group condition down in the order of its list

 

Source Conditions

The Source Condition query component also includes the ability to restrict your results to a specific Project, Station, Group, Sample Set or the entire database:

 

The default condition is Project.

 

 


Page url:https://www.waterloohydrogeologic.com/help/hga/index.html?queries_interface.htm