Differences

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

--- evergreen-reports:borrower_list_reports [2010/05/20 10:54] – terlaga
+++ evergreen-reports:borrower_list_reports [2011/03/08 22:10] (current) – removed bshum
@@ Line 1: / Line 1: @@
-====== Borrower List Reports ======
-===== Borrowers with Email Addresses by Home Library =====
-**Submission Notes:**
-This report was created and submitted on 5/20/10 by Amy Terlaga of Bibliomation, Inc. (with assistance from Benjamin Shum)
-**Version**:  Evergreen v.1.6.0.2
-**Data Sources Used**:
-**Running Tips/Guidelines**:  This report is designed to those patrons from a specific library with email addresses in their patron record.
-To run this report, change the **'ORG'** to the shortname of the home library in question.
-----------------------
-SELECT actor.card.barcode, actor.usr.first_given_name, actor.usr.family_name, actor.usr.email, actor.org_unit.name
-  FROM actor.usr, actor.org_unit, actor.card
-  WHERE actor.usr.home_ou = actor.org_unit.id
-  AND actor.card.id = actor.usr.card
-  AND actor.org_unit.shortname = **'ORG'**
-  AND ((actor.usr.email != '')
-  AND (actor.usr.email IS NOT NULL))
-ORDER BY family_name;
-------------------------
-Back to [[evergreen-reports:borrower_reports|Borrower Reports]] page