Hi Peter,
I believe there is a built-in default limit of 10000 for sql reports "to
protect users from downloading too much or filling the server with an
error"...
I also understand that if you add a LIMIT statement to the sql then that
takes precedence.
So for example you could add " LIMIT 99999" to your sql and see if that
works.
It might be nice to have something either on-screen or in help about this.
Good luck.
Ian
PS if you are subscribed to the normal Koha list that might be a better
list for this question rather than development...
On 25/11/2010 09:09, Peter Mwangi wrote:
Dear all,
We have been trying to generate reports from KOHA. However, after
building our report, we download it in excel and only get 10000 records
(rows). We expect to get at least 40,000 records. Where could we be
going wrong or rather what are we doing or not doing? Is this a koha or
excel- related challenge?
_______________________________
Peter Mwangi Gichiri
Systems Librarian, NEGST/ Africa International University P.O.Box, 24686
- 00502 Karen, Nairobi
Tel: 254 (02) 882104/5; Cell: 0721 - 621692
Email: peter.mwa...@negst.edu
Website: www.negst.edu
_______________________________________________
Koha-devel mailing list
Koha-devel@lists.koha-community.org
http://lists.koha-community.org/cgi-bin/mailman/listinfo/koha-devel
website : http://www.koha-community.org/
git : http://git.koha-community.org/
bugs : http://bugs.koha-community.org/
--
Ian Bays
Director of Projects
PTFS Europe.com
mobile: +44 (0) 7774995297
phone: +44 (0) 800 756 6803
skype: ian.bays
email: ian.b...@ptfs-europe.com
_______________________________________________
Koha-devel mailing list
Koha-devel@lists.koha-community.org
http://lists.koha-community.org/cgi-bin/mailman/listinfo/koha-devel
website : http://www.koha-community.org/
git : http://git.koha-community.org/
bugs : http://bugs.koha-community.org/
