Hi. I am using Bentley WaterGEMS Connect Edition 10.01.01.04.
My model contains 30 zones.
Now, When I want to use query builder in Junctions flex tables, each time I have to click on the zone ID which is needed for incorporating in query builder.
My question is: Is there any way through which we can directly copy the zone Id and Zone name into excel sheet just like we do for elements given in flextable?
This way I would be able to write the query in excel and paste it easily in query builder, saving the time for clicking each zone one at a time.
Cheers!
Hi Chetan,
The Zone IDs are not visible in the zone manager but you can view it in the Zone field in the Flextable by changing the Element Identifier format to "ID Only". This is found under File > Options > Hydraulic Model.
if you can get the list of zone IDs in comma-separated format, you can paste them into the bottom part of the query builder and use the SQL IN operator as mentioned in this article: Using the IN operator to query for elements in a set list of criteria
Regards,
Jesse DringoliTechnical Support Manager, OpenFlowsBentley Communities Site AdministratorBentley Systems, Inc.