Selecting linked isolation valve from saved pipe selection set

Dear Muhammad Hanif, 

Thanks for querying on Bentley Forum! 

Can you please confirm which Bentley Product you are referring to?

HTH

WaterCAD Connect Edition

Hello,

A very crude way to do this is simply select the entire area of your selected pipes (the isolation valves should be selected in this), right click on the selection > edit group > select isolation valves table. Create a selection set for this table.

Now open the selection set and one by one select the elements which are not supposed to be in this selection set and remove them.

Another method is this. In the Isolation Valve Flex Table, you can see the attached pipe in the field "Referenced Pipe". Copy this table to an Excel Sheet.

Now, create a User Defined Extension for pipe table. Name the field as "Attached Isolation Valve" (for example). Keep the field type as "Text".

Now in the pipe flex table, bring in this new field ("Attached Isolation Valve") which you created as a column. From the excel sheet created, copy the column of isolation valve labels. Paste it in the newly created column "Attached Isolation Valve" in the pipe flex table.

If you have a selection set created for your specific pipes, select that and open the pipe table (Edit Group > Pipe Flex Table). It will show the "Attached Isolation Valve" field with the isolation valves assigned to those pipes.

Hope this helps.

Muhamad, can you tell us a bit more about why you need to do this?

If your goal is to select all the isolation valves associated with a set of pipes, you could try this:

1) Create two, text UDX fields for isolation valves, "Referenced Pipe (copy)" and "Referenced Pipe (selection)"
2) Open the unfiltered isolation valve table and copy the "referenced pipe" data to the "Referenced Pipe (copy)" field. This is done by right clicking the first column choosing "select", then the copy button at the top, then right click the second column, choose "select", then click the paste button at the top.
3) filter the pipe table on selection (using your desired selection of pipes)
4) Copy/paste the labels from the pipe table to Excel (or use the CSV export option, then open the CSV file and save to XLS format)
5) Create a connection to the Excel file in ModelBuilder, using the isolation valve table type. Choose the "custom" option for the "Map elements by key field" in the "Specify additional options" step, then for the key field, map the Excel file's label field to the model's "Referenced Pipe (copy)" field. In the bottom portion, map Label to the "Referenced Pipe (selection)" field. This will update the isolation valve UDX with the label of the pipes that were in your pipe selection set.
6) Create a new query for isolation valves to select only the ones that are not blank. Double click "Referenced Pipe (selection), then type in <> ''. It should look something like this: Isolation_Valve_Field_2 <> ''
7) Run the query and it will select the isolation valves associated with your set of pipes.

If you are in ArcMap integrated mode, you may be able to accomplish this with a spatial join.

Lastly, we can look into adding this as a new query to Network Navigator (select isolation valves associated with pipes).

Hi Jesse,

Thanks for the guideline.

The reason i am doing this is to tag all of the isolation valves associated with the selected pipes to a certain zone name/code. All the assets within the zone been tagged to a zone name/code.

The selected pipes were traced using downstream tracing query. However, when I edit group (right-click) to open flex table (Edit Group>Isolation Valve Flex Table) that shown only the selected network downstream, isolation valve is excluded. It shows all of the isolation valves within the model.

Regards,

Haniff