Getting email addresses for patrons with Aleph My eShelf records
- Product: Aleph
- Product Version: 20, 21, 22, 23
- Relevant for Installation Type: Dedicated-Direct, Direct, Local, Total Care
Description
How can we get the email address for each patron who has Aleph My eshelf (z129) record?
Resolution
The following SQL will do that:
> s+ xxx50
select substr(z304_rec_key,1,12), z304_email_address from z304 where substr(z304_rec_key,1,12) in (select substr (z129_rec_key,1,12) from z129);
Note: the z304 is in the xxx50 ADM library and the z129 is in the $usr_library. If these are different libraries at your site, the $usr_library will need to be specified in the SQL.
- Article last edited: 12-Mar-2017