[Koha] UPDATE: SQL edit for Non-circulating items report

ATTN: Please remove earlier message from listserv. Further inquiry has shown that the system permissions for our local installation of Koha do not allow this user to SELECT from the biblioitems table. David Sale Coastline Library System Coos/Curry County, Oregon From: David Sale Sent: Friday

[Koha] Koha Community Newsletter: July 2020

The Koha Community Newsletter for July 2020 is here: https://koha-community.org/koha-community-newsletter-july-2020/ Many thanks to the folks who submitted articles and news to this month's newsletter. Please feel free to email me with any corrections or suggestions. -- Chad Roseburg Editor, K

Re: [Koha] SQL edit for Non-circulating items report

Excerpts from David Sale's message of 2020-07-31 19:12:13 +: > However, adding "b.isbn" to the SELECT list (as with "b.title", "b.author", > etc.) breaks the report and renders it non-functional. You might find this page useful, since it does provide some isbn examples: https://wiki.koha-com

Re: [Koha] SQL edit for Non-circulating items report

The ISBN is in the biblioitems table.  Change b.isbn to bi.isbn and add LEFT JOIN biblionitems bi USING (biblionumber) before the line that starts with WHERE. On 7/31/20 2:12 PM, David Sale wrote: Hello, Our library is engaged in a weeding project that requires a SQL report for Koha to be cu

[Koha] Query on Tracking in-house use

This is my first post to the community and I want to thank you all for this fantastic resource. I have learned so much over the past few months since we went live with Koha last year. We are about to go live with 19.11 and I have a question about Tracking in-house use. We would like use this to

[Koha] SQL edit for Non-circulating items report

Hello, Our library is engaged in a weeding project that requires a SQL report for Koha to be customized. The report we are attempting to customize was written by ByWater Solutions, and it generates a list of items "not seen" in X years, by branch and shelf location. The existing report is wri

Re: [Koha] Query on Tracking in-house use

Patricia, I am sure you will get others to respond on what they prefer or why they use the process they do- but I am going to share another resource about the set up of each in this tutorial video/blog post: https://bywatersolutions.com/education/monday-minutes-statistical-patron-and-local-use Bes