SQL Dialog

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

Time series expressions, which enable you to analysis and extract individual values and statistics from a linked TSD, can also be used in an SQL query.

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:

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.

Time series expressions