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