SQL Queries

SQL queries can be used to:

• Select network objects according to criteria specified in the queries
• Analyse and extract individual values and statistics from time series database streams that are linked to objects in a network. This requires a time series expression to be part of the SQL query.
• Update network object data fields

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:
   • choose the type of object from which you wish to make your selection

   and/or

   • choose the spatial search type and layer type to be used in the search
   • build the query
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.