[Koha] strange behavior with a public report

[Arturo Longoria]

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/>