Skip to main content
ExLibris

Knowledge Assistant

BETA
 
  • Subscribe by RSS
  • Back
    Aleph

     

    Ex Libris Knowledge Center
    1. Search site
      Go back to previous article
      1. Sign in
        • Sign in
        • Forgot password
    1. Home
    2. Aleph
    3. Knowledge Articles
    4. SQL to retrieve hold requests for specific library (in Alma migration)

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

    1. Last updated
    2. Save as PDF
    3. Share
      1. Share
      2. Tweet
      3. Share
    1. Description
    2. Resolution

     

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

     

    Description

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

    Resolution

    > 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
    View article in the Exlibris Knowledge Center
    1. Back to top
      • SQL to locate patrons who lack barcodes
      • SQL to show out-of-sync Bib/ADM record keys
    • Was this article helpful?

    Recommended articles

    1. Article type
      Topic
      Language
      English
      Product
      Aleph
    2. Tags
      1. contype:kba
      2. Prod:Aleph
      3. SQL
      4. z37
    1. © Copyright 2025 Ex Libris Knowledge Center
    2. Powered by CXone Expert ®
    • Term of Use
    • Privacy Policy
    • Contact Us
    2025 Ex Libris. All rights reserved