Madhurig at 06:10, 30 January 2026

2026-01-30T06:10:29Z

VaibhaviS: Created page with "'''Title of the Script: Create SQL report'''. '''Author: '''Maya Hans and Vaibhavi Satardekar '''Keywords:''' koha, koha 24.05, koha library system, reports module, guided r..."

2025-12-12T06:53:49Z

Created page with "'''Title of the Script: Create SQL report'''. '''Author: '''Maya Hans and Vaibhavi Satardekar '''Keywords:''' koha, koha 24.05, koha library system, reports module, guided r..."

New page

'''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

{|border=1
|-
|| '''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:[https://wiki.koha-community.org/wiki/SQL Reports Circulation ][https://wiki.koha-community.org/wiki/SQL_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.
|-
|}

@@ Line 52: / Line 52: @@
 Click on '''Login'''
-|| To create a '''SQL''' report in '''Koha '''I have logged in as a '''Superlibrarian'''.
+|| To create a '''SQL''' report in '''Koha ''', I have logged in as a '''Superlibrarian'''.
 |-
@@ Line 64: / Line 64: @@
 || '''SQL '''is a '''Structured Query Language''' used to '''communicate '''with''' databases'''.
-* It allows to retrieve, add, update, or delete data from a database.
+* It allows to retrieve, add, update, or delete data from the database.
 * In '''Koha''', '''SQL''' is used in the''' Reports module''' to create '''custom reports'''.
@@ Line 105: / Line 105: @@
 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'''.
+The text highlighted in blue box says '''Your report Purchase Suggestions has been saved'''.
 |-
 || Point to '''Edit SQL report '''

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

Madhurig at 06:10, 30 January 2026

VaibhaviS: Created page with "'''Title of the Script: Create SQL report'''. '''Author: '''Maya Hans and Vaibhavi Satardekar '''Keywords:''' koha, koha 24.05, koha library system, reports module, guided r..."