Could it be the "SvcMaxReportRows" Syspref is set to it's default of 10. This could be only displaying the first 10 biblios everytime the report is run? Regards Barry Cannon Interleaf Technology http://www.interleaf.ie Tel: +35312865855 Email: bc@interleaf.ie Skype: bar.cannon ________________________________________ From: Koha [koha-bounces@lists.katipo.co.nz] on behalf of Arturo Longoria [Arturo.Longoria@sll.texas.gov] Sent: 13 May 2015 15:18 To: koha@lists.katipo.co.nz Subject: [Koha] strange behavior with a public report Hi all, I've come across strange behavior with a public report in Koha since our library was upgraded to 3.18. I'm not sure if it is a bug or if I am doing something incorrectly, and so I thought I'd ask for some input. I've created a custom SQL report that will output basic bibliographic data for titles that are included in a list ("virtual shelf"), and I have marked this report as public so that I can access its JSON output via /cgi-bin/koha/svc/report?id={report id}&sql_params={virtual shelf number} on the public side. The issue I'm having is that if I run this report within the staff client, it works perfectly. If I edit the list by adding/removing titles to it and then re-run the report in the staff client, everything is displayed as expected. But if I run the report on the public side to get the JSON output, the report will only show me bib. info for the titles that were originally saved in the list! That is, when I first create a list and access its JSON output, it works fine. But if I then edit the list by removing a title or adding a new title, the JSON output is not updated – it continues to show me the old contents of the list. If I run the report through the staff client, though, it does show me the updated contents of the list! The two outputs are different. Any ideas on what could be causing this? The report's settings have a cache expiry of 0 seconds (the default). I've tried setting different cache expiry periods to see if that is the issue, but that seems to do nothing. The SQL is a very simple select statement: SELECT biblionumber, author, title, seriestitle, copyrightdate, notes, abstract FROM virtualshelfcontents vsc LEFT JOIN biblio using (biblionumber) WHERE vsc.shelfnumber = <<Enter shelf number>> Arturo Longoria Texas State Law Library www.sll.texas.gov<http://www.sll.texas.gov/> _______________________________________________ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz https://lists.katipo.co.nz/mailman/listinfo/koha