Skip to main content
ExLibris
  • Subscribe by RSS
  • Ex Libris Knowledge Center

    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;




    • Was this article helpful?