From: Rogan Hamby <rhamby@esilibrary.com>
Date: Fri, 11 Oct 2019 19:14:18 +0000 (-0400)
Subject: adding blocks report with description from blocks table for horizon2 tag
X-Git-Url: http://git.equinoxoli.org/?p=migration-tools.git;a=commitdiff_plain;h=f454a378e032ddd7d145498e606095ec441a0e40

adding blocks report with description from blocks table for horizon2 tag
---

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>