SQL dialog

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

The dialog is opened by selecting Selection | SQL select.

The dialog has three pages that allow you to:

create variables that can be re-used
build the SQL query
choose fields to be displayed and then display a grid showing the results of running the SQL query.

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

Item

Description

Pages

User Macros	Creates variables to represent specific values in the SQL 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 SQL query results.

Apply filter to current selection (check box)

If checked, applies the SQL query only to the currently selected network objects.

Open selection in grid view (check box)

If checked, displays the SQL query results in a grid.

This is similar to the functionality in the Grid tab (see table above) except that clicking this checkbox displays all the fields related to the SQL query result object type.

Test

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

Apply

Runs the SQL query but keeps the SQL dialog open.

Run

Runs the SQL query and then closes the SQL dialog.

Save

Available only for existing stored queries.

Saves the current SQL query to an existing stored query group.

Save As

Opens a standard dialog for creating new objects.

You can use this to save the current SQL query, as a stored query, to an existing stored query group.

You can also use this to save a copy of an existing stored query (with a different name).

Closes the SQL dialog without running or saving the SQL query.

SQL and stored queries