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 Borrower Reports page