[Koha-bugs] [Bug 2846] New: Double quotes (") in SQL query prevents downloading of guided reports

[bugzilla-daemon at pippin.metavore.com]

http://bugs.koha.org/cgi-bin/bugzilla/show_bug.cgi?id=2846

           Summary: Double quotes (") in SQL query prevents downloading of
                    guided reports
           Product: Koha
           Version: rel_3_0
          Platform: All
        OS/Version: All
            Status: NEW
          Severity: normal
          Priority: P3
         Component: Reports
        AssignedTo: galen.charlton at liblime.com
        ReportedBy: beverly.church at liblime.com
         QAContact: koha-bugs at lists.koha.org


It is not possible to download a guided report if the SQL query used to create
the report contains double quotes (") around the search criteria.

For example if you use the following query containing search criteria between
double quotes you will get results:

select borrowers.categorycode, categories.description,
count(borrowers.borrowernumber) from borrowers left join categories on
(borrowers.categorycode=categories.categorycode) where dateenrolled between
"2008-10-01" and "2008-10-31" group by categorycode

However if you attempt to download the results, the error message "Can't use an
undefined value as an ARRAY reference ..." appears.




------- You are receiving this mail because: -------
You are the QA contact for the bug, or are watching the QA contact.