Differences

This shows you the differences between two versions of the page.

--- evergreen-reports:sql:circulation:daily_circ_stat_reports [2011/03/08 22:06] – created bshum
+++ evergreen-reports:sql:circulation:daily_circ_stat_reports [2022/02/10 13:34] (current) – external edit 127.0.0.1
@@ Line 6: / Line 6: @@
 This report was submitted on 5/14/10 by Amy Terlaga of Bibliomation, Inc.
 It was originally created by Dan Scott of Laurentian University.
 **Version**:  Evergreen v.1.6.0.2
 **Data Sources Used**:
 **Running Tips/Guidelines**:  This report is designed to be run the day AFTER the day you are interested in
 getting daily circulation totals.  If you would like it to reflect today's activity, remove **- '1 day'::interval**
 If you would like it to reflect activity from two days ago, change the **1** to a **2** (and so on).
 Where you see ORG, replace with your org unit's short name.
----------------------------
+<code sql>
 SELECT copy_location.name, count(circulation.id) AS count
@@ Line 29: / Line 33: @@
   WHERE org_unit.shortname = 'ORG'::text AND date_trunc('DAY'::text, circulation.create_time) = date_trunc('DAY'::text, now() - '1 day'::interval)
   ORDER BY 1;
----------------------------------
+</code>
 Back to [[evergreen-reports:sql:circulation|Evergreen Circulation Reports]] page