[Bug 3419] New: Downloaded saved reports do not contain all records
http://bugs.koha.org/cgi-bin/bugzilla3/show_bug.cgi?id=3419 Summary: Downloaded saved reports do not contain all records Product: Koha Version: rel_3_0 Platform: All OS/Version: All Status: NEW Severity: normal Priority: P5 Component: Reports AssignedTo: galen.charlton@liblime.com ReportedBy: beverly.church@liblime.com Estimated Hours: 0.0 Change sponsored?: --- If you run the following query as a saved report and download the results, the file does not contain all the records which you viewed in Koha: SELECT borrowers.surname, borrowers.firstname, borrowers.address, borrowers.city, borrowers.zipcode FROM borrowers ORDER BY borrowers.surname asc In Koha you can see all patrons from A to Z. The downloaded file only contains patron records up to the letter D. The database has 71,755 patron records. -- 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.
http://bugs.koha.org/cgi-bin/bugzilla3/show_bug.cgi?id=3419 Beverly Church <beverly.church@liblime.com> changed: What |Removed |Added ---------------------------------------------------------------------------- CC| |cookie.wolfrom@liblime.com -- 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.
http://bugs.koha.org/cgi-bin/bugzilla3/show_bug.cgi?id=3419 Beverly Church <beverly.church@liblime.com> changed: What |Removed |Added ---------------------------------------------------------------------------- CC| |nicole.engard@liblime.com -- 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.
http://bugs.koha.org/cgi-bin/bugzilla3/show_bug.cgi?id=3419 Jane Wagner <jwagner@ptfs.com> changed: What |Removed |Added ---------------------------------------------------------------------------- CC| |jwagner@ptfs.com --- Comment #1 from Jane Wagner <jwagner@ptfs.com> 2009-08-03 15:06:20 --- I thought I'd reported a bug a while back, but I can't find it. So far as I can tell, any report download truncates at 10,000 records. The screen display shows more, but the downloaded .csv file cuts off at that point. -- 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.
http://bugs.koha.org/cgi-bin/bugzilla3/show_bug.cgi?id=3419 Liz Rea <wizzyrea@gmail.com> changed: What |Removed |Added ---------------------------------------------------------------------------- CC| |wizzyrea@gmail.com --- Comment #2 from Liz Rea <wizzyrea@gmail.com> 2009-08-03 15:12:35 --- Tab Separated has the same limitation. -- 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.
http://bugs.koha.org/cgi-bin/bugzilla3/show_bug.cgi?id=3419 David Schuster <dschust1@gmail.com> changed: What |Removed |Added ---------------------------------------------------------------------------- CC| |dschust1@gmail.com -- 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.
http://bugs.koha.org/cgi-bin/bugzilla3/show_bug.cgi?id=3419 Chris Cormack <chris@bigballofwax.co.nz> changed: What |Removed |Added ---------------------------------------------------------------------------- CC| |chris@bigballofwax.co.nz --- Comment #3 from Chris Cormack <chris@bigballofwax.co.nz> 2009-08-25 12:29:34 --- Yep it's this line here, line 399 of C4/Reports/Guided.pm $limit = 9999 unless $limit; Last changed at the end of March. I'm guessing it was added to stop people killing their Koha by putting some sql that returned millions and millions of rows by accident. If you put a limit in your query, say 15000, then you should get 15000 eg SELECT * FROM items LIMIT 15000 -- 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.
http://bugs.koha.org/cgi-bin/bugzilla3/show_bug.cgi?id=3419 Chris Cormack <chris@bigballofwax.co.nz> changed: What |Removed |Added ---------------------------------------------------------------------------- Priority|P5 |PATCH-Sent Version|rel_3_0 |rel_3_2 --- Comment #4 from Chris Cormack <chris@bigballofwax.co.nz> 2010-01-04 17:55:26 --- The code also needs changing Michael hafen has sent a patch http://lists.koha.org/pipermail/koha-patches/2009-November/004815.html -- 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.
http://bugs.koha.org/cgi-bin/bugzilla3/show_bug.cgi?id=3419 Mickey Coalwell <mcoalwell@nekls.org> changed: What |Removed |Added ---------------------------------------------------------------------------- CC| |mcoalwell@nekls.org -- 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.
http://bugs.koha.org/cgi-bin/bugzilla3/show_bug.cgi?id=3419 --- Comment #5 from Galen Charlton <gmcharlt@gmail.com> 2010-05-10 22:25:05 --- (In reply to comment #4)
The code also needs changing
Michael hafen has sent a patch
http://lists.koha.org/pipermail/koha-patches/2009-November/004815.html
The patch in question was pushed in November. Can this bug be closed? -- 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.
participants (2)
-
bugzilla-daemon＠kohaorg.ec2.liblime.com -
bugzilla-daemon＠liblime.com