Koha CoverFlow (New Arrivals)
Koha CoverFlow (New Arrivals) Create a SQL public Report Create a report and please note down the report id (here is SQL statement for New Arrivals) Reports › Create from SQL Copy and paste the following line SELECT b.biblionumber, i.Barcode, SUBSTRING_INDEX(m.isbn, ' ', 1) AS isbn, b.title FROM items i LEFT JOIN biblioitems m USING (biblioitemnumber) LEFT JOIN biblio b ON (i.biblionumber=b.biblionumber) WHERE DATE_SUB(CURDATE(),INTERVAL 15 DAY) <= i.dateaccessioned AND m.isbn IS NOT NULL AND m.isbn != '' GROUP BY biblionumber HAVING isbn != "" LIMIT 30 Plugin: https://github.com/bywatersolutions/koha-plugin-coverflow Download : https://github.com/bywatersolutions/koha-plugin-coverflow/releases Enable koha plugin in terminal if not enabled Terminal sudo su sudo leafpad /etc/koha/sites/library/koha-conf.xml ( find ) <pluginsdir>/var/lib/koha/library/plugins</pluginsdir> <enable>_plugins>0</enable_plugins> (Change