Run Query Dialog
The Run Query dialog is used to perform cross network queries for networks.
A Stored Query is used to generate a grid or CSV file of values using explicit Select clauses or Group By clauses.
See SQL in InfoWorks ICM for further details.
The dialog is displayed when Run query across multiple networks is selected from the Tools menu.
Networks and groups box - browse for networks and / or groups. Alliteratively drag and drop items from the tree view in the Explorer Window.
TipWhen groups are selected, the Networks and groups dropbox will contain the networks within the groups rather than the groups themselves.
Stored query box - browse for a Stored Query or drag and drop the item from the tree view. To refer to a network by name or ID in a query, use network.id or network.name.
The purpose of this dialog being report generation only, it is important to note that all the networks specified in the Networks and group dropbox will be treated as read-only. This explains why assignment statements, such as SET (which sets values for fields in network objects) are not allowed in the stored query.
Cross network queries do not support scenarios. If a scenario is referenced by a query, the base network will be used.
Produce report - click on this button to initiate report generation.
