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 |
|
||||||
|
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). |
||||||
|
Close |
Closes the SQL dialog without running or saving the SQL query. |