& Construction
![architecture engineering and construction collection logo](https://damassets.autodesk.net/content/dam/autodesk/www/universal-header/flyout/architecture-engineering-construction-collection-uhblack-banner-lockup-364x40.png)
Integrated BIM tools, including Revit, AutoCAD, and Civil 3D
& Manufacturing
![product design manufacturing collection logo](https://damassets.autodesk.net/content/dam/autodesk/www/universal-header/flyout/product-design-manufacturing-collection-uhblack-banner-lockup-364x40.png)
Professional CAD/CAM tools built on Inventor and AutoCAD
Transcript
00:04
Once you have created database queries,
00:06
you can apply them as domains and verify their
00:08
accuracy using a few different database and domain tools
00:13
to begin double click the desired project dot APR
00:16
file to open Argi
00:18
Pro.
00:19
Once the project starts,
00:21
click the info water pro tab to open the info water pro ribbon
00:25
in the project panel, click initialize
00:29
on the info Water Pro ribbon
00:31
in the domain panel, click domain manager
00:36
in the domain manager select DB query as the element source.
00:41
The drop down list includes any queries that you created.
00:45
Select eight inch eight inch pipes and then click add,
00:50
click close to close the domain manager,
00:53
all pipes satisfying the query.
00:55
All eight inch pipes are selected and displayed in red in the map
01:01
on the info water pro ribbon
01:03
in the edit panel, click DB editor
01:07
select the pipe hydraulic modeling data table
01:10
in the open table dialogue under data scope, select domain.
01:16
The DB query option can be used here if you
01:18
are writing a query just to open the database table.
01:22
In this case, using a domain is easier since you are using a project DB query.
01:27
Click OK? To open the table in the DB editor,
01:32
click the diameter column heading to select the column
01:35
and then from the toolbar, click field statistics.
01:40
The pop up confirms that there are only eight inch pipes in the database table.
01:45
Click OK, to close the field statistics pop up and then exit to close the DB editor.
01:54
Open the domain manager again,
01:56
click clear to clear the domain of your previous selection.
02:01
Select DB query as the element source
02:05
eight I N underscore Z 48 inch pipes in zone four from the dropdown list
02:10
and then click add,
02:13
click close to close the domain manager.
02:17
All pipes satisfying the query. That is all eight inch pipes in pressure zone.
02:21
Four are selected and displayed in red in the map
02:26
on the info water pro ribbon in the edit panel, click edit domain,
02:31
the edit attribute dialogue opens,
02:34
click the pipe tab
02:37
browse through the table and noticed that all pipes are eight inches
02:40
and that all of them have a zone field of four.
02:44
The beige fields are all fields in the information table
02:48
and the
02:49
scion fields are all fields in the modeling table.
02:52
When you are finished reviewing the data, close the edit attribute dialog box.
00:04
Once you have created database queries,
00:06
you can apply them as domains and verify their
00:08
accuracy using a few different database and domain tools
00:13
to begin double click the desired project dot APR
00:16
file to open Argi
00:18
Pro.
00:19
Once the project starts,
00:21
click the info water pro tab to open the info water pro ribbon
00:25
in the project panel, click initialize
00:29
on the info Water Pro ribbon
00:31
in the domain panel, click domain manager
00:36
in the domain manager select DB query as the element source.
00:41
The drop down list includes any queries that you created.
00:45
Select eight inch eight inch pipes and then click add,
00:50
click close to close the domain manager,
00:53
all pipes satisfying the query.
00:55
All eight inch pipes are selected and displayed in red in the map
01:01
on the info water pro ribbon
01:03
in the edit panel, click DB editor
01:07
select the pipe hydraulic modeling data table
01:10
in the open table dialogue under data scope, select domain.
01:16
The DB query option can be used here if you
01:18
are writing a query just to open the database table.
01:22
In this case, using a domain is easier since you are using a project DB query.
01:27
Click OK? To open the table in the DB editor,
01:32
click the diameter column heading to select the column
01:35
and then from the toolbar, click field statistics.
01:40
The pop up confirms that there are only eight inch pipes in the database table.
01:45
Click OK, to close the field statistics pop up and then exit to close the DB editor.
01:54
Open the domain manager again,
01:56
click clear to clear the domain of your previous selection.
02:01
Select DB query as the element source
02:05
eight I N underscore Z 48 inch pipes in zone four from the dropdown list
02:10
and then click add,
02:13
click close to close the domain manager.
02:17
All pipes satisfying the query. That is all eight inch pipes in pressure zone.
02:21
Four are selected and displayed in red in the map
02:26
on the info water pro ribbon in the edit panel, click edit domain,
02:31
the edit attribute dialogue opens,
02:34
click the pipe tab
02:37
browse through the table and noticed that all pipes are eight inches
02:40
and that all of them have a zone field of four.
02:44
The beige fields are all fields in the information table
02:48
and the
02:49
scion fields are all fields in the modeling table.
02:52
When you are finished reviewing the data, close the edit attribute dialog box.
Required for course completion
Once you have created database queries, you can apply them as domains and verify their accuracy using a few different database and domain tools.
All pipes satisfying the query (all 8-inch pipes) are selected and displayed in red in the map:
Note: The DB Query option can be used here if you are writing a query just to open the database table. In this case, using a domain is easier since you are using a project DB query.
The Field Statistics popup confirms that there are only 8-inch pipes in the database table:
All pipes satisfying the query, that is, all 8-inch pipes in pressure zone 4, are selected and displayed in red in the map:
Note: All pipes are 8 inches, and all of them have a zone field of 4: