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 […]
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 […]
This tutorial video will show you a few new enhancements including searching, saving and logs for Reports in Koha 3.22. To learn all about Koha 3.22 view the other videos in this series and make sure to review the manual and the release notes.
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 […]
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 […]