[Koha-bugs] [Bug 36101] Deleting an item removes the itemnumber from old_reserves when it should not

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

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

--- Comment #9 from Lari Strand <lmstrand at gmail.com> ---
In our case, we need to find out the biblio details for the deleted item so we
can show these details for patrons in their lists of past loans/old issues.
Without the itemnumber in the old_issues table finding out what the patron has
previously loaned is impossible.

We are not using opac as a patron interface, we have our own implementation,
that uses this plugin to talk to the web interface:
https://github.com/KohaSuomi/koha-plugin-rest-di

If the biblio is also deleted, we can find the details from
deletedbiblio-table.

Maybe finding out biblio details based on the old_issues itemnumber might be
interesting for statistical/reporting purposes as well.

"Keeping an itemnumber in this table that does no longer exist is bad
practice."

We still have deleted-tables so I don't consider the data as non-existing.

If we touch these old_-tables like this and destroy this archived data that can
be linked still with deleted-tables, shouldn't we do the same to action_logs? I
consider action_logs as an "archive" table just like old_issues or old_reserves
(not sure if we do this already, though. Remove itemnumbers/biblionumbers from
action_logs that are linked to deleted items/biblios?).

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