The two most common SQL statements within Koha application reports
This document will outline the two most common statements which appear in SQL reports run in the Koha application. SQL reports within the Koha application can only be run the return information that exists in the database, however, other SQL tools may allow the editing and updating of the underlying database. Editing and updating the underlying database is not possible from within the Koha reports tool.
The two statements required to structure an SQL report in Koha
SELECT
FROM
These two statements that will appear in almost every SQL report created on Koha. After the SELECT statement, there will be a list of the fields the report should display. After the FROM statement, there will be a list of the tables the information should be taken from.
SELECT
One of two mandatory statements that enable a report to work. This function defines the columns you want to draw information from. It should appear at the start of every report.
FROM
One of two mandatory functions to enable the report to work. FROM is the function that determines what the primary table the information requested with the SELECT function will be drawn from.
Example of how these statements are used in a report
SELECT borrowers.cardnumber, borrowers.firstname, borrowers.surname
FROM borrowers
For more details on reports, please contact Interleaf Technology directly. To request a report, please check our Help Centre.
| Version | Date | Detail | Author |
| 1.0 | 28/04/26 | Document created | Holly Cooper |
| 1.2 | 29/04/26 | Details added | Holly Cooper |
Related Articles
Overview of some SQL Report Functions
Overview of SQL Report Functions This FAQ is an example of a simple report describing the “anatomy” of the SQL code used. Details about the different functions are outlined in the table below the report. Some functions are mandatory to use in order ...First Report Challenge: A client wants to put together a report to show the cardnumber, first name and second name of all patrons on the system.
These notes are intended to be used to help answer the associated Report Challenge that was released last week. Take a look at the question below and think about how you would approach answering it: A client wants to put together a report to show the ...Second Report Challenge: A client wants to put together a report to show the cardnumber, first name and second name, concatenated.
These notes are intended to be used to help answer associated "Report Challenge" that was released earlier. Take a look at the question below and think about how you would approach answering it: A client wants to put together a report to show the ...How to Find and Run a SQL Report
What are reports for? Reports are used to find and present data about the information on the system in a structured manner. Reports use SQL to ask questions of the Koha database. How to find reports on your system Go to the Reports module on the Koha ...What is a clause in a SQL report?
In SQL a clause is a tool which allows specific parameters to be set on what results should be brought back in a SQL report. Examples of some of the clauses that can be used in SQL: CLAUSE WHAT DOES IT DO? WHERE A clause which filters results to ...