# Record set of items without barcodes

**URL:** https://forum.innovativeusers.org/t/record-set-of-items-without-barcodes/2602
**Category:** Polaris
**Created:** [August 28, 2025, 11:42pm UTC](https://forum.innovativeusers.org/t/record-set-of-items-without-barcodes/2602 "2025-08-28T23:42:00Z")
**Posts on this page:** 4
**Page:** 1

<div class="post-metadata">

### Author: ![Leenie](https://forum.innovativeusers.org/user_avatar/forum.innovativeusers.org/leenie/32/1193_2.png) [@Leenie](https://forum.innovativeusers.org/u/Leenie)
#### Post date: [August 28, 2025, 11:42pm UTC](https://forum.innovativeusers.org/t/record-set-of-items-without-barcodes/2602/1 "2025-08-28T23:42:00Z")

</div>

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.

---

<div class="post-metadata">

### Author: ![wesochuck](https://forum.innovativeusers.org/user_avatar/forum.innovativeusers.org/wesochuck/32/499_2.png) [@wesochuck](https://forum.innovativeusers.org/u/wesochuck)
#### Post date: [August 29, 2025, 12:23pm UTC](https://forum.innovativeusers.org/t/record-set-of-items-without-barcodes/2602/2 "2025-08-29T12:23:49Z")

</div>

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 |

```auto
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

```

---

<div class="post-metadata">

### Author: ![wesochuck](https://forum.innovativeusers.org/user_avatar/forum.innovativeusers.org/wesochuck/32/499_2.png) [@wesochuck](https://forum.innovativeusers.org/u/wesochuck)
#### Post date: [August 29, 2025, 12:48pm UTC](https://forum.innovativeusers.org/t/record-set-of-items-without-barcodes/2602/3 "2025-08-29T12:48:38Z")

</div>

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](https://documentation.iii.com/leap/7.8/Default.htm#LEAP1_0/Patrons/LeapAddRecstoExistingRecSetfromFT4100.htm).

---

<div class="post-metadata">

### Author: ![Leenie](https://forum.innovativeusers.org/user_avatar/forum.innovativeusers.org/leenie/32/1193_2.png) [@Leenie](https://forum.innovativeusers.org/u/Leenie)
#### Post date: [August 29, 2025, 1:14pm UTC](https://forum.innovativeusers.org/t/record-set-of-items-without-barcodes/2602/4 "2025-08-29T13:14:22Z")

</div>

Perfect. Exactly what I needed. Thanks.