[Koha-bugs] [Bug 2982] New: SQL for count or sum produces multiple blank output pages, odd screen display
bugzilla-daemon at pippin.metavore.com
bugzilla-daemon at pippin.metavore.com
Wed Feb 25 15:19:37 CET 2009
http://bugs.koha.org/cgi-bin/bugzilla/show_bug.cgi?id=2982
Summary: SQL for count or sum produces multiple blank output
pages, odd screen display
Product: Koha
Version: rel_3_0
Platform: PC
OS/Version: Linux - Debian
Status: NEW
Severity: normal
Priority: P3
Component: Reports
AssignedTo: galen.charlton at liblime.com
ReportedBy: jwagner at ptfs.com
QAContact: koha-bugs at lists.koha.org
When creating and running reports from SQL in the Guided Reports area, I'm
noticing some odd screen output. For example, if I use the SQL query
SELECT COUNT(*) as "New Patrons" FROM borrowers WHERE borrowers.dateenrolled >=
'2009-02-01' AND borrowers.dateenrolled <= '2009-02-28'
the screen output looks like this:
<< < 1 2 3 ... 7 > >>
New Patrons
138
Download the report: [pulldown for output option] = '2009-02-01' AND
borrowers.dateenrolled <= '2009-02-28'" /> [download button]
There are arrows and numbers for multiple pages, but the only page with output
is the first, which has the new patron count. In addition, part of my SQL
query is displaying on the bottom line, where the pulldown and button for
downloading report results are.
If I build the report from SQL and run without the "As New Patrons" qualifier:
SELECT COUNT(*) FROM borrowers WHERE borrowers.dateenrolled >= '2009-02-01' AND
borrowers.dateenrolled <= '2009-02-28'
<< < 1 2 3 ... 7 > >>
COUNT(*)
138
the annoying multiple blank pages still shows, but it's not reproducing part of
the SQL query on the download line.
I've seen similar results with any query that does a sum or count. I searched
the bugzilla site but didn't find anything that seemed relevant.
------- You are receiving this mail because: -------
You are the QA contact for the bug, or are watching the QA contact.
More information about the Koha-bugs
mailing list