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

    Can patron list report be used to send patron membership expiration notices?

    • Article Type: General
    • Product: Aleph
    • Product Version: 16.02

    Description:
    I need to generate patron membership expiration notices. I find that the p_cir_05 Patron List job does have the parameters I need to generate a report, but this report only has a list of patrons that match the search criteria. How do I take those parameters and generate a notice that gets emailed to each patron?

    Resolution:
    I don't believe this can be done with standard ALEPH reports.

    You could use the following SQL:

    SQL> select z303_name, z304_email_address, Z305_EXPIRY_DATE from z303, z304, z305 where z303_rec_key = substr (z304_rec_key,1,12) and z303_rec_key = substr (z305_rec_key,1,12);

    [You could select the Z304_ADDRESS_n fields instead of the email, if you want print letters.]

    This way you will not need to look up the patron in ALEPH. You can plug these values into an email template or a Word doc to generate the letter.

    Additional Information

    SQL, expiration


    • Article last edited: 10/8/2013