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.