SQL and stored queries

Topics in this section describe the SQL (Structured Query Language) used by InfoWorks WS Pro, and the database objects (stored queries) that can be used to save and reuse SQL queries.

Concept

About SQL in InfoWorks WS Pro

About stored queries

 

User interface

New Name - Stored Query Groups dialog

SQL dialog

SQL dialog - Grid page

SQL dialog - SQL page

SQL dialog - User Macros page

SQL Macro dialog

 

Procedures

Creating SQL queries

Saving SQL queries as stored queries

Selecting objects using a query

Including GIS data in SQL queries

Exporting SQL expressions

Viewing a SQL grid

Exporting SQL query results to a CSV file

 

Reference and examples

SQL for selecting objects

SQL for updating data

SQL syntax

SQL and array data

SQL and connected objects

SQL example: Critical pipes

SQL example: Validation