Skip to main content
  • Subscribe by RSS
  • Ex Libris Knowledge Center

    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



    How can we get the email address for each patron who has Aleph My eshelf (z129) record?


    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