reports


Using the Patron Emailer Plugin in Koha

In this Koha tutorial Kelly and Jessie will walk you through using the Patron Emailer Plugin. Below, you will find a video as well as the steps to install the plugin and configure and run the tool in your system. Steps to Uploading a Plugin to your Koha System In […]


Accidentally Delete a Report? These steps will show you how to recover it

In this Koha tutorial we will walk you through recovering a deleted report.¬†Reports in Koha are a way to gather data. Reports are used to generate statistics, member lists, shelving lists, or any list of data in your database. First, you will want to make sure your system preference to […]


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 […]