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
[email protected]
https://lists.katipo.co.nz/mailman/listinfo/koha
