[Koha-bugs] [Bug 21457] New: datelastseen and datelastborrowed out of sync
bugzilla-daemon at bugs.koha-community.org
bugzilla-daemon at bugs.koha-community.org
Mon Oct 1 09:57:07 CEST 2018
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=21457
Bug ID: 21457
Summary: datelastseen and datelastborrowed out of sync
Change sponsored?: ---
Product: Koha
Version: master
Hardware: All
OS: All
Status: NEW
Severity: normal
Priority: P5 - low
Component: Circulation
Assignee: koha-bugs at lists.koha-community.org
Reporter: magnus at libriotech.no
QA Contact: testopia at bugs.koha-community.org
CC: gmcharlt at gmail.com, kyle.m.hall at gmail.com
In the items table we have these two columns:
- datelastborrowed - the date the item was last checked out/issued
- datelastseen - the date the item was last see (usually the last time the
barcode was scanned or inventory was done)
Based on these descriptions you would expect that datelastseen was always the
same as or more recent than datelastborrowed, right? One of our customer
libraries just made me aware that this is not always the case.
This SQL finds the unexpected data:
SELECT COUNT(*) FROM items WHERE datelastborrowed > datelastseen;
Three of our sites have this unexpected data. They all use SIP2. But we also
have a couple sites that use SIP2 that do *not* have unexpected data, so that
might be a false lead.
Anyone else seen this?
--
You are receiving this mail because:
You are watching all bug changes.
You are the assignee for the bug.
More information about the Koha-bugs
mailing list