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