Monday Minutes: Local Use on Return Enhancements

by Jessie Zairo on Oct 21, 2024

In this week's Monday Minutes, Nick and Jessie discuss the Local Use on Return Enhancement in Koha. A new field has been added to the item table for "local_use" to keep the count of local uses.

In previous releases, this data was kept in the statistics table. Now, the data will be retained in both statistics and item tables, making it easy for staff to see this in the holdings table on a detailed bibliographic page in the staff client and run reports to look at local use in the items table.

Bug 16122 - Item record needs to keep local use count.

System Preference

The system preference RecordLocalUseOnReturn must be set to “Record” to record local use by checking out to the statistical patron and/or by checking in a book that is not currently checked out.

Column Configuration

You can configure your table columns to show local use in the holdings table.

1. Click on Configure on the holdings table or Navigate to Administration --> Table settings
2. Select Catalogue tables
3. Scroll down to Table id: holdings_table
4. Make sure holdings_localuse is unselected, this will make it visible in the holdings table

Report

This report allows staff to choose an item type and see all the local use for that particular itemtype.

SELECT

biblio.title,

items.barcode,

items.itemcallnumber,

items.issues,

items.renewals,

items.localuse

FROM items

JOIN biblio USING (biblionumber)

WHERE items.itype = <<Item type|itemtypes>>

Additional Resources

Monday Minutes: Statistical Patron and Local Use

Koha Question of the Week: What is a Statistical Patron?