Product(s): |
WaterGEMS, SewerGEMS, CivilStorm, StormCAD, PondPack, SewerCAD, HAMMER, WaterCAD |
Version(s): |
08.11.XX.XX, 10.XX.XX.XX |
Area: |
Modeling |
Problem
How can you filter a flextable on Zone = "None"?
Problem ID#: 46478
Solution - Option 1
In the query builder, type 'IS NULL' after the attribute name, and it will retrieve all elements with the attribute set to "<None>".
Solution - Option 2
(for CONNECT Edition and greater)
- In the query builder, type '>1' after the name of the attribute and click OK. This will select all elements of that current type that do have a zone set
- Click Options > Select in Drawing,
- Reset the flextable's filter, then close the flextable
- From the Home tab, click Select > Invert Selection
- Right click in the drawing > Edit Group > select the respective flextable > OK. The table should now be filtered on elements that have the Zone set to "None".
Solution - Option 3
- Create a selection set of all elements of interest. You can right click in the drawing and choose "create selection set" when the elements are selected.
- In the query builder, filter on 'Zone > 1', then select elements in the drawing.
- When the elements that have 'Zone' already set are highlighted in the drawing, right-click and select 'Remove from Selection', and choose the selection set from step 1
- Now, double-click on the selection set > right-click > edit group > select the respective flextable > OK. The table should now be filtered on elements that have the Zone set to "None".
See Also
Filter FlexTable to only show active elements
How do I filter a column in my flextable using a custom query that retrieves all records with a <None> attribute?