Query not returning results for fields that use a pick-list

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? 

Date-time based query not working 

Recommended
Related