From f454a378e032ddd7d145498e606095ec441a0e40 Mon Sep 17 00:00:00 2001
From: Rogan Hamby <rhamby@esilibrary.com>
Date: Fri, 11 Oct 2019 15:14:18 -0400
Subject: [PATCH] adding blocks report with description from blocks table for horizon2 tag

---
 mig-xml/mapping_reports.xml |   11 ++++++++++-
 1 files changed, 10 insertions(+), 1 deletions(-)

diff --git a/mig-xml/mapping_reports.xml b/mig-xml/mapping_reports.xml
index 4c3362a..55c12be 100644
--- a/mig-xml/mapping_reports.xml
+++ b/mig-xml/mapping_reports.xml
@@ -513,7 +513,16 @@
         <heading>Count of Migratable Passwords / PINs</heading>
         <query>SELECT COUNT(pin) FROM borrower_csv_clean WHERE LENGTH(pin) > 1;</query>
     </report>
-    
+   
+    <report>
+        <name>hz_blocks</name>
+        <report_title>Borrower Blocks</report_title>
+        <tag>horizon2</tag>
+        <iteration>0</iteration>
+        <heading>Count of Entries.Block Description</heading>
+        <query>SELECT COUNT(*), b.descr FROM burb_csv_clean a JOIN block_csv_clean b ON a.block = b.block GROUP BY 2;</query>
+    </report>
+ 
     <report>
         <name>hz_borrowernotesample</name>
         <report_title>Borrower Note Field Samples</report_title>
-- 
1.7.2.5