[Koha] Koha 18.11 - SQL report to select ISBNs by Subject
Craig Butosi
cbutosi at gmail.com
Tue Mar 19 05:29:11 NZDT 2019
Hi everyone,
Running Koha 18.11 on Ubuntu 16.04 w/ MariaDB. Having a bit of trouble
understanding the db structural changes made in 18.xx and how SQL reports
are built in Koha 18.11. I know some tables and such have changed since the
old 16.xx days.
*I'd like to create a report that draws a list of ISBNs, along with call
number and title, for my coverflow carousel based on subject (i.e., 650$a)
keyword*. I'd like to start featuring subject-based resources on the
carousel, not just new items.
Any help would be very much appreciated. Just a note: there are a few
reports on the Koha SQL reports wiki that involve querying on the 650
field; but these do not work for what I would like to achieve.
Many thanks,
Craig Butosi, MA, MLIS, B Mus (Hons)
Library: library.craigbutosi.ca
More information about the Koha
mailing list