Monday Minutes: Scannable Barcodes in Reports

by Jessie Zairo on Apr 15, 2024

In this week's Monday Minutes, Kelly and Jessie show off how to add a report with scannable barcodes. If you need a report for weeding, item locations or analysis, use the report below.

Scannable Barcode Report

SELECT

i.biblionumber,

i.itemnumber,

b.title AS `Title`,

b.author AS `Author`,

i.itemcallnumber AS `Call Number`,

i.barcode AS `Barcode`,

CONCAT(

'<br />',

'<img src="/cgi-bin/koha/svc/barcode?barcode=',

'*',

UPPER(i.barcode),

'*',

'&type=Code39" />',

'<br />',

i.barcode,

'<br />') AS `Scannable Barcode`

FROM

items i

LEFT JOIN biblio b

ON i.biblionumber = b.biblionumber

WHERE

i.homebranch = <<Location|branches>>

AND COALESCE(i.itype, '') = <<Item type|itemtypes>>

AND COALESCE(i.ccode, '') = <<CCODE>>

AND COALESCE(i.location, '') = <<LOC>>

More Resources

Self Paced Learning in Koha: Reports

Koha Community Challenge

ByWater Solutions has partnered with koha-US for another Community Challenge! This is a great way for the open source community to come together, move, and raise money for a good cause!

Walk, Jog, Run, Swim, Bike, Hike, Yoga, Dance- whatever your activity of choice is-come join us for this community challenge! Be part of the open-source community sharing your daily activities, photos, and words of wisdom!

The challenge will go from May 1 - May 31.

Register today Koha Community Challenge 2024!