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

[This article was copied from the Voyager Wiki.]

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

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