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.b...@ptfs-europe.com
_______________________________________________
Koha mailing list http://koha-community.org
Koha@lists.katipo.co.nz
http://lists.katipo.co.nz/mailman/listinfo/koha
