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.
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:
Input criteria required:
First Date of Range
Last Date of Range
Shelving Location
Sort order of report:
By Date added
By Call Number
By Title
Other Notes:
Show date added as YYYY-MM-DD - ie remove HH:MM:SS -