What are barcodes and how can they be identified?
What are barcodes?
Barcodes are unique numbers, manually applied to all items on a Koha system. Unlike item numbers, which are automatically generated by the system as items are created these are assigned by the library as item records are created. Generally, barcodes appear on the item records, unless they have been set to be hidden.
For more details on hiding and revealing fields on the item record field, please check our Help Centre or contact Interleaf Technology directly.
What are they used for?
The main use for barcodes is to allow individual items to be checked out to patrons on the system. They can also be used to identify records within the SQL database.
How can they be found?
Barcodes can be found on item records and specific barcodes can be searched through the catalogue.
Barcodes can also be found through SQL report, for example:
SELECT items.barcode
FROM items
It should be noted that this is the report at its most basic and if there are many items on the catalogue it could slow the system searching for them.
For advice about the different ways to limit reports, please check our Help Centre for report information or contact Interleaf Technology directly.
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 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 ...Question of the Week - Using the CASE statement and formatting information to be included in a SQL report
This document will outline how a list of information can be formatted so it can be easily added to a SQL statement as well as a creative way we used the CASE statement to categorise the different system preferences being shown in an SQL report. The ...How to view the content of an SQL report
This document will outline how to view the content of an SQL report on the Koha system. This may be a precursor to editing the report or just a way to start studying the format of reports How to find reports on your system Go to the Reports module on ...The two most common SQL statements within Koha application reports
This document will outline the two most common statements which appear in SQL reports run in the Koha application. SQL reports within the Koha application can only be run the return information that exists in the database, however, other SQL tools ...