[Koha] planning categories in acquisitions

Hi Koha Community First time on here, but hope you can help out. I'm an acquisitions librarian wanting to make best use of the statistical options available in the Acquisitions module for tracking spending, but I am unable to fully understand from the example in the documentation how to make

[Koha] Mysql query

I'm looking, please, for some expertise in writing MySQL queries (Koha reports.) I have a good report for listing high value items in our collections (a requirement for our insurers), but need to add the special case of multi volume biblios. Example: a set of Britannicas (14th ed.) is a

Re: [Koha] Mysql query

Why not first select those biblios with item.price = XX SELECT ...what you need... FROM ( SELECT sum(price) as totalprice, biblionumber FROM items WHERE price = XX GROUP BY biblionumber ) as biblio_price LEFT JOIN biblioitems on (biblio_price.biblionumber=**biblio items.biblionumber) LEFT

[Koha] Marc framework errors

Using koha 3.10.4 If I run a 'MARC bibliographic framework test' I get this: -- MARC bibliographic framework test TestResult itemnum The field itemnum MUST be mapped The corresponding subfield MUST be in with -1 (ignore) tab OK All item fields are in the same tag