Differences

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

--- evergreen-reports:item_reports [2010/05/24 16:11] – 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 ====
-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