To add a database column to a report

1. In the Infrastructure Administrator, do one of the following:
   • Click Enterprise and connect to the enterprise industry model. Open a project.
   • Click File and open an industry model drawing or template.
2. Select the Industry Model node for the report.
3. On the Administrator toolbar, click the Report Designer icon .
4. Open a report.
5. Click the Detail Body 1 section.
6. On the Design tab, in the Group Detail category, click the SQL property.
7. Define a query that selects the features which are located in the perimeter.
8. Click Add DB Column and select the attributes to display.
9. If needed, add more controls, and save the report.

Example: Query to select features within a perimeter.

select P.FID from GA_PIPE P, GA_LINE T
WHERE P.FID = T.FID_ATTR AND
({parameter.PERIMETERID}=0
 or SDO_RELATE(T.geom, (SELECT geom FROM TB_PERIMETER
 WHERE id={parameter.PERIMETERID}), 
'mask=anyinteract query=window')='TRUE') 
GROUP BY P.FID ORDER BY P.FID

The parameter SPATIALMASK is only set if it is in the report definition. Sample SQL statement:

WHERE
{parameter.PERIMETERID}=0 
OR SDO_RELATE(T.geom, (SELECT geom FROM TB_PERIMETER 
WHERE id={parameter.PERIMETERID}),
'mask={parameter.SPATIALMASK} query=window')='TRUE'

For more information about using the spatial selection reports, see "Using Spatial Export" in the User's Guide.