This discussion has been locked.
You can no longer post new replies to this discussion. If you have a question you can start a new discussion

How to use Query Builder for filtering multiple zones

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

  • Hello Chetan, 

    You could do it another way, first create a selection set of those 10 required zones and then double click on that selection set > right click > Edit group > Open junction flex table. This will filter the flex table limited to junctions from those 10 zones only and then as required you can filter on active topology and save this flex table elements as new selection set. So whenever required you can select this new selection set and open the junction flex table for those junctions only, as explained above. Though you may find it lengthy again. 

    Selecting multiple elements for a selection set 

    However with query builder what you are doing appears right way to do it. 

    Others might have different approach as well. 

    Regards,

    Sushma Choure

    Bentley Technical Suppport

  • 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 Dringoli
    Technical Support Manager, OpenFlows
    Bentley Communities Site Administrator
    Bentley Systems, Inc.

    Answer Verified By: Sushma Choure