From 71c9245c025cd2d8ee29b158b81b6af79a16dce8 Mon Sep 17 00:00:00 2001 From: Michael Ritter Date: Mon, 5 Jun 2023 19:31:13 -0600 Subject: [PATCH] Set overflow and null rules for results (#352) --- .../src/main/resources/accessions.jrxml | 36 ++++---- .../src/main/resources/box_list.jrxml | 10 +-- .../src/main/resources/condition.jrxml | 48 +++++----- .../src/main/resources/deaccessions.jrxml | 88 +++++++++---------- .../src/main/resources/deed_of_gift.jrxml | 26 +++--- .../src/main/resources/incoming_loan.jrxml | 40 ++++----- .../main/resources/incoming_loan_letter.jrxml | 22 ++--- .../resources/obj_computed_location.jrxml | 12 +-- .../resources/obj_current_place_details.jrxml | 42 ++++----- .../src/main/resources/outgoing_loan.jrxml | 40 ++++----- .../main/resources/outgoing_loan_letter.jrxml | 22 ++--- .../src/main/resources/referral.jrxml | 52 +++++------ .../resources/tombstone_with_budget.jrxml | 30 +++---- .../resources/tombstone_with_creator.jrxml | 28 +++--- 14 files changed, 248 insertions(+), 248 deletions(-) diff --git a/services/report/3rdparty/jasper-cs-report/src/main/resources/accessions.jrxml b/services/report/3rdparty/jasper-cs-report/src/main/resources/accessions.jrxml index 31b562bae..ddd81e58e 100644 --- a/services/report/3rdparty/jasper-cs-report/src/main/resources/accessions.jrxml +++ b/services/report/3rdparty/jasper-cs-report/src/main/resources/accessions.jrxml @@ -356,109 +356,109 @@ LEFT JOIN related_media media ON media.objcsid = obj.csid]]> - + - + - + - + - + - + - + - + - + - + - + - + - + - + - + - + - + - + diff --git a/services/report/3rdparty/jasper-cs-report/src/main/resources/box_list.jrxml b/services/report/3rdparty/jasper-cs-report/src/main/resources/box_list.jrxml index b8a4adb84..d72a693ca 100644 --- a/services/report/3rdparty/jasper-cs-report/src/main/resources/box_list.jrxml +++ b/services/report/3rdparty/jasper-cs-report/src/main/resources/box_list.jrxml @@ -145,34 +145,34 @@ LEFT OUTER JOIN thumbnails ON thumbnails.objectcsid = co.csid]]> - + - + - + - + - + diff --git a/services/report/3rdparty/jasper-cs-report/src/main/resources/condition.jrxml b/services/report/3rdparty/jasper-cs-report/src/main/resources/condition.jrxml index 87e67848e..60792aaca 100644 --- a/services/report/3rdparty/jasper-cs-report/src/main/resources/condition.jrxml +++ b/services/report/3rdparty/jasper-cs-report/src/main/resources/condition.jrxml @@ -425,145 +425,145 @@ $P!{whereclause}]]> - + - + - + - + - + - + - + - + - + - + - + - + - + - + - + - + - + - + - + - + - + - + - + - + diff --git a/services/report/3rdparty/jasper-cs-report/src/main/resources/deaccessions.jrxml b/services/report/3rdparty/jasper-cs-report/src/main/resources/deaccessions.jrxml index ee0e7f65b..6a3041ce9 100644 --- a/services/report/3rdparty/jasper-cs-report/src/main/resources/deaccessions.jrxml +++ b/services/report/3rdparty/jasper-cs-report/src/main/resources/deaccessions.jrxml @@ -753,265 +753,265 @@ LEFT JOIN related_intakes intake ON intake.exitcsid = exit.csid]]> - + - + - + - + - + - + - + - + - + - + - + - + - + - + - + - + - + - + - + - + - + - + - + - + - + - + - + - + - + - + - + - + - + - + - + - + - + - + - + - + - + - + - + - + diff --git a/services/report/3rdparty/jasper-cs-report/src/main/resources/deed_of_gift.jrxml b/services/report/3rdparty/jasper-cs-report/src/main/resources/deed_of_gift.jrxml index 3216b527f..bb53ca42b 100644 --- a/services/report/3rdparty/jasper-cs-report/src/main/resources/deed_of_gift.jrxml +++ b/services/report/3rdparty/jasper-cs-report/src/main/resources/deed_of_gift.jrxml @@ -300,91 +300,91 @@ left join related_object_media media on media.objcsid = obj.csid]]> - + - + - + - + - + - + - + - + - + - + - + - + - + diff --git a/services/report/3rdparty/jasper-cs-report/src/main/resources/incoming_loan.jrxml b/services/report/3rdparty/jasper-cs-report/src/main/resources/incoming_loan.jrxml index 95c5dbb41..82b8571d8 100644 --- a/services/report/3rdparty/jasper-cs-report/src/main/resources/incoming_loan.jrxml +++ b/services/report/3rdparty/jasper-cs-report/src/main/resources/incoming_loan.jrxml @@ -349,121 +349,121 @@ $P!{whereclause}]]> - + - + - + - + - + - + - + - + - + - + - + - + - + - + - + - + - + - + - + - + diff --git a/services/report/3rdparty/jasper-cs-report/src/main/resources/incoming_loan_letter.jrxml b/services/report/3rdparty/jasper-cs-report/src/main/resources/incoming_loan_letter.jrxml index 1ff4f5a0f..68f5492d4 100644 --- a/services/report/3rdparty/jasper-cs-report/src/main/resources/incoming_loan_letter.jrxml +++ b/services/report/3rdparty/jasper-cs-report/src/main/resources/incoming_loan_letter.jrxml @@ -235,62 +235,62 @@ left outer join person_contacts pc on pc.loanid = loanin.csid]]> - + - + - + - + - + - + - + - + - + - + @@ -298,7 +298,7 @@ left outer join person_contacts pc on pc.loanid = loanin.csid]]> - + diff --git a/services/report/3rdparty/jasper-cs-report/src/main/resources/obj_computed_location.jrxml b/services/report/3rdparty/jasper-cs-report/src/main/resources/obj_computed_location.jrxml index cc8693299..78f70208b 100644 --- a/services/report/3rdparty/jasper-cs-report/src/main/resources/obj_computed_location.jrxml +++ b/services/report/3rdparty/jasper-cs-report/src/main/resources/obj_computed_location.jrxml @@ -178,37 +178,37 @@ $P!{whereclause}]]> - + - + - + - + - + - + diff --git a/services/report/3rdparty/jasper-cs-report/src/main/resources/obj_current_place_details.jrxml b/services/report/3rdparty/jasper-cs-report/src/main/resources/obj_current_place_details.jrxml index 1daa382bc..682b94ef9 100644 --- a/services/report/3rdparty/jasper-cs-report/src/main/resources/obj_current_place_details.jrxml +++ b/services/report/3rdparty/jasper-cs-report/src/main/resources/obj_current_place_details.jrxml @@ -359,127 +359,127 @@ LEFT JOIN movements mvmt ON mvmt.objcsid = object.csid]]> - + - + - + - + - + - + - + - + - + - + - + - + - + - + - + - + - + - + - + - + - + diff --git a/services/report/3rdparty/jasper-cs-report/src/main/resources/outgoing_loan.jrxml b/services/report/3rdparty/jasper-cs-report/src/main/resources/outgoing_loan.jrxml index ce5e1d0fd..82e39f5c4 100644 --- a/services/report/3rdparty/jasper-cs-report/src/main/resources/outgoing_loan.jrxml +++ b/services/report/3rdparty/jasper-cs-report/src/main/resources/outgoing_loan.jrxml @@ -356,121 +356,121 @@ $P!{whereclause} - + - + - + - + - + - + - + - + - + - + - + - + - + - + - + - + - + - + - + - + diff --git a/services/report/3rdparty/jasper-cs-report/src/main/resources/outgoing_loan_letter.jrxml b/services/report/3rdparty/jasper-cs-report/src/main/resources/outgoing_loan_letter.jrxml index ef895f3e0..490ab5f4a 100644 --- a/services/report/3rdparty/jasper-cs-report/src/main/resources/outgoing_loan_letter.jrxml +++ b/services/report/3rdparty/jasper-cs-report/src/main/resources/outgoing_loan_letter.jrxml @@ -237,62 +237,62 @@ left outer join contacts c on c.loancsid = loanout.csid]]> - + - + - + - + - + - + - + - + - + - + @@ -300,7 +300,7 @@ left outer join contacts c on c.loancsid = loanout.csid]]> - + diff --git a/services/report/3rdparty/jasper-cs-report/src/main/resources/referral.jrxml b/services/report/3rdparty/jasper-cs-report/src/main/resources/referral.jrxml index e865bf5bf..bef84d783 100644 --- a/services/report/3rdparty/jasper-cs-report/src/main/resources/referral.jrxml +++ b/services/report/3rdparty/jasper-cs-report/src/main/resources/referral.jrxml @@ -446,157 +446,157 @@ $P!{whereclause}]]> - + - + - + - + - + - + - + - + - + - + - + - + - + - + - + - + - + - + - + - + - + - + - + - + - + - + diff --git a/services/report/3rdparty/jasper-cs-report/src/main/resources/tombstone_with_budget.jrxml b/services/report/3rdparty/jasper-cs-report/src/main/resources/tombstone_with_budget.jrxml index 7a1a8f535..509806719 100644 --- a/services/report/3rdparty/jasper-cs-report/src/main/resources/tombstone_with_budget.jrxml +++ b/services/report/3rdparty/jasper-cs-report/src/main/resources/tombstone_with_budget.jrxml @@ -306,91 +306,91 @@ $P!{whereclause}]]> - + - + - + - + - + - + - + - + - + - + - + - + - + - + - + diff --git a/services/report/3rdparty/jasper-cs-report/src/main/resources/tombstone_with_creator.jrxml b/services/report/3rdparty/jasper-cs-report/src/main/resources/tombstone_with_creator.jrxml index d1b580428..5a5c2cf98 100644 --- a/services/report/3rdparty/jasper-cs-report/src/main/resources/tombstone_with_creator.jrxml +++ b/services/report/3rdparty/jasper-cs-report/src/main/resources/tombstone_with_creator.jrxml @@ -271,85 +271,85 @@ $P!{whereclause}]]> - + - + - + - + - + - + - + - + - + - + - + - + - + - + -- 2.47.3