How to Find and Run a SQL Report

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. This information is drawn from tables storing all information about the system which can be found here: http://schema.koha-community.org/

How to find reports on your system

Go to Reports > Guided reports click Use saved and you will be brought to a new page with a table of all the reports currently on your system.






How to search reports already on your system



At the top of this table there is a small grey bar with Search and a searchbox at the right hand side. Search for the title or number of the report, or for a keyword. This will narrow the list of reports to ones related to the search. 


Once you have found the report you want to run, go to the right hand side of the row the report is in and hit run.


Example:


If you are searching for a report on borrowers, but aren’t sure of the title, you can use the search bar to explore keywords such a report might have. 




In this example, by typing borrowers into the search bar, the results in the table are narrowed down to reports containing the keyword. 


If you search for a specific report title or number, the results will be narrowed to one result, like so: 



Running a report

Once you have identified the report you want to run, go to the right hand side of the row the report appears on and hit the Run button. 



Assuming the report is structured correctly and is not overly large, hitting the Run button will bring you to either the results page with a table of information or a page requiring you to set parameters for the information being drawn back by the report. 


These parameters may be, but are not limited to date range, branch and item type and may look something like this: 


To run the report under these circumstances an option from the dropdown must be selected and the Run the report button must be clicked. 


Version History 

Version

Date

Detail

Author

1.0

11/01/2019

Document Created

Holly Cooper

2.0

26/05/2020

Transferred to Zoho

Daphne Hoolahan

2.1
21/01/2021
Adding TOC and clarifying language
Holly Cooper
2.2
25/01/2021
Changing version history box
Holly Cooper
2.3
16/02/2021
Adding new screenshot
Holly Cooper

Retention Policy

Permanent

X


    • 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 ...
    • How to Find and Run an SQL Report

      What are reports for? Reports are used to find and present data about the information on the system in a structured manner. This information is drawn from tables storing all information about the system which can be found here: ...
    • SQL Report Request Form

                        To allow the support desk help you create SQL reports, please use please use the following form when requesting a SQL report. A downloadable form is available as an attachment at the bottom of this page. Log a ticket on the support ...
    • How to Report on Star Ratings

      If star rating are enabled on the OPAC, staff members may wish to view details about how the feature is being used. This document will provide a basic SQL report which can be used to identify star ratings on the site. Step 1 - Navigate to the report ...
    • Running the overdue report with filters

      This document will outline how to enable filters for the Overdues report under the Circulation module. By default, the Overdues report will run automatically when the Overdues button is clicked. This can be an issue on sites with a lot of overdues, ...