Check for LastCircTransactionDate and ItemStatusDate on lost items

Polaris
1

We’re seeing some issues with lost items that were migrated from Sierra libraries. There are other hiccups that can cause this to happen, but it appears the majority of ours were data migration-related. We’ve seen it with our two Sierra libraries that were migrated to Polaris, one in 2018, the other in 2024, so dropping this here in case it is helpful to others.

Basically, it appears items in the LOST status in Sierra don’t get migrated over with all their date fields properly filled out.

Specifically, we’d recommend everyone run the following Item Find Tool SQL:

SELECT [itemrecordid]
FROM   [Polaris].[Polaris].[circitemrecords]
WHERE  itemstatusid = 7
       AND ( lastcirctransactiondate IS NULL
              OR itemstatusdate IS NULL )
       AND recordstatusid = 1

If you get any results from that query, consider opening a support ticket to work on getting the records cleaned up.

Even for libraries that migrated years ago, you might find this query helpful because if you key off the lastcirctransactiondate to determine which records to delete from the system, these might have been missed over the years.

2

I get 3670 items :open_mouth:

3

You might want to check with support for help on cleaning up these records.

1 Like
4

I already have a ticket open regarding our migrated patrons with lost (billed) items. The lost items show on their accounts but there are no charges on their account tab so nothing stopping them from using their accounts. In Polaris when we bill the charge moves over to the account tab.