Re: [Koha] SQL help please

Hi Kerrie, You haven't joined the Items table. So: JOIN items ON (biblio_metadata.biblionumber = items.biblionumber) HTH, Bob Calyx On 12/06/18 08:43, Kerrie Stevens wrote: I have the following report which almost does what I need but I can't quite get it there. I want to be able get a list

[Koha] SQL help please

I have the following report which almost does what I need but I can't quite get it there. I want to be able get a list of titles and the Dewey from 082$a but I also want to be able to select for which collection I want the results - that is where I'm getting stuck. I can select the collection

[Koha] Item cataloging interface proposal

Bug 13680, "Items list on edit items page separates add items form from header and sidebar" (https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=13680) proposes a layout change to the item add/edit screen: https://bugs.koha-community.org/bugzilla3/attachment.cgi?id=35720 I have a

[Koha] Add your KohaCon19 Hosting Proposal to wiki

Anyone who would like to host KohaCon19 (international Koha conference to be held in 2019) should add some brief information about their proposal to the proposals summary table in the page on the Koha Wiki which has been prepared following the model used for previous KohaCons,

[Koha] Zebra - less logging

Does anyone with Zebra knowledge know how to scale back the amount of logging which takes place. I'm still running Zebra for indexing with V17.11 and finding the logs are very large each day. I'd like to scale back logging so I only get errors logged. How might that be done? Thanks, Tom --