From: Rogan Hamby <rhamby@equinoxinitiative.org>
Date: Fri, 24 Jan 2020 16:13:29 +0000 (-0500)
Subject: adding billing report for horizon from database extracts
X-Git-Url: http://git.equinoxoli.org/?p=migration-tools.git;a=commitdiff_plain;h=f660d091784fdd0567b1d16698e3dc3fc78f2ae0

adding billing report for horizon from database extracts
---

diff --git a/mig-xml/mapping_reports.xml b/mig-xml/mapping_reports.xml
index 47f07e6..53665d5 100644
--- a/mig-xml/mapping_reports.xml
+++ b/mig-xml/mapping_reports.xml
@@ -706,6 +706,15 @@
         <query>SELECT cki_notes FROM item_csv_clean WHERE LENGTH(cki_notes) > 1 LIMIT 20;</query>
     </report>
 
+    <report>
+        <name>hz_burbbills</name>
+        <report_title>Count of Bills by Type</report_title>
+        <tag>horizon2</tag>
+        <iteration>0</iteration>
+        <heading>Count.Bill Type</heading>
+        <query>SELECT COUNT(*), block FROM burb_csv_clean WHERE amount::INTEGER > 0 GROUP BY 2;</query>
+    </report>
+
 <!-- resource mate -->
 
     <report>