Voyager to Alma Migration Query: Items with no active barcodes

When migrating from Voyager to Alma, it may be desirable to identify and review items with no active barcode. 

This query lists items that have no barcode at all or their barcodes are inactive.

Note that depending on local cataloging practices, it may be acceptable to have items without barcodes.

The following query and subquery, which can be run using Voyager's Prepackaged Access Reports, can be used to add active barcodes to item records that are missing them.

Subquery: Here is the subquery. It finds all the items with active barcodes. Save it under the name, “Items with No Active Barcode Subquery” but don’t run it.

SELECT ITEM_BARCODE.ITEM_ID
FROM ITEM_BARCODE
WHERE (((ITEM_BARCODE.BARCODE_STATUS)="1"));

Main query: Finds items that were not found by the subquery and looks up their permanent location and item type. Save it as “Items with No Active Barcode Main Query” and run it.

SELECT ITEM.ITEM_ID, LOCATION.LOCATION_CODE, ITEM_TYPE.ITEM_TYPE_CODE,
MFHD_MASTER.DISPLAY_CALL_NO, MFHD_ITEM.ITEM_ENUM, ITEM.COPY_NUMBER
FROM ((((ITEM LEFT JOIN [Items with No Active Barcode Subquery] ON
ITEM.ITEM_ID = [Items with No Active Barcode Subquery].ITEM_ID) 
INNER JOIN ITEM_TYPE ON ITEM.ITEM_TYPE_ID = ITEM_TYPE.ITEM_TYPE_ID) 
INNER JOIN LOCATION ON ITEM.PERM_LOCATION = LOCATION.LOCATION_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
WHERE ((([Items with No Active Barcode Subquery].ITEM_ID) Is Null))
ORDER BY LOCATION.LOCATION_CODE, MFHD_MASTER.DISPLAY_CALL_NO;

For other queries that may be useful, see my "Surviving Almanado: tips for a successful pre-implementation" presentation's Accompanying Materials.

Posted as is. If you need assistance in running custom SQL queries in Prepackaged Access Reports, consult the Voyager Customer Listserv.