Re: [Koha] Report coming up short?

2011-04-21 Thread Ian Bays
Hi. There is a default "limit" of 1 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 9" to your sql perhaps. I hope it still works... Ian On 21/04/2011 18

Re: [Koha] Report coming up short?

2011-04-21 Thread Paul
At 08:43 PM 4/21/2011 +0200, Magnus Enger wrote: >This sounds like a known bug, which will be fixed in 3.4: >http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=6028 Thanks - as soon as I got the reply about a hard limit I grepped the code, found it in c4/records/guided.pm and modded it. I'm

Re: [Koha] Report coming up short?

2011-04-21 Thread Bob Ewart
On 04/21/2011 01:57 PM, 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(' href

Re: [Koha] Report coming up short?

2011-04-21 Thread Paul
At 01:29 PM 4/21/2011 -0500, Liz Rea wrote: >Paul, >Try adding a LIMIT reults> to the end of that report, and see if it works. Thank you Liz and Ian -- now functional Best regards - Paul >Liz Rea >NEKLS > >On Apr 21, 2011, at 12:57 PM, Paul wrote: > > > Would some kind librarian with more than

Re: [Koha] Report coming up short?

2011-04-21 Thread Magnus Enger
Hi! On 21 April 2011 19: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. This sounds like a known bug, whi

Re: [Koha] Report coming up short?

2011-04-21 Thread Liz Rea
Paul, Try adding a LIMIT to the end of that report, and see if it works. Liz Rea NEKLS On Apr 21, 2011, at 12:57 PM, 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 > trunca

[Koha] Report coming up short?

2011-04-21 Thread Paul
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('',title,'') AS Title FROM biblio ORDER BY biblio