Bug 14986

Summary: Report Group and Subgroup Duplications
Product: Koha Reporter: Joy Nelson <1joynelson>
Component: ReportsAssignee: Galen Charlton <gmcharlt>
Status: CLOSED WONTFIX QA Contact: Testopia <testopia>
Severity: normal    
Priority: P5 - low CC: jbalway
Version: Main   
Hardware: All   
OS: All   
GIT URL: Initiative type: ---
Sponsorship status: --- Comma delimited list of Sponsors:
Crowdfunding goal: 0 Patch complexity: ---
Documentation contact: Documentation submission:
Text to go in the release notes:
Version(s) released in:
Circulation function:
Attachments: duplicated report

Description Joy Nelson 2015-10-08 22:39:02 UTC
Created attachment 43287 [details]
duplicated report

The ability to create Report Groups and Report Subgroups on reports without a check of the authorised_value table causes a large list of authorised values.  This large list of authorised values is not only difficult to administer within the authorised_value area of Koha, but it also defeats the purpose of an authorised_values list.

Users are able to enter duplicated Groups and Subgroups in reports.  Duplicated Groups do not appear as separate groups in the tabs, nor do the duplicates appear in the dropdown list for Groups.  Duplicated Subgroups (and perhaps Groups) also cause 1 report to appear multiple times in the listing of Reports.  (attached image) But the duplicated authorised_value does not appear in the Subgroup list to select.

If free text is allowed, before adding to the authorised_value table, the system needs to first verify if the Group or Subgroup already exists and if so, notify the user that a group or subgroup already exists. 

Further storing the "report group" in the authorised_value table lib_opac field makes no sense and is not intuitive to the user if they are to create Subgroups in the Authorised Value module.
Comment 1 Joseph Alway 2017-06-22 16:58:20 UTC
I ran into this and removed my duplicate tab after about 30 minutes of looking at the code and browsing the Administration features.
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=18840