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="repatriation_request_consultation" language="javascript" pageWidth="1600" pageHeight="800" orientation="Landscape" columnWidth="100" leftMargin="20" rightMargin="20" topMargin="20" bottomMargin="20" isIgnorePagination="true" uuid="6a52b090-4ec9-4176-a09a-8af53b7323f0">
   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["onbehalfof,cultures,sites"]]></defaultValueExpression>
  14         </parameter>
  15         <parameter name="tenantid" class="java.lang.String" isForPrompting="false">
  16                 <defaultValueExpression><![CDATA["1"]]></defaultValueExpression>
  17         </parameter>
  18         <parameter name="csidlist" class="java.lang.String" isForPrompting="false" />
  19         <parameter name="csids" class="java.lang.String" isForPrompting="false">
  20                 <defaultValueExpression><![CDATA[$P{csidlist} != null ? ("'" + $P{csidlist}.replace(/,/g, "','") + "'") : "NOVALUE"]]></defaultValueExpression>
  21         </parameter>
  22         <parameter name="whereclause_cte" class="java.lang.String" isForPrompting="false">
  23                 <defaultValueExpression><![CDATA[$P{csids} != "NOVALUE" ? ( "AND relation.subjectcsid IN (" + $P{csids} + ")" ) : ""]]></defaultValueExpression>
  24         </parameter>
  25         <parameter name="whereclause" class="java.lang.String" isForPrompting="false">
  26                 <defaultValueExpression><![CDATA[$P{csids} != "NOVALUE" ? ( "WHERE rr_hierarchy.name IN (" + $P{csids} + ")" ) : ""]]></defaultValueExpression>
  27         </parameter>
  28         <queryString language="SQL">
  29                 <![CDATA[WITH related_objects AS (
  30         SELECT hierarchy.id as object_id,
  31                 relation.objectcsid,
  32                 relation.subjectcsid as repatriation_csid
  33         FROM relations_common relation
  34                 INNER JOIN hierarchy on hierarchy.name = relation.objectcsid
  35     INNER JOIN misc ON misc.id = relation.id
  36     AND misc.lifecyclestate != 'deleted'
  37         WHERE relation.objectdocumenttype = 'CollectionObject'
  38                 AND relation.subjectdocumenttype = 'RepatriationRequest'
  39                 $P!{whereclause_cte}
  40 ),
  41 related_inventories AS (
  42         SELECT DISTINCT ON (objs.repatriation_csid, hierarchy.id) objs.objectcsid,
  43                 objs.repatriation_csid,
  44                 hierarchy.id as inventory_id,
  45                 relation.subjectcsid as inventory_csid
  46         FROM related_objects objs
  47                 INNER join relations_common relation on relation.objectcsid = objs.objectcsid
  48                 AND relation.subjectdocumenttype = 'NagpraInventory'
  49     INNER JOIN misc ON misc.id = relation.id
  50     AND misc.lifecyclestate != 'deleted'
  51                 INNER JOIN hierarchy on hierarchy.name = relation.subjectcsid
  52 ),
  53 related_summaries AS (
  54         SELECT DISTINCT ON (objs.repatriation_csid, hierarchy.id) objs.objectcsid,
  55                 objs.repatriation_csid,
  56                 hierarchy.id as summary_id,
  57                 relation.subjectcsid as summary_csid
  58         FROM related_objects objs
  59                 INNER join relations_common relation on relation.objectcsid = objs.objectcsid
  60                 AND relation.subjectdocumenttype = 'SummaryDocumentation'
  61     INNER JOIN misc ON misc.id = relation.id
  62     AND misc.lifecyclestate != 'deleted'
  63                 INNER JOIN hierarchy on hierarchy.name = relation.subjectcsid
  64 )
  65 SELECT rr.requestnumber,
  66   rr.requestdate,
  67   rr.title,
  68   coalesce(partiesinvolved.onbehalfof, '{}') AS onbehalfof,
  69   coalesce(culturalgroup.cultures, '{}') AS cultures,
  70   coalesce(object_count.mni_count, 0) AS mni_count,
  71   coalesce(object_count.afo_count, 0) AS afo_count,
  72   coalesce(object_count.ufo_count, 0) AS ufo_count,
  73   coalesce(object_count.ethnographic_count, 0) AS ethnographic_count,
  74         coalesce(archaeological_sites.sites, '{}') AS sites,
  75   coalesce(inventories.titles, '{}') AS inventory_titles,
  76   coalesce(inventory_count.count, 0) AS inventory_count,
  77   coalesce(summaries.titles, '{}') AS summary_titles,
  78   coalesce(summary_count.count, 0) AS summary_count,
  79   coalesce(consultations.log_total, 0) AS log_total
  80 FROM hierarchy rr_hierarchy
  81         INNER JOIN misc ON misc.id = rr_hierarchy.id AND misc.lifecyclestate != 'deleted'
  82         INNER JOIN repatriationrequests_common rr ON rr.id = rr_hierarchy.id
  83         LEFT JOIN (
  84                 SELECT hierarchy.parentid,
  85                         array_agg(party.involvedonbehalfof) as onbehalfof
  86                 FROM hierarchy
  87                         INNER JOIN partiesinvolvedgroup party ON party.id = hierarchy.id
  88                 WHERE hierarchy.name = 'repatriationrequests_common:partiesInvolvedGroupList'
  89                 GROUP BY hierarchy.parentid
  90         ) partiesinvolved ON partiesinvolved.parentid = rr_hierarchy.id
  91         LEFT JOIN (
  92                 SELECT hierarchy.parentid,
  93                  array_agg(culturalgroup.culture) AS cultures
  94                 FROM hierarchy
  95                         INNER JOIN culturalgroup ON culturalgroup.id = hierarchy.id
  96                         AND hierarchy.name = 'repatriationrequests_common:culturalGroupList'
  97                 GROUP BY hierarchy.parentid
  98         ) culturalgroup ON culturalgroup.parentid = rr_hierarchy.id --LEFT JOIN LATERAL (
  99         LEFT JOIN LATERAL (
 100                 -- Related Object data
 101                 -- Use regex matching because the refnames can contain subsets of the others,
 102                 -- so occasionally do things like use a word boundary (\y) to avoid overlaps
 103                 SELECT objs.repatriation_csid,
 104                         sum(
 105                                 CASE
 106                                         WHEN ocg.objectcounttype ~ 'minimum' THEN ocg.objectcount
 107                                         ELSE 0
 108                                 END
 109                         ) AS mni_count,
 110                         sum(
 111                                 CASE
 112                                         WHEN ocg.objectcounttype ~ '\yassociated' THEN ocg.objectcount
 113                                         ELSE 0
 114                                 END
 115                         ) AS afo_count,
 116                         sum(
 117                                 CASE
 118                                         WHEN ocg.objectcounttype ~ 'unassociated' THEN ocg.objectcount
 119                                         ELSE 0
 120                                 END
 121                         ) AS ufo_count,
 122                         sum(
 123                                 CASE
 124                                         WHEN ocg.objectcounttype ~ 'ethnographic' THEN ocg.objectcount
 125                                         ELSE 0
 126                                 END
 127                         ) AS ethnographic_count
 128                 FROM hierarchy ocg_hierarchy
 129                         INNER JOIN related_objects objs ON objs.object_id = ocg_hierarchy.parentid
 130                         INNER JOIN objectcountgroup ocg ON ocg.id = ocg_hierarchy.id
 131                 WHERE ocg_hierarchy.name = 'collectionobjects_common:objectCountGroupList'
 132                 GROUP BY objs.repatriation_csid
 133         ) object_count ON object_count.repatriation_csid = rr_hierarchy.name
 134         LEFT JOIN (
 135                 SELECT related_objects.repatriation_csid,
 136                         array_agg(fcs.item) as sites
 137                 FROM collectionobjects_common_fieldcollectionsites fcs
 138                         INNER JOIN related_objects on related_objects.object_id = fcs.id
 139                 GROUP BY related_objects.repatriation_csid
 140         ) archaeological_sites ON archaeological_sites.repatriation_csid = rr_hierarchy.name
 141   LEFT JOIN (
 142     -- Related NAGPRA Inventory (Claim -> Object -> Inventory)
 143     -- Number of associated NAGPRA inventory records.
 144     SELECT related_inventories.repatriation_csid,
 145       count(related_inventories.inventory_id)
 146     FROM related_inventories
 147     GROUP BY related_inventories.repatriation_csid
 148   ) inventory_count ON inventory_count.repatriation_csid = rr_hierarchy.name
 149         LEFT JOIN (
 150                 -- Related NAGPRA Inventory (Claim -> Object -> Inventory)
 151                 -- Inventory Title: Pull titles for all inventories related to the related objects, concatenate into one field separated by a ;
 152                 SELECT related_inventories.repatriation_csid,
 153                         array_agg(title.item) as titles
 154                 FROM nagprainventories_common inventory
 155                         INNER JOIN related_inventories on related_inventories.inventory_id = inventory.id
 156                         LEFT JOIN nagprainventories_common_titles title on title.id = inventory.id
 157                 GROUP BY related_inventories.repatriation_csid
 158         ) inventories ON inventories.repatriation_csid = rr_hierarchy.name
 159   LEFT JOIN (
 160     -- Related Summary Documentation (Claim -> Object -> Summary Documentation)
 161     -- Number of associated Summary records.
 162     SELECT related_summaries.repatriation_csid,
 163       count(related_summaries.summary_id)
 164     FROM related_summaries
 165     GROUP BY related_summaries.repatriation_csid
 166   ) summary_count ON summary_count.repatriation_csid = rr_hierarchy.name
 167         LEFT JOIN (
 168                 -- Related Summary Documentation (Claim -> Object -> Summary Documentation)
 169                 -- Summary Title: Pull titles for all summaries related to objects, concatenate into one field separated by a ;
 170                 SELECT related_summaries.repatriation_csid,
 171                         array_agg(title.item) as titles
 172                 FROM summarydocumentations_common summary
 173                         INNER JOIN related_summaries on related_summaries.summary_id = summary.id
 174                         LEFT JOIN summarydocumentations_common_titles title on title.id = summary.id
 175                 GROUP BY related_summaries.repatriation_csid
 176         ) summaries ON summaries.repatriation_csid = rr_hierarchy.name
 177         LEFT JOIN (
 178                 -- Related Consultations (Claim -> Consultation)
 179                 -- Number of Consultation Log Entries. Consultations related to the Claim record, pull a count of how many entries are in the log.
 180                 SELECT relation.subjectcsid,
 181                         count(cl_hierarchy.pos) AS log_total
 182                 FROM relations_common relation
 183                         INNER JOIN misc ON misc.id = relation.id
 184                         AND misc.lifecyclestate != 'deleted'
 185                         INNER JOIN hierarchy consultation_hierarchy ON consultation_hierarchy.name = relation.objectcsid
 186                         INNER JOIN hierarchy cl_hierarchy ON cl_hierarchy.parentid = consultation_hierarchy.id
 187                         AND cl_hierarchy.name = 'consultations_common:consultationLogGroupList'
 188                 WHERE relation.objectdocumenttype = 'Consultation'
 189                         AND relation.subjectdocumenttype = 'RepatriationRequest'
 190                         $P!{whereclause_cte}
 191                 GROUP BY relation.subjectcsid
 192         ) consultations ON consultations.subjectcsid = rr_hierarchy.name
 193         $P!{whereclause}]]>
 194         </queryString>
 195         <field name="requestnumber" class="java.lang.String">
 196                 <property name="com.jaspersoft.studio.field.name" value="requestnumber" />
 197                 <property name="com.jaspersoft.studio.field.label" value="requestnumber" />
 198                 <property name="com.jaspersoft.studio.field.tree.path" value="repatriationrequests_common" />
 199         </field>
 200         <field name="requestdate" class="java.sql.Timestamp">
 201                 <property name="com.jaspersoft.studio.field.name" value="requestdate" />
 202                 <property name="com.jaspersoft.studio.field.label" value="requestdate" />
 203                 <property name="com.jaspersoft.studio.field.tree.path" value="repatriationrequests_common" />
 204         </field>
 205         <field name="title" class="java.lang.String">
 206                 <property name="com.jaspersoft.studio.field.name" value="title" />
 207                 <property name="com.jaspersoft.studio.field.label" value="title" />
 208                 <property name="com.jaspersoft.studio.field.tree.path" value="repatriationrequests_common" />
 209         </field>
 210         <field name="onbehalfof" class="java.sql.Array">
 211                 <property name="com.jaspersoft.studio.field.name" value="onbehalfof" />
 212                 <property name="com.jaspersoft.studio.field.label" value="onbehalfof" />
 213         </field>
 214         <field name="cultures" class="java.sql.Array">
 215                 <property name="com.jaspersoft.studio.field.name" value="cultures" />
 216                 <property name="com.jaspersoft.studio.field.label" value="cultures" />
 217         </field>
 218         <field name="mni_count" class="java.math.BigDecimal">
 219                 <property name="com.jaspersoft.studio.field.name" value="mni_count" />
 220                 <property name="com.jaspersoft.studio.field.label" value="mni_count" />
 221         </field>
 222         <field name="afo_count" class="java.math.BigDecimal">
 223                 <property name="com.jaspersoft.studio.field.name" value="afo_count" />
 224                 <property name="com.jaspersoft.studio.field.label" value="afo_count" />
 225         </field>
 226         <field name="ufo_count" class="java.math.BigDecimal">
 227                 <property name="com.jaspersoft.studio.field.name" value="ufo_count" />
 228                 <property name="com.jaspersoft.studio.field.label" value="ufo_count" />
 229         </field>
 230         <field name="ethnographic_count" class="java.math.BigDecimal">
 231                 <property name="com.jaspersoft.studio.field.name" value="ethnographic_count" />
 232                 <property name="com.jaspersoft.studio.field.label" value="ethnographic_count" />
 233         </field>
 234         <field name="inventory_titles" class="java.sql.Array">
 235                 <property name="com.jaspersoft.studio.field.name" value="inventory_titles" />
 236                 <property name="com.jaspersoft.studio.field.label" value="inventory_titles" />
 237         </field>
 238         <field name="inventory_count" class="java.lang.Long">
 239                 <property name="com.jaspersoft.studio.field.name" value="inventory_count" />
 240                 <property name="com.jaspersoft.studio.field.label" value="inventory_count" />
 241         </field>
 242         <field name="summary_titles" class="java.sql.Array">
 243                 <property name="com.jaspersoft.studio.field.name" value="summary_titles" />
 244                 <property name="com.jaspersoft.studio.field.label" value="summary_titles" />
 245         </field>
 246         <field name="summary_count" class="java.lang.Long">
 247                 <property name="com.jaspersoft.studio.field.name" value="summary_count" />
 248                 <property name="com.jaspersoft.studio.field.label" value="summary_count" />
 249         </field>
 250         <field name="log_total" class="java.lang.Long">
 251                 <property name="com.jaspersoft.studio.field.name" value="log_total" />
 252                 <property name="com.jaspersoft.studio.field.label" value="log_total" />
 253         </field>
 254         <field name="sites" class="java.sql.Array">
 255                 <property name="com.jaspersoft.studio.field.name" value="sites" />
 256                 <property name="com.jaspersoft.studio.field.label" value="sites" />
 257         </field>
 258         <background>
 259                 <band splitType="Stretch" />
 260         </background>
 261         <columnHeader>
 262                 <band height="60" splitType="Stretch">
 263                         <property name="com.jaspersoft.studio.layout" value="com.jaspersoft.studio.editor.layout.FreeLayout" />
 264                         <property name="com.jaspersoft.studio.unit.height" value="px" />
 265                         <staticText>
 266                                 <reportElement style="Column header" x="0" y="0" width="100" height="60" uuid="8b729164-1e04-4ea5-8f0e-6be11fcd24a9">
 267                                         <property name="com.jaspersoft.studio.unit.width" value="px" />
 268                                 </reportElement>
 269                                 <textElement markup="styled" />
 270                                 <text><![CDATA[Organization(s)]]></text>
 271                         </staticText>
 272                         <staticText>
 273                                 <reportElement style="Column header" x="100" y="0" width="100" height="60" uuid="888a4b38-9b27-457e-91e1-ffa1882b659a">
 274                                         <property name="com.jaspersoft.studio.unit.width" value="px" />
 275                                 </reportElement>
 276                                 <textElement markup="styled" />
 277                                 <text><![CDATA[Repatriation Request Origination Date]]></text>
 278                         </staticText>
 279                         <staticText>
 280                                 <reportElement style="Column header" x="200" y="0" width="100" height="60" uuid="fef83b09-5b96-45cc-8a9a-2e59fc3baf60">
 281                                         <property name="com.jaspersoft.studio.unit.width" value="px" />
 282                                 </reportElement>
 283                                 <textElement markup="styled" />
 284                                 <text><![CDATA[Repatriation Request Number]]></text>
 285                         </staticText>
 286                         <staticText>
 287                                 <reportElement style="Column header" x="300" y="0" width="100" height="60" uuid="f3636866-52a2-49ac-b609-2a58bcc53047">
 288                                         <property name="com.jaspersoft.studio.unit.width" value="px" />
 289                                 </reportElement>
 290                                 <textElement markup="styled" />
 291                                 <text><![CDATA[Repatriation Request Name]]></text>
 292                         </staticText>
 293                         <staticText>
 294                                 <reportElement style="Column header" x="400" y="0" width="100" height="60" uuid="0efc36d1-4e40-46e9-b650-71afe6d73692">
 295                                         <property name="com.jaspersoft.studio.unit.width" value="px" />
 296                                 </reportElement>
 297                                 <textElement markup="styled" />
 298                                 <text><![CDATA[MNI Count]]></text>
 299                         </staticText>
 300                         <staticText>
 301                                 <reportElement style="Column header" x="500" y="0" width="100" height="60" uuid="edfbd25f-31aa-49c9-aa15-3834efc57ac1">
 302                                         <property name="com.jaspersoft.studio.unit.width" value="px" />
 303                                 </reportElement>
 304                                 <textElement markup="styled" />
 305                                 <text><![CDATA[AFO Count]]></text>
 306                         </staticText>
 307                         <staticText>
 308                                 <reportElement style="Column header" x="600" y="0" width="100" height="60" uuid="906e84f6-068d-4e6b-bb09-99c6aae85fbc">
 309                                         <property name="com.jaspersoft.studio.unit.width" value="px" />
 310                                 </reportElement>
 311                                 <textElement markup="styled" />
 312                                 <text><![CDATA[UFO Count]]></text>
 313                         </staticText>
 314                         <staticText>
 315                                 <reportElement style="Column header" x="700" y="0" width="100" height="60" uuid="2daa4c02-9105-4701-ad08-c28a0830725a">
 316                                         <property name="com.jaspersoft.studio.unit.width" value="px" />
 317                                 </reportElement>
 318                                 <textElement markup="styled" />
 319                                 <text><![CDATA[Ethnographic Belongings Repatriation Request]]></text>
 320                         </staticText>
 321                         <staticText>
 322                                 <reportElement style="Column header" x="800" y="0" width="100" height="60" uuid="a672b0d8-60c7-4ad6-a47e-abe724790fe8">
 323                                         <property name="com.jaspersoft.studio.unit.width" value="px" />
 324                                 </reportElement>
 325                                 <textElement markup="styled" />
 326                                 <text><![CDATA[Culture(s) Related to Repatriation Request]]></text>
 327                         </staticText>
 328                         <staticText>
 329                                 <reportElement style="Column header" x="900" y="0" width="100" height="60" uuid="4db40578-bd05-4689-935f-4c6c00dc6f2a">
 330                                         <property name="com.jaspersoft.studio.unit.width" value="px"/>
 331                                 </reportElement>
 332                                 <textElement markup="styled"/>
 333                                 <text><![CDATA[Site(s) Related to Repatriation Request]]></text>
 334                         </staticText>
 335                         <staticText>
 336                                 <reportElement style="Column header" x="1000" y="0" width="100" height="60" uuid="8d8d804b-e4f2-4cb7-84a1-0fc343babd25">
 337                                         <property name="com.jaspersoft.studio.unit.width" value="px" />
 338                                 </reportElement>
 339                                 <textElement markup="styled" />
 340                                 <text><![CDATA[Number of Associated NAGPRA Inventory Record(s)]]></text>
 341                         </staticText>
 342                         <staticText>
 343                                 <reportElement style="Column header" x="1100" y="0" width="100" height="60" uuid="9ba161bf-860a-4d46-9914-34ccd4072209">
 344                                         <property name="com.jaspersoft.studio.unit.width" value="px" />
 345                                 </reportElement>
 346                                 <textElement markup="styled" />
 347                                 <text><![CDATA[Title of NAGPRA Inventory Record(s)]]></text>
 348                         </staticText>
 349                         <staticText>
 350                                 <reportElement style="Column header" x="1200" y="0" width="100" height="60" uuid="dd4ef24d-c3fd-4f1c-ac95-bbe21171030a">
 351                                         <property name="com.jaspersoft.studio.unit.width" value="px" />
 352                                 </reportElement>
 353                                 <textElement markup="styled" />
 354                                 <text><![CDATA[Number of Associated Summary Documentation Records]]></text>
 355                         </staticText>
 356                         <staticText>
 357                                 <reportElement style="Column header" x="1300" y="0" width="100" height="60" uuid="711eac26-05f5-4868-bbab-9a77bfb223d0">
 358                                         <property name="com.jaspersoft.studio.unit.width" value="px" />
 359                                 </reportElement>
 360                                 <textElement markup="styled" />
 361                                 <text><![CDATA[Summary Documentation Title]]></text>
 362                         </staticText>
 363                         <staticText>
 364                                 <reportElement style="Column header" x="1400" y="0" width="100" height="60" uuid="3806b552-a19e-4535-b2f5-cee59f3410b4">
 365                                         <property name="com.jaspersoft.studio.unit.width" value="px" />
 366                                 </reportElement>
 367                                 <textElement markup="styled" />
 368                                 <text><![CDATA[Number of Associated Consultation Log Entries]]></text>
 369                         </staticText>
 370                 </band>
 371         </columnHeader>
 372         <detail>
 373                 <band height="66" splitType="Stretch">
 374                         <property name="com.jaspersoft.studio.unit.height" value="px" />
 375                         <textField textAdjust="StretchHeight" isBlankWhenNull="true">
 376                                 <reportElement style="Detail" x="0" y="0" width="100" height="30" uuid="064b56f8-1692-495a-a537-4ef6461cfc6d">
 377                                         <property name="com.jaspersoft.studio.unit.y" value="px" />
 378                                 </reportElement>
 379                                 <textFieldExpression><![CDATA[$F{onbehalfof}.getArray().filter((val) => !!val).join('; ')]]></textFieldExpression>
 380                         </textField>
 381                         <textField textAdjust="StretchHeight" isBlankWhenNull="true">
 382                                 <reportElement style="Detail" x="100" y="0" width="100" height="30" uuid="89b571d2-50e1-47bf-bf2d-f8a24b944ec8">
 383                                         <property name="com.jaspersoft.studio.unit.y" value="px" />
 384                                 </reportElement>
 385                                 <textFieldExpression><![CDATA[$F{requestdate} !== null ? $F{requestdate}.toLocalDateTime().toLocalDate() : '']]></textFieldExpression>
 386                         </textField>
 387                         <textField textAdjust="StretchHeight" isBlankWhenNull="true">
 388                                 <reportElement style="Detail" x="200" y="0" width="100" height="30" uuid="f7d5770e-a729-457b-a39f-9b1f05c980d3">
 389                                         <property name="com.jaspersoft.studio.unit.y" value="px" />
 390                                 </reportElement>
 391                                 <textFieldExpression><![CDATA[$F{requestnumber}]]></textFieldExpression>
 392                         </textField>
 393                         <textField textAdjust="StretchHeight" isBlankWhenNull="true">
 394                                 <reportElement style="Detail" x="300" y="0" width="100" height="30" uuid="4f536bed-b62a-4a53-97ce-81f1fafc0c94">
 395                                         <property name="com.jaspersoft.studio.unit.y" value="px" />
 396                                 </reportElement>
 397                                 <textFieldExpression><![CDATA[$F{title}]]></textFieldExpression>
 398                         </textField>
 399                         <textField textAdjust="StretchHeight" isBlankWhenNull="true">
 400                                 <reportElement style="Detail" x="400" y="0" width="100" height="30" uuid="460dc3a8-b239-4472-b2a3-1bb8be0980e9">
 401                                         <property name="com.jaspersoft.studio.unit.y" value="px" />
 402                                 </reportElement>
 403                                 <textFieldExpression><![CDATA[$F{mni_count}]]></textFieldExpression>
 404                         </textField>
 405                         <textField textAdjust="StretchHeight" isBlankWhenNull="true">
 406                                 <reportElement style="Detail" x="500" y="0" width="100" height="30" uuid="43c1f876-745f-4f14-9c08-8cee4b02575a">
 407                                         <property name="com.jaspersoft.studio.unit.y" value="px" />
 408                                 </reportElement>
 409                                 <textFieldExpression><![CDATA[$F{afo_count}]]></textFieldExpression>
 410                         </textField>
 411                         <textField textAdjust="StretchHeight" isBlankWhenNull="true">
 412                                 <reportElement style="Detail" x="600" y="0" width="100" height="30" uuid="9f75ab33-ec3b-42fd-a1be-16caa9254291">
 413                                         <property name="com.jaspersoft.studio.unit.y" value="px" />
 414                                 </reportElement>
 415                                 <textFieldExpression><![CDATA[$F{ufo_count}]]></textFieldExpression>
 416                         </textField>
 417                         <textField textAdjust="StretchHeight" isBlankWhenNull="true">
 418                                 <reportElement style="Detail" x="700" y="0" width="100" height="30" uuid="91f7ab7a-d0c4-4d79-af7c-372fb8222baa">
 419                                         <property name="com.jaspersoft.studio.unit.y" value="px" />
 420                                 </reportElement>
 421                                 <textFieldExpression><![CDATA[$F{ethnographic_count}]]></textFieldExpression>
 422                         </textField>
 423                         <textField textAdjust="StretchHeight" isBlankWhenNull="true">
 424                                 <reportElement style="Detail" x="800" y="0" width="100" height="30" uuid="68f1bf63-5f1a-497e-a132-af81b2634348">
 425                                         <property name="com.jaspersoft.studio.unit.y" value="px" />
 426                                 </reportElement>
 427                                 <textFieldExpression><![CDATA[$F{cultures}.getArray().filter((val) => !!val).join('; ')]]></textFieldExpression>
 428                         </textField>
 429                         <textField textAdjust="StretchHeight" isBlankWhenNull="true">
 430                                 <reportElement style="Detail" x="900" y="0" width="100" height="30" uuid="af734fab-e383-4813-b108-1d1e70e7989e">
 431                                         <property name="com.jaspersoft.studio.unit.y" value="px"/>
 432                                 </reportElement>
 433                                 <textFieldExpression><![CDATA[$F{sites}.getArray().filter((site) => !!site).join('; ')]]></textFieldExpression>
 434                         </textField>
 435                         <textField textAdjust="StretchHeight" isBlankWhenNull="true">
 436                                 <reportElement style="Detail" x="1000" y="0" width="100" height="30" uuid="7d87ad02-5a25-4e8c-88ae-537ecd7a1fe1">
 437                                         <property name="com.jaspersoft.studio.unit.y" value="px" />
 438                                 </reportElement>
 439                                 <textFieldExpression><![CDATA[$F{inventory_count}]]></textFieldExpression>
 440                         </textField>
 441                         <textField textAdjust="StretchHeight" isBlankWhenNull="true">
 442                                 <reportElement style="Detail" x="1100" y="0" width="100" height="30" uuid="a8f2a24f-31fc-46e8-a52d-175e372223a8">
 443                                         <property name="com.jaspersoft.studio.unit.y" value="px" />
 444                                 </reportElement>
 445                                 <textFieldExpression><![CDATA[$F{inventory_titles}.getArray().filter(val => !!val).join('; ')]]></textFieldExpression>
 446                         </textField>
 447                         <textField textAdjust="StretchHeight" isBlankWhenNull="true">
 448                                 <reportElement style="Detail" x="1200" y="0" width="100" height="30" uuid="a84fbf28-7959-412f-b391-d7a1a222c9d0">
 449                                         <property name="com.jaspersoft.studio.unit.y" value="px" />
 450                                 </reportElement>
 451                                 <textFieldExpression><![CDATA[$F{summary_count}]]></textFieldExpression>
 452                         </textField>
 453                         <textField textAdjust="StretchHeight" isBlankWhenNull="true">
 454                                 <reportElement style="Detail" x="1300" y="0" width="100" height="30" uuid="38c63f53-35bf-4b7b-8e17-11287df5e98c">
 455                                         <property name="com.jaspersoft.studio.unit.y" value="px" />
 456                                 </reportElement>
 457                                 <textFieldExpression><![CDATA[$F{summary_titles}.getArray().filter((val) => !!val).join('; ')]]></textFieldExpression>
 458                         </textField>
 459                         <textField textAdjust="StretchHeight" isBlankWhenNull="true">
 460                                 <reportElement style="Detail" x="1400" y="0" width="100" height="30" uuid="c39e0311-64b2-425e-a63d-31279c0eeb07">
 461                                         <property name="com.jaspersoft.studio.unit.y" value="px" />
 462                                 </reportElement>
 463                                 <textFieldExpression><![CDATA[$F{log_total}]]></textFieldExpression>
 464                         </textField>
 465                 </band>
 466         </detail>
 467 </jasperReport>