Bentley SewerGEMS CONNECT Edition Help

Queries Manager

The Queries Manager is a docking manager that displays all queries in the current model, including predefined, shared, and model queries. You can create, edit, or delete shared and 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.

Note that element types that are not used in the current model are marked with an icon

The Queries Manager consists of a toolbar and a tree view, which displays all of the queries that are associated with the current model. The toolbar contains the following buttons:

     
New Contains the following commands: Query —Lets you create a new SQL expression as either a 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 its contents (the queries it contains).
Rename Lets you rename 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 and Collapse All Expands or collapses the named views and folders.
Select in Drawing Lets you quickly select all the elements in the drawing pane that are part of the currently highlighted query. Once you have selected the elements in a selection set using Select In Drawing, you can delete them all at once.
Help Displays online help for the Queries Manager.