Koha-Library-Software/C4/Create-SQL-Report/English

Title of the Script: Create SQL report.

Author: Maya Hans and Vaibhavi Satardekar

Keywords: koha, koha 24.05, koha library system, reports module, guided reports wizard, create report, tabular report, report criteria, cache expiry, sql reports, saved reports, library automation, video tutorial.

Prerequisite: Create Guided Reports

Visual Cue	Narration
Slide Number 1 Title Slide	Welcome to this Spoken Tutorial on Create SQL Report in Koha.
Slide Number 2 Learning Objectives Create SQL report	In this tutorial, we will learn how to: Create SQL report in Koha.
Slide Number 3 System Requirement Ubuntu Linux OS v22.04 Koha v24.05 Firefox v131.0.3 A working internet connection	To record this tutorial, I am using the following setup.
Slide Number 4 Prerequisites You should have knowledge of Library Science	To follow this tutorial you should have knowledge of Library Science.
Show Koha interface Username - Bella Password - Library@1 Library: Spoken Tutorial Library Click on Login	To create a SQL report in Koha I have logged in as a Superlibrarian.
Slide Number 5 What is SQL? SQL is a Structured Query Language used to communicate with databases It allows to retrieve, add, update, or delete data from a database In Koha, SQL is used in the Reports module to create custom reports	SQL is a Structured Query Language used to communicate with databases. It allows to retrieve, add, update, or delete data from a database. In Koha, SQL is used in the Reports module to create custom reports.
Click on Reports module	On the Koha staff interface click on the Reports module.
Point to Reports page Point to Guided reports>>Click on Create from SQL	Reports page opens. Here under the Guided reports click on Create from SQL.
Point to Create from SQL Type Purchase suggestions in the Report Name field SQL Code SELECT suggestions.title AS Title, suggestions.author AS Author, suggestions. copyrightdate AS Year, suggestions.isbn AS ISBN, suggestions.publishercode AS Publisher, suggestions.place AS 'Publication Place', suggestions.itemtype AS 'Type of Book', suggestions.note AS Notes, borrowers.surname AS 'Recommended By', suggestions.suggesteddate AS 'Suggestion Date', suggestions.STATUS FROM suggestions LEFT JOIN borrowers ON (suggestions.suggestedby=borrowers.borrowernumber) Click on the Save report Point to Your report “Purchase Suggestions” has been saved.	Create from SQL page opens. In the Create report from SQL section, in the Report Name field type Purchase suggestions. Leave the other fields as such. Now pause the video and type the code in the SQL section as shown here. Scroll down, and click on the Save report button at the bottom of the page. The text highlighted in the blue box says Your report Purchase Suggestions has been saved.
Point to Edit SQL report Click on Run report Point to Purchase Suggestions	On the Edit SQL report page, at the top click on the Run report button. The Purchase Suggestions page opens with the total number of results.
Narration only	With this we have successfully created a SQL report.
Narration only	This brings us to the end of this tutorial.
Slide Number 6 Summary In this tutorial we learned to: Create SQL report	Let’s quickly recap.
Slide Number 7 Assignment Refer to the link:Reports Circulation https://wiki.koha-community.org/wiki/SQL_Reports_Circulation Select any SQL code of your choice Copy paste the SQL code into the Create SQL Report section Save and run the report	As an assignment, Refer to the link and do the following.
Slide Number 8 Thank you	Thank you for joining.

Contributors and Content Editors

VaibhaviS