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