[Koha-bugs] [Bug 3315] New: Aggregate SQL clauses break pagination in guided reports

bugzilla-daemon at liblime.com bugzilla-daemon at liblime.com
Mon Jun 8 23:46:13 CEST 2009


http://bugs.koha.org/cgi-bin/bugzilla3/show_bug.cgi?id=3315

           Summary: Aggregate SQL clauses break pagination in guided reports
           Product: Koha
           Version: HEAD
          Platform: PC
        OS/Version: All
            Status: NEW
          Severity: normal
          Priority: P5
         Component: Reports
        AssignedTo: galen.charlton at liblime.com
        ReportedBy: rch at liblime.com
   Estimated Hours: 0.0
 Change sponsored?: ---


guided reports tries to do a count(*) on sql results to determine if it needs
to paginate the output for the screen.
If the saved query includes an aggregate clause, most notably GROUP BY, it
counts incorrectly.

See Garry Collum's comment on bug 2982 .

I suggest a short term fix would be to test for aggregate clause in the sql,
and if there is one, report to the template that we don't know how many results
there are, so only show the first page.
Force the user to download the csv if they want the complete results set until
a more robust solution is found.


-- 
Configure bugmail: http://bugs.koha.org/cgi-bin/bugzilla3/userprefs.cgi?tab=email
------- You are receiving this mail because: -------
You are watching all bug changes.



More information about the Koha-bugs mailing list