Hi. I am using Bentley WaterGEMS Connect Edition 10.01.01.04
I am having a model containing 30 zones.
I want to select the junctions of 10 zones from this.
How shall I use the "Query Builder" in the junctions flextable so that these junctions for only 10 zones will be shown.
While I have used the following query, it becomes quite lengthy for performing the task.
HMIActiveTopologyIsActive = True AND Physical_Zone = 21487 OR Physical_Zone = 22736 OR Physical_Zone = 74296
Is there any other way so that the query could be shortened and same result is achieved?
Thanks
To add to Sushma's reply - another option is to use the "IN" operator -
HMIActiveTopologyIsActive = True AND Physical_Zone IN (21487,22736,74296, ...)
See related wiki 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.
Answer Verified By: Sushma Choure