Conversation
supportWe are using a curated list to populate our book river on our catalog ( http://www.catalog.mydpl.org ) but, the report we use there, does not work for our website book river. This is the code used by Koha for the catalog to pull the titles from the list: SELECT biblionumber, SUBSTRING_INDEX(isbn, ‘ ‘, 1) AS isbn, title FROM virtualshelfcontents LEFT JOIN biblioitems USING (biblionumber) LEFT JOIN biblio USING (biblionumber) WHERE shelfnumber=715 ORDER BY rand() LIMIT 25 Any idea what syntax I need to use to get bookshelves to populate based on this report? The page I need help with: [ log in to see the link]
Can you provide a link to the Koha report?
Wouldn’t that require a login to our koha? Here is a link to the edit for it. I do not have bookshelves pointed at it currently https://staff.mydpl.org/cgi-bin/koha/reports/guided_reports.pl?reports=23&phase=Edit%20SQL
What you need to use Koha Reports Web Service with Bookshelves is the JSON results file from a public report, e.g. https://catalog.mydpl.org/cgi-bin/koha/svc/report?id=23 Here is the Koha documentation: https://koha-community.org/manual/latest/en/html/webservices.html#json-reports-services Remove the Biblionumbers from the results and it should work.
this should be a public report, hopefully this is the link to it: https://decatural.bywatersolutions.com/cgi-bin/koha/svc/report?id=173 So, I should just delete the lines that say LEFT JOIN biblioitems USING (biblionumber) LEFT JOIN biblio USING (biblionumber) ?
That may do it for you
Can you provide a link to the Koha report?
Wouldn’t that require a login to our koha? Here is a link to the edit for it. I do not have bookshelves pointed at it currently https://staff.mydpl.org/cgi-bin/koha/reports/guided_reports.pl?reports=23&phase=Edit%20SQL
What you need to use Koha Reports Web Service with Bookshelves is the JSON results file from a public report, e.g. https://catalog.mydpl.org/cgi-bin/koha/svc/report?id=23 Here is the Koha documentation: https://koha-community.org/manual/latest/en/html/webservices.html#json-reports-services Remove the Biblionumbers from the results and it should work.
this should be a public report, hopefully this is the link to it: https://decatural.bywatersolutions.com/cgi-bin/koha/svc/report?id=173 So, I should just delete the lines that say LEFT JOIN biblioitems USING (biblionumber) LEFT JOIN biblio USING (biblionumber) ?
That may do it for you