You are here

Shelf List for inventory

Submitted by formerly adam on November 5, 2014

Here is a basic shelf list report, sorted by call number, where the item status is 'available'

 

SELECT MFHD_MASTER.DISPLAY_CALL_NO, BIB_TEXT.TITLE, ITEM_BARCODE.ITEM_BARCODE, LOCATION_1.LOCATION_CODE AS [item perm loc], LOCATION_1.LOCATION_CODE AS [holding location], ITEM_BARCODE.BARCODE_STATUS, MFHD_ITEM.ITEM_ENUM, MFHD_ITEM.CHRON, MFHD_ITEM.Year
FROM (LOCATION AS LOCATION_1 INNER JOIN (BIB_TEXT INNER JOIN ((((((ITEM INNER JOIN ITEM_BARCODE ON ITEM.ITEM_ID = ITEM_BARCODE.ITEM_ID) INNER JOIN MFHD_ITEM ON ITEM.ITEM_ID = MFHD_ITEM.ITEM_ID) INNER JOIN MFHD_MASTER ON MFHD_ITEM.MFHD_ID = MFHD_MASTER.MFHD_ID) INNER JOIN BIB_MFHD ON MFHD_MASTER.MFHD_ID = BIB_MFHD.MFHD_ID) INNER JOIN BIB_MASTER ON BIB_MFHD.BIB_ID = BIB_MASTER.BIB_ID) INNER JOIN LOCATION ON MFHD_MASTER.LOCATION_ID = LOCATION.LOCATION_ID) ON BIB_TEXT.BIB_ID = BIB_MASTER.BIB_ID) ON LOCATION_1.LOCATION_ID = ITEM.PERM_LOCATION) INNER JOIN ITEM_STATUS ON ITEM.ITEM_ID = ITEM_STATUS.ITEM_ID
WHERE (((LOCATION_1.LOCATION_CODE) Like [location code] & "*") AND ((ITEM_STATUS.ITEM_STATUS)="1"))
ORDER BY MFHD_MASTER.NORMALIZED_CALL_NO;