Duplicate entries

Polaris
1

Hi all. In Sierra, Headings Reports I used to run a search for “Duplicate Entries”. I’m not sure what all it was searching but I’d get a list of duplicate patron and item barcodes and bibs that had the same 001 tag (I believe). What the best way to find these in Polaris? Thanks.

2

Hello Colleen,

Duplicate patron barcodes:

select barcode from circitemrecords with (nolock)
where recordstatusid=1
group by barcode
having count(*)>1

Duplicate item barcodes is the same but the table is ‘circitemrecords’ instead of patrons. I got more results when I stopped excluding deleted items, but IDK how much you care about those cases.

The 001 field is just the control number for the bib record so I don’t believe Polaris will let there be duplicates.

3

Hi @ebrondermajor . Thanks for this. Is “circitemrecords” the table for items? What is the table for patron barcodes? Sorry if I’m misreading. Thanks.

4

Oh yeah, my bad lol, used the wrong table. It should be like this:

Patrons:

select barcode from patrons with (nolock)
where recordstatusid=1
group by barcode
having count(*)>1

Items:

select barcode from circitemrecords with (nolock)
where recordstatusid=1
group by barcode
having count(*)>1
5

Thanks, Eleanor. That did find me some duplicates.