What are patron cardnumbers and how to find them?
What is a cardnumber?
Cardnumbers are unique numbers that are manually applied to new patron records by the staff member creating the patron record. They do not necessarily need to come from a physical card. The cardnumber must be unique but it can be edited at any time through the staff side of Koha. The function of a cardnumber is to act as an identification number for the patron record and the hook to complete and track circulation actions through.
How can a cardnumber be identified?
Patron Account
On a patron record, the cardnumber can be seen in the Library use section of the patron account.
Reports
There are many different reports that can bring back the cardnumbers on records. A basic setup would be:
SELECT cardnumber
FROM borrowers
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 patron category, registration date and home branch.
As all patron accounts will have a cardnumber 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 cardnumber or range of cardnumbers, please contact Interleaf Technology directly.
| Version | Date | Detail | Author |
| 1.0 | 29/01/26 | Document created | Holly Cooper |
Related Articles
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 ...How to batch delete GONE borrowers using the reports module
This document will outline how to delete GONE borrowers from Scooter. Run the Borrowers requiring manual deletion report. Go to Reports > Guided reports click Use saved and you will be brought to a new page with a table of all the reports currently ...How to Batch Edit Extended Patron Attributes
This document outlines how to perform a batch patron modification for extended patron attributes. Extended patron attributes capture non - standard information about patrons and for more information about them please see our Help Centre. Step 1 - ...First Report Challenge: A client wants to put together a report to show the cardnumber, first name and second name of all patrons on the system.
These notes are intended to be used to help answer the associated Report Challenge that was released last week. Take a look at the question below and think about how you would approach answering it: A client wants to put together a report to show the ...Second Report Challenge: A client wants to put together a report to show the cardnumber, first name and second name, concatenated.
These notes are intended to be used to help answer associated "Report Challenge" that was released earlier. Take a look at the question below and think about how you would approach answering it: A client wants to put together a report to show the ...