Custom Reports: Query of MFHD Records Suppressed in OPAC within Specific Date Range

[This article was copied from the Voyager Wiki.]

This query will give you a listing of all MFHD records that are suppressed in your database. The output includes: MFHD#  Suppressed=Y Normalized Call #  Title Location Name  Location_Name  Item_Status  Item_Status_Date   We are a Dewey library so if you are LC you will need to do some editing.  This query does request that the user input a date range.

SELECT MFHD_MASTER.MFHD_ID, MFHD_MASTER.SUPPRESS_IN_OPAC, MFHD_MASTER.NORMALIZED_CALL_NO, LOCATION.LOCATION_NAME, BIB_TEXT.TITLE_BRIEF, ITEM_STATUS.ITEM_STATUS, ITEM_STATUS.ITEM_STATUS_DATE
FROM (((MFHD_MASTER INNER JOIN LOCATION ON MFHD_MASTER.LOCATION_ID = LOCATION.LOCATION_ID) INNER JOIN (BIB_TEXT INNER JOIN BIB_MFHD ON BIB_TEXT.BIB_ID = BIB_MFHD.BIB_ID) ON MFHD_MASTER.MFHD_ID = BIB_MFHD.MFHD_ID) INNER JOIN MFHD_ITEM ON MFHD_MASTER.MFHD_ID = MFHD_ITEM.MFHD_ID) INNER JOIN ITEM_STATUS ON MFHD_ITEM.ITEM_ID = ITEM_STATUS.ITEM_ID
WHERE (((MFHD_MASTER.SUPPRESS_IN_OPAC)="Y") AND ((ITEM_STATUS.ITEM_STATUS_DATE) Between [start date] And [end date]))
ORDER BY LOCATION.LOCATION_NAME;