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

    SQL to retrieve hold requests for specific library (in Alma migration)


    • Product: Aleph
    • Product Version: 20, 21, 22, 23
    • Relevant for Installation Type: Dedicated-Direct, Direct, Local, Total Care



    In migrating to Alma, we want to retrieve a list of hold requests for specific library/sublibrary.


    > s+ xxx50
    SQL> select z30_barcode, z37_id, z37_open_date, z37_request_date, z37_end_request_date from z30, z37 where z30_sub_library = 'XXXXX' and z37_status = 'S' and substr (z37_rec_key,1,15) = z30_rec_key;

    <Note:  the "z37_status = 'S'" limits the results to items which have been placed on the hold shelf.> 



    • Article last edited: 16-Aug-2016
    • Was this article helpful?