reports tutorial

Creating a Report for your Library using the Koha Report Wiki

Creating a Report for your Library using the Koha Report Wiki In this video Koha tutorial you will learn how to use the Koha Report Wiki (the home of over 700 reports to be used in Koha) by copying a report and adding that report to your Koha system.  Here […]

Learning the Basics of Reports

Learn more about the basics of SQL, and some of the features of the Koha reports page. As a quick quick refresher, a basic sql query is composed of SELECT, FROM and WHERE clauses, and looks like this: SELECT borrowers.firstname, borrowers.surname, biblio.title, issues.date_due FROM borrowers JOIN issues using (borrowernumber) JOIN […]

Creating a Report to include all Branches

Here is a short video with a tip on creating a report in Koha to include all the branches of your library. Steps: Create a new authorized category for BRANCH. You can create any named category here, just as long as you know what it is for.  Authorized values are […]

Relationships between tables in Koha

In an ongoing effort to help our partners write reports in Koha, I’d like to highlight the relationships between database tables in Koha. A review of the basics of SQL Just for review, let’s look at some elementary SQL. Let’s say that we have two tables, person and person_dates. The […]

Tools, Reports, and Administration in Koha 3.22

This recorded webinar will cover new features and enhancements in the 3.22 Koha upgrade for tools, reports, administration and system preferences. Koha 3.22 can take advantage of Plack to run faster than ever, here is link to read more. Some of the highlights from this session include custom sound notifications […]

Evidence based collection management in Koha

This week’s tutorial is brought to us from Spencer Smith at the Little Elm Public Library. From Spencer: This video will detail how I use evidence based collection management in Koha. In this video I am calculating turnover by shelving location. Eventually this data will all tie in to ordering […]

Using variables in Koha Reports 3

Today’s guest post comes from Christopher Brannon at Cooperative Information Network (CIN). Christopher asked us if there was a way to not have enter the date 2 times in a report like this one: SELECT ai.location AS ‘Shelf Location’, COUNT(ai.dateaccessioned) AS ‘Count’ FROM (SELECT dateaccessioned, homebranch, location, timestamp FROM items […]