What are biblionumbers and how to find them
What is a biblionumber?
Biblionumbers are unique numbers automatically applied by Koha to bibliographic records created on the site. These numbers are assigned as title records are created and cannot be edited from within the Koha application. The function of a biblionumber is to act as an identification number for a title record.
How can a biblionumber be identified?
URL
On a bibliographic record the biblionumber is in the URL:
Reports
There are many different reports that can bring back the biblionumbers on records. A basic setup would be:
SELECT biblionumber, title
FROM biblio
LIMIT 10
This report will bring back results similar to the image below:
This basic report can be limited in an almost unlimited number of ways, including by a specific title, collection codes and date added to the site.
As all title records will have biblionumbers an unlimited report should not be run as the resources used to bring back the result might slow the site
For assistance in creating a report to bring back a specific biblionumber, please contact Interleaf Technology directly.
| Version | Date | Detail | Author |
| 1.0 | 11/12/25 | Document created | Holly Cooper |
| 1.1 | 29/12/25 | Adding details | Holly Cooper |
Related Articles
How to Find and Run a SQL Report
What are reports for? Reports are used to find and present data about the information on the system in a structured manner. Reports use SQL to ask questions of the Koha database. How to find reports on your system Go to the Reports module on the Koha ...Overview of some SQL Report Functions
Overview of SQL Report Functions This FAQ is an example of a simple report describing the “anatomy” of the SQL code used. Details about the different functions are outlined in the table below the report. Some functions are mandatory to use in order ...Errors Loading Bibliographic Records on EDS
Errors Loading Bibliographic Records on EDS If you find that some of your bibliographic records are not appearing on your EDS search, the chances are that they have been rejected during the loading process on EDS. There is a file of ‘bad records’ ...How to find and edit the username on a patron account
This document will outline how to check and edit a patron's username. What is the function of a username on Koha? Every patron account created on Koha will have username and password. Usernames and passwords are either assigned by the staff member ...Batch Record Deletion
Batch Record Deletion There may be times when you will want to delete a batch of bibliographic records. You will need to delete all the attached items first, but then you can follow this process to delete the bibliographic records with no attached ...