Sharing Queries for use in other models


 Applies To 
 Product(s):WaterCAD, WaterGEMS, SewerGEMS, CivilStorm, StormCAD, PondPack, SewerCAD, HAMMER
 Version(s):CONNECT Edition, V8i
 Area: Other
 Original Author:Mark Pachlhofer, Bentley Technical Support Group

Problem

How can I share Queries (from the Queries Manager) with other models or other colleagues?

Solution

The Queries Manager has three categories (which appear like folders), "Queries - Hydraulic Model", "Queries - Shared" and "Queries - Predefined".

Queries created in "Queries - Hydraulic Model" will only be available in the current model. To share with others you would need to use the Seed File feature to use them in other models. Meaning, create a new model, create the queries under "Queries - Hydraulic Model", create other standard model components, then save to a Seed file (File > Seed > Save to Seed). Then, whenever you want to start a new model, choose File > Seed > New from Seed and select the seed file, so that you start out with all those standard things.

Queries created in "Queries - Shared" will be available for all models on the current computer, so you would be able to use them with other models.

If you need to share those queries with other colleagues on other computers, you could either use the Seed file approach, or locate the XML file where the Shared Queries are stored on your computer, then copy that to the appropriate location on the other colleague's computer;

You can find the "SharedQueries.xml" file at the following location (Windows 7, 8, 10, 11)

C:\Users\<UserName>\AppData\Local\Bentley\<Bentley Program Name>\10

(replace "10" with the number corresponding to the year, for versions after CONNECT Edition)

Save the file somewhere and then give it to a colleague if you want to share it. They would then paste the file in the same location on their computer and make sure to overwrite the existing one when prompted.