Custom Reports: Query for Inactive Barcodes
Created By: Shelley Schultz
Created on: 5/15/2019
[This article was copied from the Voyager Wiki.]
The [query below] is the SQL to find all barcodes with a barcode status of "inactive".
SELECT ITEM_BARCODE.ITEM_BARCODE, ITEM_BARCODE.BARCODE_STATUS
FROM ITEM_BARCODE
WHERE (((ITEM_BARCODE.BARCODE_STATUS)>"1"))
ORDER BY ITEM_BARCODE.ITEM_BARCODE;