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