Using Queries
A query in WaterCAD 2024 is a user-defined SQL expression that applies to a single element type. You use the Query Manager to create and store queries; you use the Query Builder dialog box to construct the actual SQL expression.
Queries can be one of the following three types:
- Hydraulic Model queries—Queries you define that are available only in the WaterCAD 2024 hydraulic model in which you define them.
- Shared queries—Queries you define that are available in all WaterCAD 2024 hydraulic models you create. You can edit shared queries.
- Predefined queries—Factory-defined queries included with WaterCAD 2024 that are available in all hydraulic models you create. You cannot edit predefined queries.
You can also use queries in the following ways:
- Create dynamic selection sets based on one or more queries.
- Filter the data in a FlexTable using a query. For more information, see Sorting and Filtering FlexTable Data.
- You can use predefined queries in the Network Navigator. See Using the Network Navigator for more details.