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

    How to get a list of titles loaned by a patron in the past six months?

    1. Last updated
    2. Save as PDF
    • Article Type: General
    • Product: Aleph
    • Product Version: 16.02

    Description:
    How do you get the list of titles that a patron has loaned in the past six months?

    Resolution:
    SQL-ABC50> select Z13_TITLE, z35_event_date from ABC01.Z13, Z35, Z103 where Z13_REC_KEY = substr (Z103_REC_KEY_1,6,9) and substr (Z103_REC_KEY_1,1,5) = 'ABC01' and substr (Z103_REC_KEY,6,9) = substr (Z35_REC_KEY,1,9) and z35_event_type like '5%' and and z35_id = 'nnnn' and z35_event_date > '200601001';

    • Article last edited: 10/8/2013