Options for highlighted drawings in paginated reports
Options for highlighted drawings in paginated reports
Technologies > Business Process Owner Views > Paginated Reports > Report with Drawing and a Custom SQL Highlight Data Source
Use custom SQL statements in a drawing highlight view
To incorporate custom SQL into a drawing highlight view, the SQL statement must have a
dwgname
field such as
rm.dwgname
. Additionally, the
dwgnameField
property must be defined in the
<report/>
element:
<sql dialect="generic">
SELECT rm.dwgname ${sql.as} dwgname, eq.eq_id ${sql.as} eq_id,
rm.bl_id ${sql.as} bl_id, rm.fl_id ${sql.as} fl_id, rm.rm_id ${sql.as} rm_id
FROM eq
LEFT OUTER JOIN rm
ON eq.bl_id = rm.bl_id AND eq.fl_id = rm.fl_id AND eq.rm_id = rm.rm_id
</sql>
<report dwgnameField="rm.dwgname"/>
http://localhost:8080/archibus/schema/ab-products/solutions/parts/pagereports/ab-ex-dwg-sql.axvw
Specify asset table name in a drawing highlight view
When the
assetTables
property is defined in the
<report/>
element, the core will use the
assetTables
value as the asset table name. When not specified, the core will use the
main
table as the asset table.
<report assetTables="zone"/>
http://localhost:8080/archibus/schema/ab-products/solutions/parts/pagereports/ab-ex-dwg-em-rpt.axvw
Specify asset suffix in a drawing highlight view
When the
assetSuffixes
property is defined in
<report/>
, the core uses the
assetSuffixes
value to load an asset
zlib
file such as hq17-zone-fire.json.zlib.
<report assetSuffixes="-fire"/>