Drainage and Utilities CONNECT Edition Help

Queries Manager

The Queries manager is a docking manager that displays all queries in the current hydraulic model, including predefined, shared, and hydraulic model queries. You can create, edit, or delete shared and hydraulic model queries from within the Queries Manager, as well as use it to select all elements in your model that are part of the selected query.

To open the Queries manager, click the View menu and select the Queries command, press <Ctrl+5>, or click the Queries button

on the View toolbar.

The Queries manager consists of a toolbar and a tree view, which displays all of the queries that are associated with the current hydraulic model.

The toolbar contains the following icons:



New
Contains the following commands: Query —Creates a new SQL expression as either a hydraulic model or shared query, depending on which item is highlighted in the tree view. Folder —Creates a folder in the tree view, allowing you to group queries. You can right-click a folder and create queries or folders in that folder.


Delete
Deletes the currently-highlighted query or folder from the tree view. When you delete a folder, you also delete all of the queries it contains.


Rename
Renames the query or folder that is currently highlighted in the tree view.


Edit
Opens the Query Builder dialog box, allowing you to edit the SQL expression that makes up the currently-highlighted query.


Expand All
Opens all the Queries within all of the folders.


Collapse All
Closes all the Query folders.


Select in Drawing
Opens a submenu containing the following options: Select in Drawing —Selects the element or elements that satisfy the currently highlighted query. Add to Current Selection —Adds the element or elements that satisfy the currently highlighted query to the group of elements that are currently selected in the Drawing Pane. Remove from Current Selection —Removes the element or elements that satisfy the currently highlighted query from the group of elements that are currently selected in the Drawing Pane. Select Within Current Selection —Selects the element or elements that both satisfy the current query and are already selected in the Drawing Pane.


Help
Displays online help for the Query Manager.