[Koha] Reporting on 942$c

I'm working on a report, and I'd like to see data related to the 942$c field. We want to look at instances where it's different than 952$y, and validate these. Where (if anywhere) is this field stored in the database? I can't find it. It doesn't seem to always match either item.itype or biblioitem.

[Koha] Searching problem

Hello All, I am having trouble searching some of the records in the database having a colon ":" punctuation mark in the titles such as "Marx at the Margins: On Nationalism, Ethnicity, and Non-Western Societies", "Bhutan: new pathways to growth", "Dayananda Sarasvati: his life and ideas", etc. Howe

Re: [Koha] Reporting on 942$c

Hi Joel, The full MARCXML record is available in the metadata field of the biblio_metadata table. You need to use that table in your query and an ExtractValue function to get the particular subfields you’re interested in. I would recommend looking at the Reports library in the wiki which should be

Re: [Koha] Searching problem

Hi Dibyendra, Since the searches work when you omit the colon, I suspect that it is being treated as a special character and not interpreted literally, causing queries to fail. I know that authority searches look like "an:510335" so I think the role of a colon is to separate an index ("an" for "au

Re: [Koha] Installation from Source Code

Hello again, all! In a recent exchange, on 9 Dec. 2019, at 07:05, Franz Dietrich wrote: It is quite possible but a lot of work... I think it would be easier to > carry the server to an internet access install and setup everything then > bring it back to where it is supposed to run. > > becau

[Koha] SQL help

Our overall library collection is currently split between 2 different catalogues. The other catalogue can produce a report showing the number of opac searches (total, successful and unsuccessful) for each day of each month for the year. Can anyone help with how I can replicate that in Koha? Tha

Re: [Koha] SQL help

‘Unsuccessful’ would be a search where no search results were returned. ‘Successful’ would be searches that retrieved results Thanks, Kerrie Stevens From: Coehoorn, Joel Sent: Wednesday, 11 December 2019 3:54 PM To: Kerrie Stevens Subject: Re: [Koha] SQL help Define "unsuccessful" On Tue,