[Koha] strange behavior with a public report

[Arturo Longoria]

Ah, I hadn't considered that possibility, but unfortunately, I don't think that's the cause. SvcMaxReportsRow is set to 300 rows, and the lists I am creating don't ever contain more than 6 titles.

-----Original Message-----
From: Barry Cannon [mailto:bar at interleaf.ie] 
Sent: Wednesday, May 13, 2015 09:31
To: Arturo Longoria; koha at lists.katipo.co.nz
Subject: RE: strange behavior with a public report

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 at interleaf.ie
Skype: bar.cannon

________________________________________
From: Koha [koha-bounces at lists.katipo.co.nz] on behalf of Arturo Longoria [Arturo.Longoria at sll.texas.gov]
Sent: 13 May 2015 15:18
To: koha at 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
_______________________________________________
Koha mailing list  http://koha-community.org Koha at lists.katipo.co.nz https://lists.katipo.co.nz/mailman/listinfo/koha