| Product(s): | WaterGEMS, WaterCAD, HAMMER, SewerGEMS, SewerCAD, StormCAD, CivilStorm, PondPack |
| Version(s): | 08.11.XX.XX, 10.00.XX.XX |
| Area: | Modeling |
Problem
When querying for fields that use a pick-list (with enumerated values such as Zone), specifying labels does not return any results.
Solution
For fields that use a pick-list, (dropdown with enumerated options) you must use the unique ID instead of the label, for queries.
When we are querying pipes for example based on diameter, with diameter = 150.0 mm, then we just specify the diameter values like shown below.
However when you are querying fields like Zone which have unique IDs, then specifying the label will return no results. Instead, the "unique values" option should be used to locate the ID of the item you would like to use for your query filter. This is demonstrated in the below video.
See Also
When running a query, why is it not picking up the elements that it should?