Differences

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

--- evergreen-reports:item_reports [2010/05/24 16:14] – terlaga
+++ evergreen-reports:item_reports [2011/03/08 21:59] (current) – removed bshum
@@ Line 1: / Line 1: @@
-====== ITEM REPORTS ======
-===== Item List Reports =====
-==== Sample Item Barcode from each Circulation Modifier ====
-**Submission Notes:**
-This report was submitted on 5/24/10 by Amy Terlaga of Bibliomation, Inc. It was created by Dan Scott of Laurentian University.
-**Version**:  Evergreen v.1.6.0.2
-**Data Sources Used**:
-**Running Tips/Guidelines**:  This report is perfect for consortium/library staff to assist in testing purposes.  It will provide a representative item barcode per circulation modifier in the Evergreen system so that circulation rules can be tested.
-You do not need to change anything in this report to run it.
---------------------------------------------------------------
-SELECT aou.shortname, ac.circ_modifier, MAX(ac.barcode)
-  FROM asset.copy ac
-    INNER JOIN actor.org_unit aou ON ac.circ_lib = aou.id
-  WHERE ac.deleted IS FALSE
-  GROUP BY aou.shortname, circ_modifier
-  ORDER BY aou.shortname, ac.circ_modifier ;
-===== Item Statistical Reports =====
-Back to [[evergreen-reports:sql_reports|Evergreen SQL Report Submissions]] main page