https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=33262
Bug ID: 33262
Summary: When an ordered record is deleted, we lose all
information on what was ordered
Change sponsored?: ---
Product: Koha
Version: master
Hardware: All
OS: All
Status: NEW
Severity: blocker
Priority: P5 - low
Component: Acquisitions
Assignee: [email protected]
Reporter: [email protected]
QA Contact: [email protected]
CC: [email protected], [email protected]
Blocks: 10758
I am moving this out from bug 10758 that was filed for the display issue. But
that is actually only the symptom, while we are actually facing a data loss
issue.
Libraries need to be able to account for the money they spent even after the
items and records have been removed from their collection.
At the moment we lose the connection between order and bibliographic record
when the record is deleted:
--
-- Table structure for table `aqorders`
--
DROP TABLE IF EXISTS `aqorders`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `aqorders` (
`ordernumber` int(11) NOT NULL AUTO_INCREMENT COMMENT 'primary key and unique
identifier assigned by Koha to each line',
`biblionumber` int(11) DEFAULT NULL COMMENT 'links the order to the biblio
being ordered (biblio.biblionumber)',
[...]
CONSTRAINT `aqorders_ibfk_2` FOREIGN KEY (`biblionumber`) REFERENCES `biblio`
(`biblionumber`) ON DELETE SET NULL ON UPDATE CASCADE,
We do have the information about the deleted record and the items, but we need
to preserve the link between order and deleted record in some way.
Referenced Bugs:
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=10758
[Bug 10758] Show bibliographic information of deleted records in acquisitions
--
You are receiving this mail because:
You are watching all bug changes.
You are the assignee for the bug.
_______________________________________________
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/
