[Koha] Report coming up short?

[Ian Bays]

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