Skip to main content
ExLibris

Knowledge Assistant

BETA
 
  • Subscribe by RSS
  • Back
    Voyager

     

    Ex Libris Knowledge Center
    1. Search site
      Go back to previous article
      1. Sign in
        • Sign in
        • Forgot password
    1. Home
    2. Voyager
    3. Community Knowledge
    4. Custom Reports: Query of Holds on Items That are Currently Available

    Custom Reports: Query of Holds on Items That are Currently Available

    1. Last updated
    2. Save as PDF
    3. Share
      1. Share
      2. Tweet
      3. Share
    No headers
    Created By: Shelley Schultz
    Created on: 5/15/2019



    [This article was copied from the Voyager Wiki.]

    This query reports back on items that have holds on them regardless if they were requested by staff or student.  It shows all items that have holds that are currently on the shelves.  It also includes the expiration date of the hold request, patron name.

    SELECT PATRON.LAST_NAME, PATRON.FIRST_NAME, BIB_TEXT.TITLE, ITEM_BARCODE.ITEM_BARCODE, MFHD_MASTER.NORMALIZED_CALL_NO, HOLD_RECALL.EXPIRE_DATE
    FROM ((MFHD_MASTER INNER JOIN ((((PATRON INNER JOIN HOLD_RECALL ON PATRON.PATRON_ID = HOLD_RECALL.PATRON_ID) INNER JOIN HOLD_RECALL_ITEMS ON HOLD_RECALL.HOLD_RECALL_ID = HOLD_RECALL_ITEMS.HOLD_RECALL_ID) INNER JOIN BIB_TEXT ON HOLD_RECALL.BIB_ID = BIB_TEXT.BIB_ID) INNER JOIN BIB_MFHD ON BIB_TEXT.BIB_ID = BIB_MFHD.BIB_ID) ON MFHD_MASTER.MFHD_ID = BIB_MFHD.MFHD_ID) INNER JOIN ITEM ON HOLD_RECALL_ITEMS.ITEM_ID = ITEM.ITEM_ID) INNER JOIN ITEM_BARCODE ON ITEM.ITEM_ID = ITEM_BARCODE.ITEM_ID
    GROUP BY PATRON.LAST_NAME, PATRON.FIRST_NAME, BIB_TEXT.TITLE, ITEM_BARCODE.ITEM_BARCODE, MFHD_MASTER.NORMALIZED_CALL_NO, PATRON.RECALLS_PLACED, PATRON.HOLDS_PLACED, HOLD_RECALL.EXPIRE_DATE
    HAVING (((PATRON.RECALLS_PLACED)<"1") AND ((PATRON.HOLDS_PLACED)<"1"))
    ORDER BY PATRON.LAST_NAME, PATRON.FIRST_NAME;




    Report
    View article in the Exlibris Knowledge Center
    1. Back to top
      • Custom Reports: Query of Bibs Suppressed in OPAC within Specific Date Range
      • Custom Reports: Query of MFHD Records Suppressed in OPAC within Specific Date Range
    • Was this article helpful?

    Recommended articles

    1. Article type
      Topic
      Community Content Type
      How To
      Language
      English
      Product
      Voyager
    2. Tags
      This page has no tags.
    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