Differences

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

--- evergreen-reports:sql:circulation:ill_stat_reports [2011/03/08 22:07] – created bshum
+++ evergreen-reports:sql:circulation:ill_stat_reports [2022/02/10 13:34] (current) – external edit 127.0.0.1
@@ Line 9: / Line 9: @@
 **Version**:  Evergreen v.1.6.0.2
 **Data Sources Used**:
 **Running Tips/Guidelines**:  This report will give you a monthly count of those items coming from other libraries that circulate at your library.  The breakdown is by shelving location.  You can run this report at any time during the month following the month for which you would like statistics.
 You will need to change **ORG** in both parts of the query to the shortname of the organizational unit in question.
---------------------------------------------------------------
+<code sql>
 SELECT aou.name AS "Circulating Library", aou2.name AS "Owning Library", acl.name AS "Shelving Location", COUNT(acirc.id) AS "COUNT"
@@ Line 40: / Line 43: @@
 ORDER BY 1, 2, 3;
+</code>
------------------------------
 Back to [[evergreen-reports:sql:circulation|Evergreen Circulation Reports]] page