https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=10756
--- Comment #28 from Nick Clemens <[email protected]> --- (In reply to Mason James from comment #27) > (In reply to Nick Clemens from comment #23) > > The ByWater plugin actually can automatically update the covers used. It > > uses a public report, chosen in config, so updates whenever the cache > > expires. > > hi Nick, that sounds positive. > > can you please provide the SQL for the public report, so i can test this > further? Pasting in the default report we use, but the plugin allows for use of any report the user saves in Koha through the reports module So we have used it to report froma public list, or only on specific item types, we even have a few libraries that manually restrict the report to biblios in the IN statement. Standard setup is this: SELECT b.biblionumber, 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 30 DAY) <= i.dateaccessioned AND m.isbn IS NOT NULL AND m.isbn != '' HAVING isbn != "" ORDER BY rand() LIMIT 7 -- You are receiving this mail because: You are watching all bug changes. _______________________________________________ Koha-bugs mailing list [email protected] http://lists.koha-community.org/cgi-bin/mailman/listinfo/koha-bugs website : http://www.koha-community.org/ git : http://git.koha-community.org/ bugs : http://bugs.koha-community.org/
