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:
- create variables that can be re-used
- build the query
- choose fields to be displayed and then display a grid showing the results of running the query
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:
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. |
|
Builds the SQL query. |
|
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. |