Bug 26622

Summary: Unique Constraint on Authorised Values conflicts with use of Report Subgroup category
Product: Koha Reporter: Joy Nelson <1joynelson>
Component: DatabaseAssignee: Bugs List <koha-bugs>
Status: NEW --- QA Contact: Testopia <testopia>
Severity: enhancement    
Priority: P5 - low CC: fridolin.somers
Version: Main   
Hardware: All   
OS: All   
See Also: https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=17809
Change sponsored?: --- Patch complexity: ---
Documentation contact: Documentation submission:
Text to go in the release notes:
Version(s) released in:

Description Joy Nelson 2020-10-06 16:27:10 UTC
Bug 22887 introduced a unique constraint on authorised values category/code.  However, this causes problems for the existing use of Report Subgroups.  There are many sites that use the same code in Report Subgroups that relate to different Report Groups (tied via reports_subgroup lib opac value).  

Example:
category, code, description, lib_opac
Report Group, TECH, technical services,
Report Group, CIRC, Circulation department,

Report Subgroup, RENEWALS, Renewal stats, TECH
Report Subgroup, RENEWALS, Renewal circ stats, CIRC

It is entirely possible to have two Report Subgroups with the same code that relate to different Report Groups as seen in the above example.

Report Group and Subgroup functionality needs to be removed from the authorised values module and a new module/database created for it.