SQL Report Request Form

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 portal to start the process, then complete this form and attach it to the ticket. The report will be created based on the description supplied in this form.


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. 



Ticket Number: 


Report Name: 


Purpose of Report: 




Layout of Data in Report: 











Input criteria required: 




Sort order of report:



Other Notes:




Example:



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




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

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

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

    • Changes to Frameworks

      Changes to Frameworks Request Form                   To enable the support desk help you change or create a new framework, please use the following form when requesting changes to frameworks. Log a ticket on Vtiger to start the process, attaching the ...