Re: [Koha] SQL reports in Koha 23.05

Hi Isabel, you've probably run into this bug: *Bug 33966* - "Update and run SQL" for non-English templates Please try switching to English for editing until this is fixed. Hope this helps, Katrin On 19.06.23 23:34, Isabel

Re: [Koha] SQL reports in Koha 23.05

Hello Isabel does it show any error after you update the SQL reports? On Tue, Jun 20, 2023 at 3:04 AM Isabel Pineda wrote: > Hi. > > I installed Koha 23.05 today and noticed that I cannot edit my SQL reports > anymore. The changes don't get saved. What can I do? > > Thank you. > Isabel Pineda >

[Koha] SQL reports in Koha 23.05

Hi. I installed Koha 23.05 today and noticed that I cannot edit my SQL reports anymore. The changes don't get saved. What can I do? Thank you. Isabel Pineda ___ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz Unsubscribe:

Re: [Koha] Local covers and the Coverflow plugin

Hi You need to "discard" items with no covers from your query. We use this: SELECT DISTINCT biblio.title, biblio.biblionumber, c.imagenumber AS localcover FROM items i LEFT JOIN biblioitems USING (biblioitemnumber) LEFT JOIN biblio ON (i.biblionumber=biblio.biblionumber) LEFT JOIN biblioimages

Re: [Koha] Importing records into Koha - smaller batches per year of catalogization?

Hi You don't need to sort your records for importing. I usually only split it by a number of record blocks. I use 10K records at once for easy handle and control, but it is possible to do more at a time. I might depend on the hardware you have your koha installation on. Regards, Alvaro .