SQL Report Request Form

       

         

How to submit an SQL report request

The following are the steps of requesting a new SQL report to be created.

1. Log a ticket on the support portal to start the process.

2. Take a note of the ticket number.

3. Click the link below to be taken to an online form where you can provide the details of the report to be created.

Request an SQL report. 

4. Submit the form 

The report will be created based on the description supplied in the form.

Important information about SQL reports

All SQL report requests are P4 tickets.

All reports will be placed on the library’s staging server (where available) for testing and confirmation by the library. 

Requested information for creating an SQL report

In the event that there is any problem with the linked form, the following fields can be added directly to the ticket requesting an SQL report.

Ticket Number: 

Report Name: 

Purpose of Report: 

Layout of Data in Report: 

Input criteria required: 

Sort order of report:

Other Notes:

Example of an SQL report request

Ticket Number:   2018-0000

Report Name: List of Titles added in a date range in a shelving location

Purpose of Report: To list all titles added to a particular shelving location code in a date range 

Layout of Data in Report:

Bib Number	Title	Author	Call Number	Barcode	Date Added

Input criteria required: 

1. First Date of Range

2. Last Date of Range

3. Shelving Location

Sort order of report:

1. By Date added

2. By Call Number

3. By Title 

Other Notes:

Show date added as YYYY-MM-DD - ie remove HH:MM:SS - 

Version History
Version	Date	Detail	Author
1.0	12/04/2018	Document Created	Charles Quain
2.0	26/05/2020	Transferred to Zoho	Charles Quain
2.1	22/03/21	Adding details of attachment	Holly Cooper
2.2	04/02/26	Updating form with further instructions and new link to online form instead of downloadable attachment	Holly Cooper
Retention Policy
Permanent		X

 

• Related Articles

• How and why to access the Koha database schema

  SQL reports in Koha can be intimidating. One of the key resources to learn how to more effectively create, edit and read the results of SQL reports within Koha is the database schema site. This site provides a map of the database which includes the ...

• 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 ...

• 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 ...

• 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 ...

• How to view the content of an SQL report

  This document will outline how to view the content of an SQL report on the Koha system. This may be a precursor to editing the report or just a way to start studying the format of reports How to find reports on your system Go to the Reports module on ...