[Koha-bugs] [Bug 33262] New: When an ordered record is deleted, we lose all information on what was ordered

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

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: koha-bugs at lists.koha-community.org
          Reporter: katrin.fischer at bsz-bw.de
        QA Contact: testopia at bugs.koha-community.org
                CC: clemens.tubach at kit.edu, michaela.sieber at kit.edu
            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.