[Koha-bugs] [Bug 31568] New: Renaming/removing an authorised value does not cascade to linked tables

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

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

            Bug ID: 31568
           Summary: Renaming/removing an authorised value does not cascade
                    to linked tables
 Change sponsored?: ---
           Product: Koha
           Version: master
          Hardware: All
                OS: All
            Status: NEW
          Severity: enhancement
          Priority: P5 - low
         Component: System Administration
          Assignee: koha-bugs at lists.koha-community.org
          Reporter: m.de.rooy at rijksmuseum.nl
        QA Contact: testopia at bugs.koha-community.org
                CC: gmcharlt at gmail.com

We could give lots of examples here.
E.g. location is controlled by category LOC having a value like CHILD. If you
rename it to CHILDREN, your items still contain the old value.

This cannot be solved with a FK since an authorised value may be in use under
several AV categories.

Maybe there are cases where you do not want to have an AV immediately cascade
the change in a linked table?

Also note that we have a maintenance script looking for these inconsistencies
(bug 21466), but if we could reduce the volume here, I wouldnt mind.

How should we best address this need?

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