SQL Queries

SQL queries can be used to:

Objects can be selected on network object criteria and also by geographic location relative to other layer (GIS, network, or background network) objects. The selected objects can be viewed as a grid or used in other network operations. SQL queries can also be used in the creation of customised reports.

To select objects using a query:

  1. Choose SQL select from the Selection menu, or click the button from the Selection Toolbar.
  2. Create any variables you will need in the SQL query, using the User Macros tab.
  3. Click on the SQL Query tab to:
  4. Use the buttons at the bottom of the dialog to test, apply, run, save or close the query. See SQL Dialog for details.
Tip

Click the Save As button on the SQL Dialog to save the query in the database tree. Once the query has been saved, it can be run by dragging the Stored Query object from the Explorer Window into the GeoPlan Window.


Multiple queries can be run by dragging the Asset Group containing the queries into the GeoPlan Window. All Stored Queries in the group will be applied in alphabetical order.

If both spatial search select options and object type select options are defined in the query, the spatial search is carried out first; the main query using object type criteria is then carried out on the results of the spatial search.

For further details on using SQL Queries, see the Using SQL section.

Using SQL

Selecting Network Objects

SQL Dialog

SQL - User Macros Page

SQL - SQL Query Page

SQL - Grid Page

SQL Query View

Theory of Time Series Expressions