Record set of items without barcodes

Polaris
1

I’m sure there is a simple way to do this but I sure can’t figure it out tonight. How do I get a record set of items without barcodes? I can see the report of them in SSRS and I can export to various formats, but I can’t seem to figure out how to get them into a record set.

Thanks in advance.

2

I think you’d have to use a SQL find tool search for this.

Here is what we use that looks for null or empty barcodes. It excludes items attached to serials holdings records, ebooks (if you’re using the ebook integration), deleted item records (if you keep them rather than deleting them) and records in these item statuses:

ItemStatusID Description
7 Lost
10 Missing
11 Withdrawn
13 On-Order
15 In Processing
16 Unavailable 
select cir.ItemRecordID 
from polaris.polaris.CircItemRecords cir 
left join Polaris.Polaris.MfhdIssues i
	on i.BibliographicRecordID = cir.AssociatedBibRecordID
where (cir.Barcode is null or cir.barcode = '')
	and cir.ItemStatusID not in (7,10,11,13,15,16) 
	and i.IssueID is null
	and cir.ElectronicItem = 0
    and cir.RecordstatusID != 4
3

I realize I didn’t address the record set part. In case you didn’t know, you can send the results from any type of search to a record set using these steps.

4

Perfect. Exactly what I needed. Thanks.