SQL Report Request Form

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.
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.122/03/21Adding details of attachmentHolly Cooper
2.204/02/26Updating form with further instructions and new link to online form instead of downloadable attachmentHolly 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 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 ...

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

    • Scooter - Start of Term Instructions

      Scooter 2 Start of Term Document This document is intended to be a set of guidelines for starting a new school year with Scooter. Included in it are answers to some commonly asked questions and links to resources to help you get started, or return to ...

    • Running the overdue report with filters

      This document will outline how to use filters for the Overdues report under the Circulation module. This document assumes that the FilterBeforeOverdueReport system preference has been set to Require. This document is intended to outline how these ...