Differences

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

--- evergreen-reports:sql:circulation:hold_reports [2011/03/08 22:05] – created bshum
+++ evergreen-reports:sql:circulation:hold_reports [2022/02/10 13:34] (current) – external edit 127.0.0.1
@@ Line 2: / Line 2: @@
 ===== Requests (Holds) Purchase Alert Report =====
-**Submission Notes:**
+**Submission Notes:** This report was submitted on 5/19/10 by Amy Terlaga of Bibliomation, Inc. It was originally created by Dan Scott of Laurentian University.
-This report was submitted on 5/19/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 show those titles with patron requests against them greater than a specific number.  Libraries can use this report to determine whether or not they should purchase another copy of the title(s) in question.  The number of requests is based on individual library and not across the entire library system.
 The report here is shown with number of requests greater than 5.  You can change the 5 to whatever value you desired
 **- HAVING count(all_holds.bib_id) > 5**
----------------------------
+<code sql>
  SELECT all_holds.bib_id, aou.name, rmsr.title, rmsr.author, count(all_holds.bib_id) AS count
@@ Line 36: / Line 38: @@
   ORDER BY aou.name, count(all_holds.bib_id) DESC;
------------------------------
+</code>
 Back to [[evergreen-reports:sql:circulation|Evergreen Circulation Reports]] page