Share
 
 

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 InfoAsset Manager 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. Alternatively drag and drop items from the tree view in the Explorer Window. Only networks of the same type (Collection, Distribution or Asset) may be selected.

Tip: When 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.

Note: 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.
Note: 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.

Parent topic: Using SQL

Related Information

Was this information helpful?