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

    Custom Reports: Query for Bibliographic Records without MFHD

    Created By: Shelley Schultz
    Created on: 5/15/2019



    [This article was copied from the Voyager Wiki.]

    The [query below] will gather all bib records that do not have a MFHD attached.  I run this on a monthly basis.

    SELECT BIB_TEXT.BIB_ID, BIB_TEXT.TITLE, BIB_MASTER.SUPPRESS_IN_OPAC
    FROM (BIB_TEXT LEFT JOIN BIB_MFHD ON BIB_TEXT.BIB_ID = BIB_MFHD.BIB_ID) INNER JOIN BIB_MASTER ON BIB_TEXT.BIB_ID = BIB_MASTER.BIB_ID
    WHERE (((BIB_MFHD.MFHD_ID) Is Null))
    ORDER BY BIB_TEXT.TITLE;




    • Was this article helpful?
    //Feedback