[Koha-bugs] [Bug 20271] Merge deleted biblio, biblioitems, biblio_metadata, and items tables

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

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

Nick Clemens <nick at bywatersolutions.com> changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
             Status|Signed Off                  |Failed QA

--- Comment #261 from Nick Clemens <nick at bywatersolutions.com> ---
Maybe it is too late to ask this question: Rather than joining items and
deleteditems, can we join them into a new table and provide views for both of
the old tables? This would prevent breaking reports across the board.

biblio, deletedbiblios => biblios?
items,deleteditems => all_items?

This is going to be a big problem for existing users, it is going to be many
reports, and it is going to cause disruption. Havign views that keep the
reports working would be a huge boon.

Otherwise:

I mostly tested functionality in this pass rather than reading the code, there
are some areas that need attention.

Acquisitions - Can delete ordered items and recieve them

Can edit deleted items by forcing URL in additem.pl

Can add to list using deleted barcodes

Can add deleted items to label batches and rotating collections

Batch record modification: Can load deleted records - then modification fails

Can attach images to deleted records

Canned reports - I don't think these were checked:
grep items /kohadevbox/koha/reports/* -c
grep is_current /kohadevbox/koha/reports/* -c

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