Hi. There is a default "limit" of 10000 on the sql reports. I believe that if you provide your own "limit" statement in your sql then you should get your choice of the limit rather than the default. So try adding "limit 99999" to your sql perhaps. I hope it still works... Ian On 21/04/2011 18:57, Paul wrote:
Would some kind librarian with more than 10,000 biblios please try running the following Mysql report. I works as expected, except that the csv output truncates at 10,000. If confirmed, I will attempt to post a bug.
SELECT biblionumber, CONCAT('<a href=\"/cgi-bin/koha/catalogue/detail.pl?biblionumber=',biblionumber,'\">',title,'</a>') AS Title FROM biblio ORDER BY biblionumber
Thanks,
Paul Tired old sys-admin
_______________________________________________ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha
-- Ian Bays Director of Projects PTFS Europe mobile: +44 (0) 7774995297 phone: +44 (0) 800 756 6803 skype: ian.bays email: ian.bays@ptfs-europe.com