SQL Dialog

This dialog allows you to create an SQL query in order to select network objects.

The dialog has three tabs that let you:

You can also apply the query to the GeoPlan window. A query can be saved and re-run at any time.

Dialog description

The dialog has tabs for the following pages:

User Macros

Creates variables to represent specific values in the query. These are useful if you want to use the same variable in several places. You then only have to change the value of the variable once.

SQL

Builds the SQL query.

Grid

Selects fields for reporting and displays a grid of the query results.

The dialog has the following options:

Item

Description

Apply filter to current selection check box

If checked, the query is only applied to the currently selected network objects.

Open selection in Grid Window check box

If checked, the query results can be displayed in a grid. This is similar to the functionality in the Grid tab (see table above) except that all the fields related to the query result object type aredisplayed.

Test

Calculates the number of items that would be selected if the query were applied.

Apply

Runs the query but keeps the SQL dialog open.

Run

Runs the query and then closes the SQL dialog.

Save As / Save

Saves the current query in an SQL group in the database tree.

Close

Closes the SQL dialog without running or saving the query.

User Macros Page

SQL Page

Grid Page

SQL Queries

SQL Query View

Macro Dialog