[Koha-bugs] [Bug 26868] biblio and biblio_metadata tables timestamp do not update when moving an item

[bugzilla-daemon at bugs.koha-community.org]

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=26868

Mark Noble <mark at bywatersolutions.com> changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
                 CC|                            |mark at bywatersolutions.com

--- Comment #3 from Mark Noble <mark at bywatersolutions.com> ---
Aspen Discovery is using an ODBC connection to the database to determine what
records and items have changed by looking at the biblio timestamp,
biblio_metadata timestamp, items timestamp.  To determine which bibs and items
have been deleted it looks at deleteditems and deletedbiblio. 

When an item has been moved to another bib, we can detect that it is changed,
but we only know the new bib number, not the old bib number.  So there is not
an easy way to determine that the old bib record also needs to be updated to
not include the item.  

Because items are part of the bib record, we feel it is appropriate to update
the timestamp for the old bib record when the item is moved. If that turns out
to not be appropriate, we would suggest creating another timestamp for when
items within the biblio are created, or deleted so we can detect changes to the
contents of the record.

-- 
You are receiving this mail because:
You are the assignee for the bug.
You are watching all bug changes.