How to find what items particular barcodes have been associated with

Description

We have a list of barcodes that do not match the barcodes currently in the items. We have noted that these barcode numbers appear in the item history. Is there a way that we can run this list of barcodes (about 350 of them) against the item history? We would like to then generate a list of ADM numbers that they were previously attached to

Resolution

A z30h-barcode-adm script was created with this logic:

  spool barcode-adm-31407004147484 
  select unique z30h_barcode, substr (z30h_rec_key,1,15) from z30h where z30h_barcode = '31407004147484'; 

To find (via the z30h) what items a particular barcode has been associated with, you would change the barcode in both the spool and select lines from 31407004147484 to one of the barcodes you want to search and then submit the script like this: 

> s+ xxx50 
xxx50@ALEPH22> @z30h-barcode-adm 

The name of the output file will be barcode-adm-nnnnnnnnnnnnnn.lst where "nnnnnnnnnnnnnn" is the barcode number. 
 

• Article last edited: 1-Sep-2017