git.aero2k.de Git - tmp/jakarta-migration.git/blob

   1 <?xml version="1.0" encoding="UTF-8"?>
   2 <!-- Created with Jaspersoft Studio version 6.20.1.final using JasperReports Library version 6.20.1-7584acb244139816654f64e2fd57a00d3e31921e  -->
   3 <jasperReport xmlns="http://jasperreports.sourceforge.net/jasperreports" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:schemaLocation="http://jasperreports.sourceforge.net/jasperreports http://jasperreports.sourceforge.net/xsd/jasperreport.xsd" name="obj_full_place_creator_role_combined" language="javascript" pageWidth="3900" pageHeight="800" orientation="Landscape" columnWidth="100" leftMargin="20" rightMargin="20" topMargin="20" bottomMargin="20" isIgnorePagination="true" uuid="e7341792-0aee-463a-847c-462d12bf8e24">
   4         <property name="com.jaspersoft.studio.data.sql.tables" value=""/>
   5         <property name="com.jaspersoft.studio.data.defaultdataadapter" value="nuxeo"/>
   6         <property name="com.jaspersoft.studio.data.sql.SQLQueryDesigner.sash.w1" value="193"/>
   7         <property name="com.jaspersoft.studio.data.sql.SQLQueryDesigner.sash.w2" value="800"/>
   8         <property name="com.jaspersoft.studio.property.dataset.dialog.DatasetDialog.sash.w1" value="625"/>
   9         <property name="com.jaspersoft.studio.property.dataset.dialog.DatasetDialog.sash.w2" value="361"/>
  10         <style name="Column header" fontName="SansSerif" fontSize="12" isBold="true"/>
  11         <style name="Detail" fontName="SansSerif" fontSize="12"/>
  12         <parameter name="deurnfields" class="java.lang.String" isForPrompting="false">
  13                 <defaultValueExpression><![CDATA["publicartproductiondatetype,responsibledepartment,publicartproductionpersons,publicartproductionpersonroles,publishto,installationtype,worktypes,materials,collections,owner,computedcurrentlocation,placementtype,placetype,placeowner,addressmunicipality,addressstateorprovince,addresscountry,addresstype,addresstype,broaderplace"]]></defaultValueExpression>
  14         </parameter>
  15         <parameter name="tenantid" class="java.lang.String" isForPrompting="false">
  16                 <defaultValueExpression><![CDATA["5000"]]></defaultValueExpression>
  17         </parameter>
  18         <parameter name="csid" class="java.lang.String" isForPrompting="false"/>
  19         <parameter name="whereclause" class="java.lang.String" isForPrompting="false">
  20                 <defaultValueExpression><![CDATA[$P{csid} != null ? "WHERE hier.name = '" + $P{csid} + "'" : ""]]></defaultValueExpression>
  21         </parameter>
  22         <queryString language="SQL">
  23                 <![CDATA[SELECT
  24         obj.objectnumber,
  25         tg.title,
  26         dategroup.publicartproductiondatetype,
  27         proddate.datedisplaydate AS objectproductiondate,
  28         coalesce(creator_agg.publicartproductionpersons, '{}') as publicartproductionpersons,
  29         coalesce(creator_agg.publicartproductionpersonroles, '{}') as publicartproductionpersonroles,
  30         rd.item AS responsibledepartment,
  31         obj.recordstatus,
  32         publishto.item AS publishto,
  33         installationtype.item AS installationtype,
  34         objectCountGroup.objectcount AS numberofobjects,
  35         coalesce(worktype_agg.worktypes, '{}') AS worktypes,
  36         coalesce(material_agg.materials, '{}') AS materials,
  37         bd.item AS briefdescription,
  38         comment.item AS comment,
  39         coalesce(publicart_collections.collections, '{}') as collections,
  40         owners.item AS owner,
  41         dimension.dimension,
  42         obj.computedcurrentlocation,
  43         movement.currentlocationnote,
  44         place.placenote,
  45         placement.item AS placementtype,
  46         place_pa.placementenvironment,
  47         placetype.item AS placetype,
  48         placeowner.owner AS placeowner,
  49         placeowner.ownershipnote,
  50         placeowner.ownertype,
  51         placeownerdate.datedisplaydate AS ownershipdate,
  52         address.addressplace1,
  53         address.addressplace2,
  54         address.addressmunicipality,
  55         address.addressstateorprovince,
  56         address.addresscountry,
  57         address.addresstype,
  58         address.addresspostcode,
  59         geo.decimallatitude,
  60         geo.decimallongitude,
  61         broaderplace.objectrefname AS broaderplace
  62 FROM collectionobjects_common obj
  63 INNER JOIN hierarchy hier on hier.id = obj.id
  64 INNER JOIN misc ON misc.id = obj.id and misc.lifecyclestate != 'deleted'
  65 INNER JOIN collectionspace_core core ON misc.id = core.id AND core.tenantid = $P{tenantid}
  66 LEFT JOIN hierarchy title_hier ON title_hier.parentid = obj.id AND title_hier.primarytype = 'titleGroup' AND title_hier.pos = 0
  67 LEFT JOIN titlegroup tg ON tg.id = title_hier.id
  68 LEFT JOIN hierarchy proddategroup_hier ON proddategroup_hier.parentid = obj.id AND proddategroup_hier.primarytype = 'publicartProductionDateGroup' AND proddategroup_hier.pos = 0
  69 LEFT JOIN publicartproductiondategroup dategroup ON dategroup.id = proddategroup_hier.id
  70 LEFT JOIN hierarchy proddate_hier ON proddate_hier.parentid = proddategroup_hier.id
  71 LEFT JOIN structureddategroup proddate ON proddate.id = proddate_hier.id
  72 -- AGGREGATE ALL CREATORS AND ROLES
  73 LEFT JOIN (
  74   SELECT
  75     creator_hier.parentid AS obj_id,
  76         array_agg(coalesce(creator.publicartproductionperson, '')) AS publicartproductionpersons,
  77         array_agg(coalesce(creator.publicartproductionpersonrole, '')) AS publicartproductionpersonroles
  78   FROM hierarchy creator_hier
  79   LEFT JOIN publicartproductionpersongroup creator ON creator.id = creator_hier.id
  80   WHERE creator_hier.primarytype = 'publicartProductionPersonGroup'
  81   GROUP BY creator_hier.parentid
  82 ) creator_agg ON creator_agg.obj_id = obj.id
  83 LEFT JOIN collectionobjects_common_responsibledepartments rd ON rd.id = obj.id AND rd.pos = 0
  84 LEFT JOIN collectionobjects_common_publishtolist publishto ON publishto.id = obj.id AND publishto.pos = 0
  85 LEFT JOIN collectionobjects_common_inventorystatuslist installationtype ON installationtype.id = obj.id AND installationtype.pos = 0
  86 LEFT JOIN collectionobjects_common_briefdescriptions bd ON bd.id = obj.id AND bd.pos = 0
  87 LEFT JOIN collectionobjects_common_comments comment ON comment.id = obj.id AND comment.pos = 0
  88 -- AGGREGATE ALL WORK TYPES
  89 LEFT JOIN (
  90   SELECT
  91     work_hier.parentid AS obj_id,
  92     array_agg(coalesce(worktype.objectname, '')) AS worktypes
  93   FROM hierarchy work_hier
  94   LEFT JOIN objectnamegroup worktype ON worktype.id = work_hier.id
  95   WHERE work_hier.primarytype = 'objectNameGroup'
  96   GROUP BY work_hier.parentid
  97 ) worktype_agg ON worktype_agg.obj_id = obj.id
  98 -- AGGREGATE ALL MATERIALS
  99 LEFT JOIN (
 100   SELECT
 101     material_hier.parentid AS obj_id,
 102     array_agg(coalesce(material.material, '')) AS materials
 103   FROM hierarchy material_hier
 104   LEFT JOIN materialgroup material ON material.id = material_hier.id
 105   WHERE material_hier.primarytype = 'materialGroup'
 106   GROUP BY material_hier.parentid
 107 ) material_agg ON material_agg.obj_id = obj.id
 108 LEFT JOIN (
 109         SELECT
 110                 id AS obj_id,
 111                 array_agg(item) AS collections
 112         FROM collectionobjects_publicart_publicartcollections
 113         GROUP BY obj_id
 114 ) publicart_collections on publicart_collections.obj_id = obj.id
 115 LEFT JOIN collectionobjects_common_owners owners ON owners.id = obj.id AND owners.pos = 0
 116 LEFT JOIN hierarchy count_hier ON obj.id = count_hier.parentid AND count_hier.primarytype='objectCountGroup' AND count_hier.pos=0
 117 LEFT JOIN objectcountgroup objectCountGroup ON count_hier.id = objectCountGroup.id
 118 -- aggregate for the dimension
 119 LEFT JOIN (
 120         SELECT
 121                 measured_hier.parentid,
 122                 string_agg(concat(dimension.dimension, ' ', dimension.value::text, ' ', dimension.measurementunit), ' | ') AS dimension
 123         FROM hierarchy measured_hier
 124         INNER JOIN hierarchy dimension_hier on dimension_hier.parentid = measured_hier.id and dimension_hier.primarytype = 'dimensionSubGroup'
 125         LEFT JOIN dimensionsubgroup dimension on dimension.id = dimension_hier.id
 126         WHERE measured_hier.primarytype = 'measuredPartGroup'
 127         GROUP BY measured_hier.parentid
 128 ) dimension on dimension.parentid = obj.id
 129 -- get the correct movement from relation + computed location
 130 LEFT JOIN (
 131         SELECT
 132                 relation.objectcsid,
 133                 movement.currentlocation,
 134                 movement.currentlocationnote
 135         FROM relations_common relation
 136         INNER JOIN misc ON misc.id = relation.id AND misc.lifecyclestate != 'deleted'
 137         INNER JOIN hierarchy hier ON hier.name = relation.subjectcsid
 138         INNER JOIN movements_common movement ON movement.id = hier.id
 139         WHERE relation.objectdocumenttype = 'CollectionObject' AND relation.subjectdocumenttype = 'Movement'
 140 ) movement ON movement.objectcsid = hier.name AND movement.currentlocation = obj.computedcurrentlocation
 141 -- place and all place fields
 142 LEFT JOIN places_common place on place.refname = obj.computedcurrentlocation
 143 LEFT JOIN places_publicart_placementtypes placement on placement.id = place.id AND placement.pos = 0
 144 LEFT JOIN places_publicart place_pa on place_pa.id = place.id
 145 LEFT JOIN places_publicart_publicartplacetypes placetype on placetype.id = place.id AND placetype.pos = 0
 146 LEFT JOIN hierarchy placeowner_hier on placeowner_hier.parentid = place.id and placeowner_hier.primarytype = 'publicartPlaceOwnerGroup' and placeowner_hier.pos = 0
 147 LEFT JOIN hierarchy placeownerdate_hier on placeownerdate_hier.parentid = placeowner_hier.id
 148 LEFT JOIN publicartplaceownergroup placeowner on placeowner.id = placeowner_hier.id
 149 LEFT JOIN structureddategroup placeownerdate on placeownerdate.id = placeownerdate_hier.id
 150 LEFT JOIN hierarchy addr_hier ON addr_hier.parentid = place.id AND addr_hier.primarytype = 'addrGroup' AND addr_hier.pos = 0
 151 LEFT JOIN addrgroup address ON address.id = addr_hier.id
 152 LEFT JOIN hierarchy geo_hier ON geo_hier.parentid = place.id AND geo_hier.primarytype = 'placeGeoRefGroup' AND geo_hier.pos = 0
 153 LEFT JOIN placegeorefgroup geo ON geo.id = geo_hier.id
 154 LEFT JOIN hierarchy place_hier on place_hier.id = place.id
 155 LEFT JOIN relations_common broaderplace ON broaderplace.subjectcsid = place_hier.name AND broaderplace.relationshiptype = 'hasBroader'
 156 $P!{whereclause}]]>
 157         </queryString>
 158         <field name="objectnumber" class="java.lang.String">
 159                 <property name="com.jaspersoft.studio.field.name" value="objectnumber"/>
 160                 <property name="com.jaspersoft.studio.field.label" value="objectnumber"/>
 161                 <property name="com.jaspersoft.studio.field.tree.path" value="collectionobjects_common"/>
 162         </field>
 163         <field name="title" class="java.lang.String">
 164                 <property name="com.jaspersoft.studio.field.name" value="title"/>
 165                 <property name="com.jaspersoft.studio.field.label" value="title"/>
 166                 <property name="com.jaspersoft.studio.field.tree.path" value="titlegroup"/>
 167         </field>
 168         <field name="publicartproductiondatetype" class="java.lang.String">
 169                 <property name="com.jaspersoft.studio.field.name" value="publicartproductiondatetype"/>
 170                 <property name="com.jaspersoft.studio.field.label" value="publicartproductiondatetype"/>
 171                 <property name="com.jaspersoft.studio.field.tree.path" value="publicartproductiondategroup"/>
 172         </field>
 173         <field name="objectproductiondate" class="java.lang.String">
 174                 <property name="com.jaspersoft.studio.field.name" value="objectproductiondate"/>
 175                 <property name="com.jaspersoft.studio.field.label" value="objectproductiondate"/>
 176                 <property name="com.jaspersoft.studio.field.tree.path" value="structureddategroup"/>
 177         </field>
 178         <field name="publicartproductionpersons" class="java.sql.Array">
 179                 <property name="com.jaspersoft.studio.field.name" value="publicartproductionpersons"/>
 180                 <property name="com.jaspersoft.studio.field.label" value="publicartproductionpersons"/>
 181                 <property name="com.jaspersoft.studio.field.tree.path" value="publicartproductionpersongroup"/>
 182         </field>
 183         <field name="publicartproductionpersonroles" class="java.sql.Array">
 184                 <property name="com.jaspersoft.studio.field.name" value="publicartproductionpersonroles"/>
 185                 <property name="com.jaspersoft.studio.field.label" value="publicartproductionpersonroles"/>
 186                 <property name="com.jaspersoft.studio.field.tree.path" value="publicartproductionpersongroup"/>
 187         </field>
 188         <field name="responsibledepartment" class="java.lang.String">
 189                 <property name="com.jaspersoft.studio.field.name" value="responsibledepartment"/>
 190                 <property name="com.jaspersoft.studio.field.label" value="responsibledepartment"/>
 191                 <property name="com.jaspersoft.studio.field.tree.path" value="collectionobjects_common_responsibledepartments"/>
 192         </field>
 193         <field name="recordstatus" class="java.lang.String">
 194                 <property name="com.jaspersoft.studio.field.name" value="recordstatus"/>
 195                 <property name="com.jaspersoft.studio.field.label" value="recordstatus"/>
 196                 <property name="com.jaspersoft.studio.field.tree.path" value="collectionobjects_common"/>
 197         </field>
 198         <field name="publishto" class="java.lang.String">
 199                 <property name="com.jaspersoft.studio.field.name" value="publishto"/>
 200                 <property name="com.jaspersoft.studio.field.label" value="publishto"/>
 201                 <property name="com.jaspersoft.studio.field.tree.path" value="collectionobjects_common_publishtolist"/>
 202         </field>
 203         <field name="installationtype" class="java.lang.String">
 204                 <property name="com.jaspersoft.studio.field.name" value="installationtype"/>
 205                 <property name="com.jaspersoft.studio.field.label" value="installationtype"/>
 206                 <property name="com.jaspersoft.studio.field.tree.path" value="collectionobjects_common_inventorystatuslist"/>
 207         </field>
 208         <field name="numberofobjects" class="java.lang.Long">
 209                 <property name="com.jaspersoft.studio.field.name" value="numberofobjects"/>
 210                 <property name="com.jaspersoft.studio.field.label" value="numberofobjects"/>
 211                 <property name="com.jaspersoft.studio.field.tree.path" value="collectionobjects_common"/>
 212         </field>
 213         <field name="worktypes" class="java.sql.Array">
 214                 <property name="com.jaspersoft.studio.field.name" value="worktypes"/>
 215                 <property name="com.jaspersoft.studio.field.label" value="worktypes"/>
 216                 <property name="com.jaspersoft.studio.field.tree.path" value="objectnamegroup"/>
 217         </field>
 218         <field name="materials" class="java.sql.Array">
 219                 <property name="com.jaspersoft.studio.field.name" value="materials"/>
 220                 <property name="com.jaspersoft.studio.field.label" value="materials"/>
 221                 <property name="com.jaspersoft.studio.field.tree.path" value="materialgroup"/>
 222         </field>
 223         <field name="briefdescription" class="java.lang.String">
 224                 <property name="com.jaspersoft.studio.field.name" value="briefdescription"/>
 225                 <property name="com.jaspersoft.studio.field.label" value="briefdescription"/>
 226                 <property name="com.jaspersoft.studio.field.tree.path" value="collectionobjects_common_briefdescriptions"/>
 227         </field>
 228         <field name="comment" class="java.lang.String">
 229                 <property name="com.jaspersoft.studio.field.name" value="comment"/>
 230                 <property name="com.jaspersoft.studio.field.label" value="comment"/>
 231                 <property name="com.jaspersoft.studio.field.tree.path" value="collectionobjects_common_comments"/>
 232         </field>
 233         <field name="collections" class="java.sql.Array">
 234                 <property name="com.jaspersoft.studio.field.name" value="collections"/>
 235                 <property name="com.jaspersoft.studio.field.label" value="collections"/>
 236                 <property name="com.jaspersoft.studio.field.tree.path" value="collectionobjects_publicart_publicartcollections"/>
 237         </field>
 238         <field name="owner" class="java.lang.String">
 239                 <property name="com.jaspersoft.studio.field.name" value="owner"/>
 240                 <property name="com.jaspersoft.studio.field.label" value="owner"/>
 241                 <property name="com.jaspersoft.studio.field.tree.path" value="collectionobjects_common_owners"/>
 242         </field>
 243         <field name="dimension" class="java.lang.String">
 244                 <property name="com.jaspersoft.studio.field.name" value="dimension"/>
 245                 <property name="com.jaspersoft.studio.field.label" value="dimension"/>
 246         </field>
 247         <field name="computedcurrentlocation" class="java.lang.String">
 248                 <property name="com.jaspersoft.studio.field.name" value="computedcurrentlocation"/>
 249                 <property name="com.jaspersoft.studio.field.label" value="computedcurrentlocation"/>
 250                 <property name="com.jaspersoft.studio.field.tree.path" value="collectionobjects_common"/>
 251         </field>
 252         <field name="currentlocationnote" class="java.lang.String">
 253                 <property name="com.jaspersoft.studio.field.name" value="currentlocationnote"/>
 254                 <property name="com.jaspersoft.studio.field.label" value="currentlocationnote"/>
 255                 <property name="com.jaspersoft.studio.field.tree.path" value="movements_common"/>
 256         </field>
 257         <field name="placementtype" class="java.lang.String">
 258                 <property name="com.jaspersoft.studio.field.name" value="placementtype"/>
 259                 <property name="com.jaspersoft.studio.field.label" value="placementtype"/>
 260                 <property name="com.jaspersoft.studio.field.tree.path" value="places_publicart_placementtypes"/>
 261         </field>
 262         <field name="placementenvironment" class="java.lang.String">
 263                 <property name="com.jaspersoft.studio.field.name" value="placementenvironment"/>
 264                 <property name="com.jaspersoft.studio.field.label" value="placementenvironment"/>
 265                 <property name="com.jaspersoft.studio.field.tree.path" value="places_publicart"/>
 266         </field>
 267         <field name="placetype" class="java.lang.String">
 268                 <property name="com.jaspersoft.studio.field.name" value="placetype"/>
 269                 <property name="com.jaspersoft.studio.field.label" value="placetype"/>
 270                 <property name="com.jaspersoft.studio.field.tree.path" value="places_publicart_publicartplacetypes"/>
 271         </field>
 272         <field name="placeowner" class="java.lang.String">
 273                 <property name="com.jaspersoft.studio.field.name" value="placeowner"/>
 274                 <property name="com.jaspersoft.studio.field.label" value="placeowner"/>
 275                 <property name="com.jaspersoft.studio.field.tree.path" value="publicartplaceownergroup"/>
 276         </field>
 277         <field name="ownershipnote" class="java.lang.String">
 278                 <property name="com.jaspersoft.studio.field.name" value="ownershipnote"/>
 279                 <property name="com.jaspersoft.studio.field.label" value="ownershipnote"/>
 280                 <property name="com.jaspersoft.studio.field.tree.path" value="publicartplaceownergroup"/>
 281         </field>
 282         <field name="ownertype" class="java.lang.String">
 283                 <property name="com.jaspersoft.studio.field.name" value="ownertype"/>
 284                 <property name="com.jaspersoft.studio.field.label" value="ownertype"/>
 285                 <property name="com.jaspersoft.studio.field.tree.path" value="publicartplaceownergroup"/>
 286         </field>
 287         <field name="ownershipdate" class="java.lang.String">
 288                 <property name="com.jaspersoft.studio.field.name" value="ownershipdate"/>
 289                 <property name="com.jaspersoft.studio.field.label" value="ownershipdate"/>
 290                 <property name="com.jaspersoft.studio.field.tree.path" value="structureddategroup"/>
 291         </field>
 292         <field name="addressplace1" class="java.lang.String">
 293                 <property name="com.jaspersoft.studio.field.name" value="addressplace1"/>
 294                 <property name="com.jaspersoft.studio.field.label" value="addressplace1"/>
 295                 <property name="com.jaspersoft.studio.field.tree.path" value="addrgroup"/>
 296         </field>
 297         <field name="addressplace2" class="java.lang.String">
 298                 <property name="com.jaspersoft.studio.field.name" value="addressplace2"/>
 299                 <property name="com.jaspersoft.studio.field.label" value="addressplace2"/>
 300                 <property name="com.jaspersoft.studio.field.tree.path" value="addrgroup"/>
 301         </field>
 302         <field name="addressmunicipality" class="java.lang.String">
 303                 <property name="com.jaspersoft.studio.field.name" value="addressmunicipality"/>
 304                 <property name="com.jaspersoft.studio.field.label" value="addressmunicipality"/>
 305                 <property name="com.jaspersoft.studio.field.tree.path" value="addrgroup"/>
 306         </field>
 307         <field name="addressstateorprovince" class="java.lang.String">
 308                 <property name="com.jaspersoft.studio.field.name" value="addressstateorprovince"/>
 309                 <property name="com.jaspersoft.studio.field.label" value="addressstateorprovince"/>
 310                 <property name="com.jaspersoft.studio.field.tree.path" value="addrgroup"/>
 311         </field>
 312         <field name="addresscountry" class="java.lang.String">
 313                 <property name="com.jaspersoft.studio.field.name" value="addresscountry"/>
 314                 <property name="com.jaspersoft.studio.field.label" value="addresscountry"/>
 315                 <property name="com.jaspersoft.studio.field.tree.path" value="addrgroup"/>
 316         </field>
 317         <field name="addresstype" class="java.lang.String">
 318                 <property name="com.jaspersoft.studio.field.name" value="addresstype"/>
 319                 <property name="com.jaspersoft.studio.field.label" value="addresstype"/>
 320                 <property name="com.jaspersoft.studio.field.tree.path" value="addrgroup"/>
 321         </field>
 322         <field name="addresspostcode" class="java.lang.String">
 323                 <property name="com.jaspersoft.studio.field.name" value="addresspostcode"/>
 324                 <property name="com.jaspersoft.studio.field.label" value="addresspostcode"/>
 325                 <property name="com.jaspersoft.studio.field.tree.path" value="addrgroup"/>
 326         </field>
 327         <field name="decimallatitude" class="java.lang.Double">
 328                 <property name="com.jaspersoft.studio.field.name" value="decimallatitude"/>
 329                 <property name="com.jaspersoft.studio.field.label" value="decimallatitude"/>
 330                 <property name="com.jaspersoft.studio.field.tree.path" value="placegeorefgroup"/>
 331         </field>
 332         <field name="decimallongitude" class="java.lang.Double">
 333                 <property name="com.jaspersoft.studio.field.name" value="decimallongitude"/>
 334                 <property name="com.jaspersoft.studio.field.label" value="decimallongitude"/>
 335                 <property name="com.jaspersoft.studio.field.tree.path" value="placegeorefgroup"/>
 336         </field>
 337         <field name="broaderplace" class="java.lang.String">
 338                 <property name="com.jaspersoft.studio.field.name" value="broaderplace"/>
 339                 <property name="com.jaspersoft.studio.field.label" value="broaderplace"/>
 340                 <property name="com.jaspersoft.studio.field.tree.path" value="relations_common"/>
 341         </field>
 342         <field name="placenote" class="java.lang.String">
 343                 <property name="com.jaspersoft.studio.field.name" value="placenote"/>
 344                 <property name="com.jaspersoft.studio.field.label" value="placenote"/>
 345                 <property name="com.jaspersoft.studio.field.tree.path" value="places_common"/>
 346         </field>
 347         <background>
 348                 <band splitType="Stretch"/>
 349         </background>
 350         <columnHeader>
 351                 <band height="44" splitType="Stretch">
 352                         <property name="com.jaspersoft.studio.layout" value="com.jaspersoft.studio.editor.layout.FreeLayout"/>
 353                         <property name="com.jaspersoft.studio.unit.height" value="px"/>
 354                         <staticText>
 355                                 <reportElement style="Column header" x="0" y="0" width="100" height="44" uuid="7f5bf8c5-d4d8-47ce-9a87-196159f49d51">
 356                                         <property name="com.jaspersoft.studio.unit.width" value="px"/>
 357                                 </reportElement>
 358                                 <textElement markup="styled"/>
 359                                 <text><![CDATA[Artwork ID]]></text>
 360                         </staticText>
 361                         <staticText>
 362                                 <reportElement style="Column header" x="100" y="0" width="100" height="44" uuid="e18fc5d2-ec59-4015-9bd0-4c2cadedc7cc">
 363                                         <property name="com.jaspersoft.studio.unit.width" value="px"/>
 364                                 </reportElement>
 365                                 <textElement markup="styled"/>
 366                                 <text><![CDATA[Title]]></text>
 367                         </staticText>
 368                         <staticText>
 369                                 <reportElement style="Column header" x="200" y="0" width="100" height="44" uuid="e42249c3-2d9a-4fdb-b152-083bcd458945">
 370                                         <property name="com.jaspersoft.studio.unit.width" value="px"/>
 371                                 </reportElement>
 372                                 <textElement markup="styled"/>
 373                                 <text><![CDATA[Production Date]]></text>
 374                         </staticText>
 375                         <staticText>
 376                                 <reportElement style="Column header" x="300" y="0" width="100" height="44" uuid="47dbec68-a31e-4c52-ad98-0c81a208b125">
 377                                         <property name="com.jaspersoft.studio.unit.width" value="px"/>
 378                                 </reportElement>
 379                                 <textElement markup="styled"/>
 380                                 <text><![CDATA[Production Date Type]]></text>
 381                         </staticText>
 382                         <staticText>
 383                                 <reportElement style="Column header" x="400" y="0" width="100" height="44" uuid="b05cdf2f-45a7-414a-8e10-efa6a896d93d">
 384                                         <property name="com.jaspersoft.studio.unit.width" value="px"/>
 385                                 </reportElement>
 386                                 <textElement markup="styled"/>
 387                                 <text><![CDATA[Creator (Creator Role)]]></text>
 388                         </staticText>
 389                         <staticText>
 390                                 <reportElement style="Column header" x="600" y="0" width="100" height="44" uuid="88e6a812-ab40-4d73-85fb-7af13d82bec3">
 391                                         <property name="com.jaspersoft.studio.unit.width" value="px"/>
 392                                 </reportElement>
 393                                 <textElement markup="styled"/>
 394                                 <text><![CDATA[Program Name]]></text>
 395                         </staticText>
 396                         <staticText>
 397                                 <reportElement style="Column header" x="700" y="0" width="100" height="44" uuid="2a0a2c6d-2ed1-4dd4-b916-17287045deb3">
 398                                         <property name="com.jaspersoft.studio.unit.width" value="px"/>
 399                                 </reportElement>
 400                                 <textElement markup="styled"/>
 401                                 <text><![CDATA[Record Status]]></text>
 402                         </staticText>
 403                         <staticText>
 404                                 <reportElement style="Column header" x="800" y="0" width="100" height="44" uuid="b26015fa-a7d4-409c-be8d-3629a5e7d1fa">
 405                                         <property name="com.jaspersoft.studio.unit.width" value="px"/>
 406                                 </reportElement>
 407                                 <textElement markup="styled"/>
 408                                 <text><![CDATA[Publish To]]></text>
 409                         </staticText>
 410                         <staticText>
 411                                 <reportElement style="Column header" x="900" y="0" width="100" height="44" uuid="f06f2010-e1d6-40d0-bae9-68e69d204da7">
 412                                         <property name="com.jaspersoft.studio.unit.width" value="px"/>
 413                                 </reportElement>
 414                                 <textElement markup="styled"/>
 415                                 <text><![CDATA[Instalation Type]]></text>
 416                         </staticText>
 417                         <staticText>
 418                                 <reportElement style="Column header" x="1000" y="0" width="100" height="44" uuid="4a3d8f5c-14c1-47b8-871b-59c7f060cde3">
 419                                         <property name="com.jaspersoft.studio.unit.width" value="px"/>
 420                                 </reportElement>
 421                                 <textElement markup="styled"/>
 422                                 <text><![CDATA[Number of Objects]]></text>
 423                         </staticText>
 424                         <staticText>
 425                                 <reportElement style="Column header" x="1100" y="0" width="100" height="44" uuid="1f803ff8-45b1-4a34-a69b-7a402c51a1f8">
 426                                         <property name="com.jaspersoft.studio.unit.width" value="px"/>
 427                                 </reportElement>
 428                                 <textElement markup="styled"/>
 429                                 <text><![CDATA[Work Type]]></text>
 430                         </staticText>
 431                         <staticText>
 432                                 <reportElement style="Column header" x="1200" y="0" width="100" height="44" uuid="680a42d8-8c37-46a4-97ce-ab3032682f9a">
 433                                         <property name="com.jaspersoft.studio.unit.width" value="px"/>
 434                                 </reportElement>
 435                                 <textElement markup="styled"/>
 436                                 <text><![CDATA[Material]]></text>
 437                         </staticText>
 438                         <staticText>
 439                                 <reportElement style="Column header" x="1300" y="0" width="100" height="44" uuid="3bc81e2e-1cc6-4aea-9aad-cc2ea579e051">
 440                                         <property name="com.jaspersoft.studio.unit.width" value="px"/>
 441                                 </reportElement>
 442                                 <textElement markup="styled"/>
 443                                 <text><![CDATA[Description]]></text>
 444                         </staticText>
 445                         <staticText>
 446                                 <reportElement style="Column header" x="1400" y="0" width="100" height="44" uuid="37ec46eb-d990-470f-a792-e65950e76882">
 447                                         <property name="com.jaspersoft.studio.unit.width" value="px"/>
 448                                 </reportElement>
 449                                 <textElement markup="styled"/>
 450                                 <text><![CDATA[Comments]]></text>
 451                         </staticText>
 452                         <staticText>
 453                                 <reportElement style="Column header" x="1500" y="0" width="100" height="44" uuid="8ee89d69-b9f3-4e1e-8c47-1678bb2ae56e">
 454                                         <property name="com.jaspersoft.studio.unit.width" value="px"/>
 455                                 </reportElement>
 456                                 <textElement markup="styled"/>
 457                                 <text><![CDATA[Collection]]></text>
 458                         </staticText>
 459                         <staticText>
 460                                 <reportElement style="Column header" x="1600" y="0" width="100" height="44" uuid="290145b5-c739-4d89-9e35-52363c4b3539">
 461                                         <property name="com.jaspersoft.studio.unit.width" value="px"/>
 462                                 </reportElement>
 463                                 <textElement markup="styled"/>
 464                                 <text><![CDATA[Owner]]></text>
 465                         </staticText>
 466                         <staticText>
 467                                 <reportElement style="Column header" x="1700" y="0" width="100" height="44" uuid="885c0873-8f95-41ba-aa93-e5b35674d1c9">
 468                                         <property name="com.jaspersoft.studio.unit.width" value="px"/>
 469                                 </reportElement>
 470                                 <textElement markup="styled"/>
 471                                 <text><![CDATA[Measurement]]></text>
 472                         </staticText>
 473                         <staticText>
 474                                 <reportElement style="Column header" x="1800" y="0" width="100" height="44" uuid="e19dde7b-424e-4776-871a-16ce1281a95a">
 475                                         <property name="com.jaspersoft.studio.unit.width" value="px"/>
 476                                 </reportElement>
 477                                 <textElement markup="styled"/>
 478                                 <text><![CDATA[Computed Current Location]]></text>
 479                         </staticText>
 480                         <staticText>
 481                                 <reportElement style="Column header" x="1900" y="0" width="100" height="44" uuid="d77c8825-0788-4ce1-adeb-893f7058f202">
 482                                         <property name="com.jaspersoft.studio.unit.width" value="px"/>
 483                                 </reportElement>
 484                                 <textElement markup="styled"/>
 485                                 <text><![CDATA[Location Note]]></text>
 486                         </staticText>
 487                         <staticText>
 488                                 <reportElement style="Column header" x="2000" y="0" width="100" height="44" uuid="4fd19fa9-d5c8-4795-9249-1ef735a8ff12">
 489                                         <property name="com.jaspersoft.studio.unit.width" value="px"/>
 490                                 </reportElement>
 491                                 <textElement markup="styled"/>
 492                                 <text><![CDATA[Placement Type]]></text>
 493                         </staticText>
 494                         <staticText>
 495                                 <reportElement style="Column header" x="2100" y="0" width="100" height="44" uuid="bd91bea0-2b73-41a1-8e6c-1f98c220f22a">
 496                                         <property name="com.jaspersoft.studio.unit.width" value="px"/>
 497                                 </reportElement>
 498                                 <textElement markup="styled"/>
 499                                 <text><![CDATA[Placement Environment]]></text>
 500                         </staticText>
 501                         <staticText>
 502                                 <reportElement style="Column header" x="2200" y="0" width="100" height="44" uuid="9a719d3b-d547-4726-8af4-bcac3ad56803">
 503                                         <property name="com.jaspersoft.studio.unit.width" value="px"/>
 504                                 </reportElement>
 505                                 <textElement markup="styled"/>
 506                                 <text><![CDATA[Place Type]]></text>
 507                         </staticText>
 508                         <staticText>
 509                                 <reportElement style="Column header" x="2300" y="0" width="100" height="44" uuid="eebb9e8a-e0bf-4b9e-be76-0a773afd16b1">
 510                                         <property name="com.jaspersoft.studio.unit.width" value="px"/>
 511                                 </reportElement>
 512                                 <textElement markup="styled"/>
 513                                 <text><![CDATA[Place Owner]]></text>
 514                         </staticText>
 515                         <staticText>
 516                                 <reportElement style="Column header" x="2400" y="0" width="100" height="44" uuid="37b02046-e9ac-4785-8612-d375eb4d0196">
 517                                         <property name="com.jaspersoft.studio.unit.width" value="px"/>
 518                                 </reportElement>
 519                                 <textElement markup="styled"/>
 520                                 <text><![CDATA[Place Owner Type]]></text>
 521                         </staticText>
 522                         <staticText>
 523                                 <reportElement style="Column header" x="2500" y="0" width="100" height="44" uuid="be336898-6d37-4b12-8c37-00240645c916">
 524                                         <property name="com.jaspersoft.studio.unit.width" value="px"/>
 525                                 </reportElement>
 526                                 <textElement markup="styled"/>
 527                                 <text><![CDATA[Place Owner Date]]></text>
 528                         </staticText>
 529                         <staticText>
 530                                 <reportElement style="Column header" x="2600" y="0" width="100" height="44" uuid="9a98fc55-bec3-4923-bd4d-84aaaf49e785">
 531                                         <property name="com.jaspersoft.studio.unit.width" value="px"/>
 532                                 </reportElement>
 533                                 <textElement markup="styled"/>
 534                                 <text><![CDATA[Place Owner Note]]></text>
 535                         </staticText>
 536                         <staticText>
 537                                 <reportElement style="Column header" x="2700" y="0" width="100" height="44" uuid="82de0dfb-ef9c-4626-924a-4cde835b36ac">
 538                                         <property name="com.jaspersoft.studio.unit.width" value="px"/>
 539                                 </reportElement>
 540                                 <textElement markup="styled"/>
 541                                 <text><![CDATA[Place Address Line 1]]></text>
 542                         </staticText>
 543                         <staticText>
 544                                 <reportElement style="Column header" x="2800" y="0" width="100" height="44" uuid="f8dd2612-4e96-4b5f-ae20-4c91ae301b87">
 545                                         <property name="com.jaspersoft.studio.unit.width" value="px"/>
 546                                 </reportElement>
 547                                 <textElement markup="styled"/>
 548                                 <text><![CDATA[Place Address Line 2]]></text>
 549                         </staticText>
 550                         <staticText>
 551                                 <reportElement style="Column header" x="2900" y="0" width="100" height="44" uuid="cf8bd67c-2041-4f2f-b4f8-a2c7c10eae91">
 552                                         <property name="com.jaspersoft.studio.unit.width" value="px"/>
 553                                 </reportElement>
 554                                 <textElement markup="styled"/>
 555                                 <text><![CDATA[Place Municipality]]></text>
 556                         </staticText>
 557                         <staticText>
 558                                 <reportElement style="Column header" x="3000" y="0" width="100" height="44" uuid="5db09d4f-5dfc-45a1-b785-0459624c8c29">
 559                                         <property name="com.jaspersoft.studio.unit.width" value="px"/>
 560                                 </reportElement>
 561                                 <textElement markup="styled"/>
 562                                 <text><![CDATA[Place State/Province]]></text>
 563                         </staticText>
 564                         <staticText>
 565                                 <reportElement style="Column header" x="3100" y="0" width="100" height="44" uuid="e07cf8ff-7a8f-4966-9791-cbd42167d9c5">
 566                                         <property name="com.jaspersoft.studio.unit.width" value="px"/>
 567                                 </reportElement>
 568                                 <textElement markup="styled"/>
 569                                 <text><![CDATA[Place Country]]></text>
 570                         </staticText>
 571                         <staticText>
 572                                 <reportElement style="Column header" x="3200" y="0" width="100" height="44" uuid="2f8f8a9a-39d1-4b3d-b05b-e8177de4aabc">
 573                                         <property name="com.jaspersoft.studio.unit.width" value="px"/>
 574                                 </reportElement>
 575                                 <textElement markup="styled"/>
 576                                 <text><![CDATA[Place Address Type]]></text>
 577                         </staticText>
 578                         <staticText>
 579                                 <reportElement style="Column header" x="3300" y="0" width="100" height="44" uuid="f4265ca1-12b4-4bd0-986f-2aba295759ad">
 580                                         <property name="com.jaspersoft.studio.unit.width" value="px"/>
 581                                 </reportElement>
 582                                 <textElement markup="styled"/>
 583                                 <text><![CDATA[Place Postal Code]]></text>
 584                         </staticText>
 585                         <staticText>
 586                                 <reportElement style="Column header" x="3400" y="0" width="100" height="44" uuid="aa8f6fe9-6387-4a9e-bbb0-21997c5ff177">
 587                                         <property name="com.jaspersoft.studio.unit.width" value="px"/>
 588                                 </reportElement>
 589                                 <textElement markup="styled"/>
 590                                 <text><![CDATA[Decimal Latitude]]></text>
 591                         </staticText>
 592                         <staticText>
 593                                 <reportElement style="Column header" x="3500" y="0" width="100" height="44" uuid="bdd72a82-b756-44d0-9d3b-8404a422f239">
 594                                         <property name="com.jaspersoft.studio.unit.width" value="px"/>
 595                                 </reportElement>
 596                                 <textElement markup="styled"/>
 597                                 <text><![CDATA[Decimal Longitude]]></text>
 598                         </staticText>
 599                         <staticText>
 600                                 <reportElement style="Column header" x="3600" y="0" width="100" height="44" uuid="d25ecba9-3cf3-4215-9bf2-87d94e244cfc">
 601                                         <property name="com.jaspersoft.studio.unit.width" value="px"/>
 602                                 </reportElement>
 603                                 <textElement markup="styled"/>
 604                                 <text><![CDATA[Hierarchy Broader Place]]></text>
 605                         </staticText>
 606                         <staticText>
 607                                 <reportElement style="Column header" x="3700" y="0" width="100" height="44" uuid="d00d1738-8a2a-48d1-bb75-237eaeecef8a">
 608                                         <property name="com.jaspersoft.studio.unit.width" value="px"/>
 609                                 </reportElement>
 610                                 <textElement markup="styled"/>
 611                                 <text><![CDATA[Place Note]]></text>
 612                         </staticText>
 613                 </band>
 614         </columnHeader>
 615         <detail>
 616                 <band height="66" splitType="Stretch">
 617                         <property name="com.jaspersoft.studio.unit.height" value="px"/>
 618                         <textField textAdjust="StretchHeight" isBlankWhenNull="true">
 619                                 <reportElement style="Detail" x="0" y="0" width="100" height="30" uuid="329d7cca-0e59-4b4b-a9db-a00983705651">
 620                                         <property name="com.jaspersoft.studio.unit.y" value="px"/>
 621                                 </reportElement>
 622                                 <textFieldExpression><![CDATA[$F{objectnumber}]]></textFieldExpression>
 623                         </textField>
 624                         <textField textAdjust="StretchHeight" isBlankWhenNull="true">
 625                                 <reportElement style="Detail" x="100" y="0" width="100" height="30" uuid="e72bd744-d4e6-42c4-88c9-8692c39ae730">
 626                                         <property name="com.jaspersoft.studio.unit.y" value="px"/>
 627                                 </reportElement>
 628                                 <textFieldExpression><![CDATA[$F{title}]]></textFieldExpression>
 629                         </textField>
 630                         <textField textAdjust="StretchHeight" isBlankWhenNull="true">
 631                                 <reportElement style="Detail" x="200" y="0" width="100" height="30" uuid="0f5d4d5e-a6a8-47a0-99bf-291f59c503ca">
 632                                         <property name="com.jaspersoft.studio.unit.y" value="px"/>
 633                                 </reportElement>
 634                                 <textFieldExpression><![CDATA[$F{objectproductiondate}]]></textFieldExpression>
 635                         </textField>
 636                         <textField textAdjust="StretchHeight" isBlankWhenNull="true">
 637                                 <reportElement style="Detail" x="300" y="0" width="100" height="30" uuid="acf887f8-6fdf-45b1-a8ea-041ea46efa4c">
 638                                         <property name="com.jaspersoft.studio.unit.y" value="px"/>
 639                                 </reportElement>
 640                                 <textFieldExpression><![CDATA[$F{publicartproductiondatetype}]]></textFieldExpression>
 641                         </textField>
 642                         <textField textAdjust="StretchHeight" isBlankWhenNull="true">
 643                                 <reportElement style="Detail" x="400" y="0" width="100" height="30" uuid="fd47819e-2277-4105-be4d-e5e9531cd0f1">
 644                                         <property name="com.jaspersoft.studio.unit.y" value="px"/>
 645                                 </reportElement>
 646                                 <textFieldExpression>
 647                                         <![CDATA[
 648                                         var persons = $F{publicartproductionpersons}.getArray();
 649                                         var roles = $F{publicartproductionpersonroles}.getArray();
 650
 651                                         persons.map(function(person, index) {
 652                                                 if (!person) {
 653                                                         return null;
 654                                                 }
 655                                                 var role = roles[index];
 656                                                 return person + ' (' + role + ')';
 657                                         }).filter((value) => !!value).join('; ')
 658                                         ]]>
 659                                 </textFieldExpression>
 660                         </textField>
 661                         <textField textAdjust="StretchHeight" isBlankWhenNull="true">
 662                                 <reportElement style="Detail" x="600" y="0" width="100" height="30" uuid="d71a9e95-c14e-43af-9188-3b270d982adf">
 663                                         <property name="com.jaspersoft.studio.unit.y" value="px"/>
 664                                 </reportElement>
 665                                 <textFieldExpression><![CDATA[$F{responsibledepartment}]]></textFieldExpression>
 666                         </textField>
 667                         <textField textAdjust="StretchHeight" isBlankWhenNull="true">
 668                                 <reportElement style="Detail" x="700" y="0" width="100" height="30" uuid="99b99fe8-9554-475c-aed3-a43a374f8932">
 669                                         <property name="com.jaspersoft.studio.unit.y" value="px"/>
 670                                 </reportElement>
 671                                 <textFieldExpression><![CDATA[$F{recordstatus}]]></textFieldExpression>
 672                         </textField>
 673                         <textField textAdjust="StretchHeight" isBlankWhenNull="true">
 674                                 <reportElement style="Detail" x="800" y="0" width="100" height="30" uuid="3fe28021-38a6-4f05-89e9-543efff1a05d">
 675                                         <property name="com.jaspersoft.studio.unit.y" value="px"/>
 676                                 </reportElement>
 677                                 <textFieldExpression><![CDATA[$F{publishto}]]></textFieldExpression>
 678                         </textField>
 679                         <textField textAdjust="StretchHeight" isBlankWhenNull="true">
 680                                 <reportElement style="Detail" x="900" y="0" width="100" height="30" uuid="42adcc58-f026-49ce-8055-ee5567f40cea">
 681                                         <property name="com.jaspersoft.studio.unit.y" value="px"/>
 682                                 </reportElement>
 683                                 <textFieldExpression><![CDATA[$F{installationtype}]]></textFieldExpression>
 684                         </textField>
 685                         <textField textAdjust="StretchHeight" isBlankWhenNull="true">
 686                                 <reportElement style="Detail" x="1000" y="0" width="100" height="30" uuid="6c173670-a1db-43fa-9bae-138637abf17c">
 687                                         <property name="com.jaspersoft.studio.unit.y" value="px"/>
 688                                 </reportElement>
 689                                 <textFieldExpression><![CDATA[$F{numberofobjects}]]></textFieldExpression>
 690                         </textField>
 691                         <textField textAdjust="StretchHeight" isBlankWhenNull="true">
 692                                 <reportElement style="Detail" x="1100" y="0" width="100" height="30" uuid="f5ed52e8-dee0-4376-bf6c-74ccb891b706">
 693                                         <property name="com.jaspersoft.studio.unit.y" value="px"/>
 694                                 </reportElement>
 695                                 <textFieldExpression><![CDATA[$F{worktypes}.getArray().join('; ')]]></textFieldExpression>
 696                         </textField>
 697                         <textField textAdjust="StretchHeight" isBlankWhenNull="true">
 698                                 <reportElement style="Detail" x="1200" y="0" width="100" height="30" uuid="647d56b4-1d6c-4284-930b-e6a561a0fee2">
 699                                         <property name="com.jaspersoft.studio.unit.y" value="px"/>
 700                                 </reportElement>
 701                                 <textFieldExpression><![CDATA[$F{materials}.getArray().join('; ')]]></textFieldExpression>
 702                         </textField>
 703                         <textField textAdjust="StretchHeight" isBlankWhenNull="true">
 704                                 <reportElement style="Detail" x="1300" y="0" width="100" height="30" uuid="37195d8b-62ca-49a7-85d9-8cc77632657f">
 705                                         <property name="com.jaspersoft.studio.unit.y" value="px"/>
 706                                 </reportElement>
 707                                 <textFieldExpression><![CDATA[$F{briefdescription}]]></textFieldExpression>
 708                         </textField>
 709                         <textField textAdjust="StretchHeight" isBlankWhenNull="true">
 710                                 <reportElement style="Detail" x="1400" y="0" width="100" height="30" uuid="427561d6-0e53-4640-b293-1033427cadb2">
 711                                         <property name="com.jaspersoft.studio.unit.y" value="px"/>
 712                                 </reportElement>
 713                                 <textFieldExpression><![CDATA[$F{comment}]]></textFieldExpression>
 714                         </textField>
 715                         <textField textAdjust="StretchHeight" isBlankWhenNull="true">
 716                                 <reportElement style="Detail" x="1500" y="0" width="100" height="30" uuid="118cecdc-6f8e-4be9-b84a-51095772c449">
 717                                         <property name="com.jaspersoft.studio.unit.y" value="px"/>
 718                                 </reportElement>
 719                                 <textFieldExpression><![CDATA[$F{collections}.getArray().join('; ')]]></textFieldExpression>
 720                         </textField>
 721                         <textField textAdjust="StretchHeight" isBlankWhenNull="true">
 722                                 <reportElement style="Detail" x="1600" y="0" width="100" height="30" uuid="547fe798-a381-4299-bc51-9ab9a003ec93">
 723                                         <property name="com.jaspersoft.studio.unit.y" value="px"/>
 724                                 </reportElement>
 725                                 <textFieldExpression><![CDATA[$F{owner}]]></textFieldExpression>
 726                         </textField>
 727                         <textField textAdjust="StretchHeight" isBlankWhenNull="true">
 728                                 <reportElement style="Detail" x="1700" y="0" width="100" height="30" uuid="ec3253d7-c5dc-42d3-9298-73817aea8471">
 729                                         <property name="com.jaspersoft.studio.unit.y" value="px"/>
 730                                 </reportElement>
 731                                 <textFieldExpression><![CDATA[$F{dimension}]]></textFieldExpression>
 732                         </textField>
 733                         <textField textAdjust="StretchHeight" isBlankWhenNull="true">
 734                                 <reportElement style="Detail" x="1800" y="0" width="100" height="30" uuid="54975571-1a08-4cc2-b2e5-45404db7881a">
 735                                         <property name="com.jaspersoft.studio.unit.y" value="px"/>
 736                                 </reportElement>
 737                                 <textFieldExpression><![CDATA[$F{computedcurrentlocation}]]></textFieldExpression>
 738                         </textField>
 739                         <textField textAdjust="StretchHeight" isBlankWhenNull="true">
 740                                 <reportElement style="Detail" x="1900" y="0" width="100" height="30" uuid="69adde0e-8c36-4298-a462-fe0236bdef81">
 741                                         <property name="com.jaspersoft.studio.unit.y" value="px"/>
 742                                 </reportElement>
 743                                 <textFieldExpression><![CDATA[$F{currentlocationnote}]]></textFieldExpression>
 744                         </textField>
 745                         <textField textAdjust="StretchHeight" isBlankWhenNull="true">
 746                                 <reportElement style="Detail" x="2000" y="0" width="100" height="30" uuid="e703c8f3-255d-4e9b-86c2-6c3ff4a5d57c">
 747                                         <property name="com.jaspersoft.studio.unit.y" value="px"/>
 748                                 </reportElement>
 749                                 <textFieldExpression><![CDATA[$F{placementtype}]]></textFieldExpression>
 750                         </textField>
 751                         <textField textAdjust="StretchHeight" isBlankWhenNull="true">
 752                                 <reportElement style="Detail" x="2100" y="0" width="100" height="30" uuid="bf82c6ce-f8fa-4d71-975d-5aac2739aa36">
 753                                         <property name="com.jaspersoft.studio.unit.y" value="px"/>
 754                                 </reportElement>
 755                                 <textFieldExpression><![CDATA[$F{placementenvironment}]]></textFieldExpression>
 756                         </textField>
 757                         <textField textAdjust="StretchHeight" isBlankWhenNull="true">
 758                                 <reportElement style="Detail" x="2200" y="0" width="100" height="30" uuid="d8b3cb62-ef05-4108-a4d1-91eb6b40daf4">
 759                                         <property name="com.jaspersoft.studio.unit.y" value="px"/>
 760                                 </reportElement>
 761                                 <textFieldExpression><![CDATA[$F{placetype}]]></textFieldExpression>
 762                         </textField>
 763                         <textField textAdjust="StretchHeight" isBlankWhenNull="true">
 764                                 <reportElement style="Detail" x="2300" y="0" width="100" height="30" uuid="0d2aedb2-b30d-46e2-8127-a28616a502c2">
 765                                         <property name="com.jaspersoft.studio.unit.y" value="px"/>
 766                                 </reportElement>
 767                                 <textFieldExpression><![CDATA[$F{placeowner}]]></textFieldExpression>
 768                         </textField>
 769                         <textField textAdjust="StretchHeight" isBlankWhenNull="true">
 770                                 <reportElement style="Detail" x="2400" y="0" width="100" height="30" uuid="555820d4-8200-487a-93c1-55183eac8ce7">
 771                                         <property name="com.jaspersoft.studio.unit.y" value="px"/>
 772                                 </reportElement>
 773                                 <textFieldExpression><![CDATA[$F{ownershipnote}]]></textFieldExpression>
 774                         </textField>
 775                         <textField textAdjust="StretchHeight" isBlankWhenNull="true">
 776                                 <reportElement style="Detail" x="2500" y="0" width="100" height="30" uuid="d1325b38-832f-41ec-97e7-8ba0785fd3ca">
 777                                         <property name="com.jaspersoft.studio.unit.y" value="px"/>
 778                                 </reportElement>
 779                                 <textFieldExpression><![CDATA[$F{ownertype}]]></textFieldExpression>
 780                         </textField>
 781                         <textField textAdjust="StretchHeight" isBlankWhenNull="true">
 782                                 <reportElement style="Detail" x="2600" y="0" width="100" height="30" uuid="a09f4407-8e56-486d-afbd-28103d9d11ee">
 783                                         <property name="com.jaspersoft.studio.unit.y" value="px"/>
 784                                 </reportElement>
 785                                 <textFieldExpression><![CDATA[$F{ownershipdate}]]></textFieldExpression>
 786                         </textField>
 787                         <textField textAdjust="StretchHeight" isBlankWhenNull="true">
 788                                 <reportElement style="Detail" x="2700" y="0" width="100" height="30" uuid="01830e1d-cee3-41fc-b52d-37e03692e5e4">
 789                                         <property name="com.jaspersoft.studio.unit.y" value="px"/>
 790                                 </reportElement>
 791                                 <textFieldExpression><![CDATA[$F{addressplace1}]]></textFieldExpression>
 792                         </textField>
 793                         <textField textAdjust="StretchHeight" isBlankWhenNull="true">
 794                                 <reportElement style="Detail" x="2800" y="0" width="100" height="30" uuid="61fd47ab-c389-4783-bcd5-58950d292f49">
 795                                         <property name="com.jaspersoft.studio.unit.y" value="px"/>
 796                                 </reportElement>
 797                                 <textFieldExpression><![CDATA[$F{addressplace2}]]></textFieldExpression>
 798                         </textField>
 799                         <textField textAdjust="StretchHeight" isBlankWhenNull="true">
 800                                 <reportElement style="Detail" x="2900" y="0" width="100" height="30" uuid="761ae437-27a9-47de-8a86-6d5f49c2b335">
 801                                         <property name="com.jaspersoft.studio.unit.y" value="px"/>
 802                                 </reportElement>
 803                                 <textFieldExpression><![CDATA[$F{addressmunicipality}]]></textFieldExpression>
 804                         </textField>
 805                         <textField textAdjust="StretchHeight" isBlankWhenNull="true">
 806                                 <reportElement style="Detail" x="3000" y="0" width="100" height="30" uuid="34700833-f428-42ea-9d7e-d85c623e37b2">
 807                                         <property name="com.jaspersoft.studio.unit.y" value="px"/>
 808                                 </reportElement>
 809                                 <textFieldExpression><![CDATA[$F{addressstateorprovince}]]></textFieldExpression>
 810                         </textField>
 811                         <textField textAdjust="StretchHeight" isBlankWhenNull="true">
 812                                 <reportElement style="Detail" x="3100" y="0" width="100" height="30" uuid="6f4c695b-869e-4e42-bf7c-099798dcc12a">
 813                                         <property name="com.jaspersoft.studio.unit.y" value="px"/>
 814                                 </reportElement>
 815                                 <textFieldExpression><![CDATA[$F{addresscountry}]]></textFieldExpression>
 816                         </textField>
 817                         <textField textAdjust="StretchHeight" isBlankWhenNull="true">
 818                                 <reportElement style="Detail" x="3200" y="0" width="100" height="30" uuid="b230f942-d14d-4cc8-8ee6-d546cfea4616">
 819                                         <property name="com.jaspersoft.studio.unit.y" value="px"/>
 820                                 </reportElement>
 821                                 <textFieldExpression><![CDATA[$F{addresstype}]]></textFieldExpression>
 822                         </textField>
 823                         <textField textAdjust="StretchHeight" isBlankWhenNull="true">
 824                                 <reportElement style="Detail" x="3300" y="0" width="100" height="30" uuid="d148c0a6-94d0-4509-b2d1-915085cb8a10">
 825                                         <property name="com.jaspersoft.studio.unit.y" value="px"/>
 826                                 </reportElement>
 827                                 <textFieldExpression><![CDATA[$F{addresspostcode}]]></textFieldExpression>
 828                         </textField>
 829                         <textField textAdjust="StretchHeight" isBlankWhenNull="true">
 830                                 <reportElement style="Detail" x="3400" y="0" width="100" height="30" uuid="30a948ed-116f-4eda-bb3f-5ab5f4c2390a">
 831                                         <property name="com.jaspersoft.studio.unit.y" value="px"/>
 832                                 </reportElement>
 833                                 <textFieldExpression><![CDATA[$F{decimallatitude}]]></textFieldExpression>
 834                         </textField>
 835                         <textField textAdjust="StretchHeight" isBlankWhenNull="true">
 836                                 <reportElement style="Detail" x="3500" y="0" width="100" height="30" uuid="90b39e6b-2249-4a2f-95dc-14dc87e0a3b3">
 837                                         <property name="com.jaspersoft.studio.unit.y" value="px"/>
 838                                 </reportElement>
 839                                 <textFieldExpression><![CDATA[$F{decimallongitude}]]></textFieldExpression>
 840                         </textField>
 841                         <textField textAdjust="StretchHeight" isBlankWhenNull="true">
 842                                 <reportElement style="Detail" x="3600" y="0" width="100" height="30" uuid="a3c03608-c101-4a0a-bfee-26acfe5c62e6">
 843                                         <property name="com.jaspersoft.studio.unit.y" value="px"/>
 844                                 </reportElement>
 845                                 <textFieldExpression><![CDATA[$F{broaderplace}]]></textFieldExpression>
 846                         </textField>
 847                         <textField textAdjust="StretchHeight" isBlankWhenNull="true">
 848                                 <reportElement style="Detail" x="3700" y="0" width="100" height="30" uuid="5de64dd8-7f25-4dda-8034-800edc19ff9c">
 849                                         <property name="com.jaspersoft.studio.unit.y" value="px"/>
 850                                 </reportElement>
 851                                 <textFieldExpression><![CDATA[$F{placenote}]]></textFieldExpression>
 852                         </textField>
 853                 </band>
 854         </detail>
 855 </jasperReport>