Accession Register report

Koha version: 19.05.3
Module: Catalogue
Purpose: Accession register with joined Title and subtitle, Authors and Editors

SELECT items.barcode,items.itemcallnumber,
CONCAT_WS('',biblio.author,'; ',ExtractValue(metadata,'//datafield[@tag="700"]/subfield[@code="a"]')) AS Author,CONCAT(biblio.title,' ',ExtractValue(metadata,'//datafield[@tag="245"]/subfield[@code="b"]')) AS Title,biblioitems.publishercode
FROM items
LEFT JOIN biblioitems ON (items.biblioitemnumber=biblioitems.biblioitemnumber)
LEFT JOIN biblio ON (biblioitems.biblionumber=biblio.biblionumber)
LEFT JOIN biblio_metadata on (biblio_metadata.biblionumber=biblio.biblionumber)
WHERE items.homebranch =<<Branch|branches>> AND items.itype=<<Item type|itemtypes>> AND items.dateaccessioned BETWEEN <<Between Date (yyyy-mm-dd)|date>> and <<and (yyyy-mm-dd)|date>> ORDER BY items.barcode DESC

Manage collections using Authorized values

Collection management is easy and very convenient with Authorized values feature with Koha. Libraries need to generate collections wise report of records. For example, an engineering college requires collection wise (Mechanical, Civil, Computer etc.) list of books. Such reports have to submit to accreditation agencies (e.g. AICTE, MCI) every year. The same way libraries can create various collections like biography, autobiography, and travelogue. It is found that users add collection codes into Item Type (942$c) mistakenly. They don't know the availability of Authorized values for the purpose. Here are the steps to create collections with Authorized values and generate a collection-wise report.

Add collections to Authorized Values

Go to Koha > Administration > Authorized Values and select CCODE

Select New authorized value for CCODE button.

Add a new Collection Code

1. Enter a shortcode for the new collection. Preferably in capital letter.

2. Enter the description

3. Enter the description for OPAC

4. Select the library branch code.

5. Save the new collection

Same way creates other collections.

Add collection to record

Create a catalogue record, Koha > Cataloguing

Add Biblio information (e.g. author, title, call number etc.)

Save the Biblio information of the catalogue.

The collection code appears in the Item Information part of the catalogue.

Select the appropriate collection code match with the record and save the record.

Generate collection wise report

Item wise search available at Koha > Advanced Search > Go to item search (This feature available with the Koha version 18.05.x onwards).

Select collection code and generate a report.

The collection-based report generates and can view on the browser. The report can download as spreadsheet formats.

Report for date wise list of checked in books

• Module: Circulation
• Purpose: To generate datawise list of checked in books
• Example: List of checked in books between 2013-07-20 to 2013-07-25
• Status: Complete 
• SQL Link: Click here