Hello Alvaro, I don't know how to do that, since I never even touched SQL before. I can copy and paste code from the SQL list, but don’t really understand what it does and how to change it to do what I need. I just checked the report, it is public. The code I'm using is from the plugin configuration: 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 != '' GROUP BY biblionumber HAVING isbn != "" ORDER BY rand() LIMIT 30 The instructions then go on to say: Note: You can add an additional column 'localcover' - this should be blank if the biblio doesn't have a localcover and can contain any other data if it does. If this column is populated a local cover will be used. Example below: SELECT DISTINCT biblio.title, biblio.biblionumber, SUBSTRING_INDEX(biblioitems.isbn, ' ', 1) AS isbn, c.imagenumber AS localcover FROM items LEFT JOIN biblioitems USING (biblioitemnumber) LEFT JOIN biblio ON (items.biblionumber=biblio.biblionumber) LEFT JOIN cover_images c ON (items.biblionumber=c.biblionumber) WHERE biblioitems.isbn IS NOT NULL AND biblioitems.isbn !='' ORDER BY RAND() LIMIT 15; But when I tried replacing the first code with the second, I didn't get any results. Right now I'm back to the original code, and have turned the local covers option off, so I have several "No image available" images. Where do I change what to get local covers? Best regards Aida Đikić From: Alvaro Cornejo <cornejo.alvaro@gmail.com> Sent: Friday, June 16, 2023 4:27 PM To: library@ssst.edu.ba Cc: koha@lists.katipo.co.nz Subject: Re: [Koha] Local covers and the Coverflow plugin Hi Aida You only need to change/edit the report that pulls information for coverflow. Also remember to define the report as public. Regards Alvaro |----------------------------------------------------------------------------------------| Stay safe / Cuídate/ Reste sécurisé Switch off as you go / Apaga lo que no usas / Débranchez au fur et à mesure. Recycle always / Recicla siempre / Recyclez toujours Print only if absolutely necessary / Imprime solo si es necesario / Imprimez seulement si nécessaire Le ven. 16 juin 2023 à 03:41, mailto:library@ssst.edu.ba <mailto:library@ssst.edu.ba> a écrit : Hello again, I'm trying to find a way to have local covers show in the Coverflow plugin on the OPAC page for titles not added via Z39.50. I had originally set it up using the first example in the configuration (items added in the last 30 days), but going back I see there's another example for adding additional columns. Since it said, "you can add an additional column" I thought I was supposed to paste it below the already existing code. That... ended up with an error yeah :) So I replaced it and ran the report but could not get a local cover. What am I doing wrong this time? I uploaded the cover in the holdings area. Is there another location I should do it instead? I checked old posts on the mailing list, but could not find any solutions for this. I would also like to work out a way to show covers of our collections (e.g. CS textbooks, ECON textbooks, donated books etc.) but for that I need to figure out lists?? I'm on Koha 23.05.00 and Ubuntu 22.04.2 LTS. Best regards Aida Đikić _______________________________________________ Koha mailing list http://koha-community.org mailto:Koha@lists.katipo.co.nz Unsubscribe: https://lists.katipo.co.nz/mailman/listinfo/koha