X-Git-Url: http://git.equinoxoli.org/?p=migration-tools.git;a=blobdiff_plain;f=mig-xml%2Fevergreen_staged_report.xml;fp=mig-xml%2Fevergreen_staged_report.xml;h=050df4ae01d0ac0f7b420767162c327347e255fe;hp=02226045ea22ed0d428150aaf37cdc788f0a8bca;hb=a5abafcce41e551379c27490029c70ea21232b1c;hpb=0c610fb7e604ad90a3edcb40176b2f8d23bf0f8c

diff --git a/mig-xml/evergreen_staged_report.xml b/mig-xml/evergreen_staged_report.xml
index 0222604..050df4a 100644
--- a/mig-xml/evergreen_staged_report.xml
+++ b/mig-xml/evergreen_staged_report.xml
@@ -44,6 +44,26 @@
     </report>
 -->
 
+<!-- adding sample pie chart report
+    <report>
+        <name>current_holds_by_state</name>
+        <tag>holds</tag>
+        <iteration>0</iteration>
+        <display>pie_chart</display>
+        <report_title>Holds by Current State (7 days)</report_title>
+        <heading>Captured.Fulfilled.Canceled.Targeted.Waiting</heading>
+        <chart_labels>Hold Type.Count</chart_labels>
+        <query> SELECT
+            (SELECT COUNT(*) FROM action.hold_request WHERE fulfillment_time IS NULL AND capture_time > NOW() - '7 days'::INTERVAL AND cancel_time IS NULL),
+            (SELECT COUNT(*) FROM action.hold_request WHERE fulfillment_time > NOW() - '7 days'::INTERVAL AND capture_time IS NOT NULL AND cancel_time IS NULL),
+            (SELECT COUNT(*) FROM action.hold_request WHERE fulfillment_time IS NULL AND cancel_time > NOW() - '7 days'::INTERVAL),
+            (SELECT COUNT(*) FROM action.hold_request WHERE fulfillment_time IS NULL AND capture_time IS NULL AND cancel_time IS NULL AND current_copy IS NOT NULL),
+            (SELECT COUNT(*) FROM action.hold_request WHERE fulfillment_time IS NULL AND capture_time IS NULL AND cancel_time IS NULL AND current_copy IS NULL)
+        </query>
+    </report>
+
+-->
+
     <!-- CIRC REPORTS -->
     <report>
         <name>circ_count</name>