https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=42842
Bug ID: 42842
Summary: Remove materialized patron data from tmp_holdsqueue
Initiative type: ---
Sponsorship ---
status:
Product: Koha
Version: Main
Hardware: All
OS: All
Status: NEW
Severity: normal
Priority: P5 - low
Component: Architecture, internals, and plumbing
Assignee: [email protected]
Reporter: [email protected]
QA Contact: [email protected]
Depends on: 42503
Target Milestone: ---
Since bug 42503 converted the holds queue page to be API-driven, the
materialized patron fields in tmp_holdsqueue (surname, firstname, phone,
cardnumber) are no longer used. The page now embeds patron data via the
borrowernumber FK through the REST API.
These columns should be removed because:
1. They are dead code รข nothing reads them after bug 42503
2. They leave patron PII (name, phone, card number) in an unaudited table that
is not subject to patron data cleanup/anonymization routines
3. Privacy concern: tmp_holdsqueue is rebuilt periodically but retains patron
information between rebuilds, and this data is not covered by GDPR/privacy
cleanup tools
The fix should:
- Remove surname, firstname, phone, cardnumber columns from tmp_holdsqueue
- Stop populating them in C4::HoldsQueue::CreatePicklistFromItemMap
- Update Koha::Schema::Result::TmpHoldsqueue
- Remove the undef mappings in Koha::Hold::HoldsQueueItem::to_api_mapping
Referenced Bugs:
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=42503
[Bug 42503] Render the holds queue using the REST API
--
You are receiving this mail because:
You are the assignee for the bug.
You are watching all bug changes.
_______________________________________________
Koha-bugs mailing list
[email protected]
https://lists.koha-community.org/cgi-bin/mailman/listinfo/koha-bugs
website : http://www.koha-community.org/
git : http://git.koha-community.org/
bugs : http://bugs.koha-community.org/
