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

    Creating SQL equivalent of p_cir_11

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

    Description:
    We want to create a custom service that is close to cir-11 but makes it better! Where is the sql or info we need to see the "guts" of cir-11 - we found in alephe/proc the following files: p_cir_11 and p_cir_11_param_names and those don't seem to tell me how this service runs (pehaps the sql behind it) - where can I find that info out - which directories?

    Resolution:
    Though some jobs invoke SQL scripts, p_cir_11 is not one of them.

    To do an SQL report of "Outstanding Hold Requests", the main thing would be to look for Z37's which do *not* have a z37_status of "S". ("S" indicates that the item has been placed on the Hold shelf and is waiting for the patron to pick it up.)

    If you want to limit it to Available items, at a minimum, you would need to do:

    SQL> select substr(z37_rec_key,1,15) from z37 minus select z36_rec_key from z36;


    • Article last edited: 10/8/2013