[Koha-bugs] [Bug 10756] Carousel Display of New Titles on OPAC home page

[bugzilla-daemon at bugs.koha-community.org]

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=10756

--- Comment #28 from Nick Clemens <nick at bywatersolutions.com> ---
(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.