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. New books which have more than 3 hold requests

    New books which have more than 3 hold requests

    1. Last updated
    2. Save as PDF
    3. Share
      1. Share
      2. Tweet
      3. Share
    No headers
    • Article Type: General
    • Product: Aleph
    • Product Version: 16.02

    Description:
    We need to generate a report for some new books which have more than 3 requests in past few months.

    Is the historic data of Hold requests stored in any table?

    Resolution:
    The hold request history can be found in both the z35 and z37h tables. The problem with the z37h is that it is written only after the hold has been filled or deleted, so the z35 is better for this purpose.

    You can do the following:

    select z35_rec_key from z35, z30 where z35_event_type like '7%' and z35_rec_key = substr (z30_rec_key,1,9) and z30_open_date > '20061001' group by z35_rec_key having count (*) > 3;



    [Jerry Specht]
    [1/16/2007 1:32:21 AM Jerry Specht]


    • Article last edited: 10/8/2013
    View article in the Exlibris Knowledge Center
    1. Back to top
      • New bib records not being Word-indexed
      • New borrower and renewals
    • Was this article helpful?

    Recommended articles

    1. Article type
      Topic
      Language
      English
      Product
      Aleph
    2. Tags
      1. 16.02
      2. contype:kba
      3. Prod:Aleph
      4. Type:General
    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