& Construction
Integrated BIM tools, including Revit, AutoCAD, and Civil 3D
& Manufacturing
Professional CAD/CAM tools built on Inventor and AutoCAD
Set up database queries to use with a modeling project.
Tutorial resources
These downloadable resources will be used to complete this tutorial:
In InfoWater Pro, a database query is a time-saving tool that searches one or more fields within one or more database tables for specific information. The records that match the query are entered into a database table, domain, or facility.
Queries are built using Structured Query Language (SQL), but even if you do not know the language, you can use the Query Builder to help construct your searches in the proper SQL syntax. In this exercise, you set up a few DB queries to use with a modeling project.
The query statement to select 8-inch pipes is entered in the Query Statement box with the proper SQL format.
The query statement is validated. If the query statement is not a valid SQL statement, or if it does not select a single feature, an error is returned. In this case, your query should be valid.
Once you have an existing query, like the one you just created, you can use it as a starting point to create a more sophisticated query by cloning it.
The first query selected all 8-inch pipes, whereas this new query selects all 8-inch pipes in pressure zone 4.
The popup should indicate that the query is valid.
The queries are now available for use with databases, reports, and selections. They are listed in the Model Explorer, Operation tab, under DB Query:
Any number of queries can be stored in this area of the Operation tab, and queries can be shared between projects.