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

    Voyager to Alma Migration Query: MFHD Records that are Suppressed but which have Items Attached

    Created By: Laura Guy (contact)
    Created on: 9/14/2020



    When you migrate from Voyager to Alma, you may want to review MFHD records that are suppressed, but which have items attached.  You may want to evaluate whether or not the suppress condition is correct.

    This query, which can be run via Voyager Prepackaged Access Reports, will identify MFHD records that are suppressed, and which have items attached. Note that because this query's output includes Item Status information, some item records will be included multiple times (once for each Item Status).

    ​SELECT DISTINCT MFHD_MASTER.MFHD_ID, MFHD_ITEM.ITEM_ID,
    ITEM_STATUS_TYPE.ITEM_STATUS_DESC, ITEM.CREATE_DATE,
    LOCATION.LOCATION_NAME,
    utf8to16([mfhd_master].[DISPLAY_CALL_NO]) AS Display_Call_No,
    MFHD_ITEM.ITEM_ENUM,
    MFHD_ITEM.CHRON, ITEM.COPY_NUMBER,
    ITEM_BARCODE.ITEM_BARCODE
    FROM ITEM_STATUS_TYPE INNER JOIN (((((MFHD_MASTER
    INNER JOIN MFHD_ITEM ON MFHD_MASTER.MFHD_ID = MFHD_ITEM.MFHD_ID)
    INNER JOIN LOCATION ON MFHD_MASTER.LOCATION_ID = LOCATION.LOCATION_ID)
    INNER JOIN ITEM ON MFHD_ITEM.ITEM_ID = ITEM.ITEM_ID)
    INNER JOIN ITEM_STATUS ON ITEM.ITEM_ID = ITEM_STATUS.ITEM_ID)
    LEFT JOIN ITEM_BARCODE ON ITEM.ITEM_ID = ITEM_BARCODE.ITEM_ID)
    ON ITEM_STATUS_TYPE.ITEM_STATUS_TYPE = ITEM_STATUS.ITEM_STATUS
    WHERE ((MFHD_MASTER.SUPPRESS_IN_OPAC)="Y")
    ORDER BY ITEM_STATUS_TYPE.ITEM_STATUS_DESC;

    For other queries that may be useful, see my "Surviving Almanado: tips for a successful pre-implementation" presentation's Accompanying Materials.
     
    If you need assistance in running custom SQL queries in Prepackaged Access Reports, consult the Voyager Customer Listserv.