[Koha] Report coming up short?

Ian Bays ian.bays at ptfs-europe.com
Fri Apr 22 06:30:23 NZST 2011


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 at 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 at ptfs-europe.com



More information about the Koha mailing list