[Koha-bugs] [Bug 35943] New: SQL reports groups/subgroups whose name contains regexp special characters break table filtering

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

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

            Bug ID: 35943
           Summary: SQL reports groups/subgroups whose name contains
                    regexp special characters break table filtering
 Change sponsored?: ---
           Product: Koha
           Version: master
          Hardware: All
                OS: All
            Status: ASSIGNED
          Severity: normal
          Priority: P5 - low
         Component: Reports
          Assignee: julian.maurice at biblibre.com
          Reporter: julian.maurice at biblibre.com
        QA Contact: testopia at bugs.koha-community.org

Groups and subgroups filtering uses regular expressions. The filter looks like
"^" + name + "$"
The problem is that the special characters in group/subgroup name are not
properly escaped, which means that if a name contains "+", "*", or any other
regexp special characters, filtering will probably fail.

Another (minor) problem is that we use the name to filter instead of the code.
So if we have two groups or two subgroups with the same name, it will show
reports from both groups/subgroups. There is no reason to have groups/subgroups
with the same name, but it is possible (whereas it's not possible to have
different groups/subgroups with the same code), so this should be fixed too.

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