On Sat, May 19, 2018 at 6:20 PM, Katrin Fischer <katrin.fischer.83@web.de> wrote:
Hi Manos,
it's an item field, so it's added for every item in 952/955.
As the complete items information is added on time of indexing, I think what Barton suggests is already the case?
That's my understanding. For background: Data in the biblio and/or biblioitems table is copied to biblio_metadata.metadata (this was once biblioitems.marcxml). Item data is *not* stored in the metadata field -- each item is appended to the marcxml record at the time of indexing. This includes items.onloan, and this is how the 'available' status is displayed item by item in the list view of the opac and staff catalog search. This works well most of the time -- but not all... my contention is that removing items.onloan, and reading from issues.date_due instead gives a single point of truth for the on-loan status of an item. Try running this as a report to see if any of your items are affected: select count(*) from issues inner join items using (itemnumber) where date(issues.date_due) != items.onloan