GitHub - jmgold/SQL-Queries: Collection of SQL queries for use with Sierra ILS. Created and maintained by Jeremy Goldstein for test purposes only. Use at your own risk. Not supported by the Minuteman Library Network.

Branches Tags

Name		Name	Last commit message	Last commit date
Latest commit History 961 Commits
Booklists		Booklists
Custom reports site		Custom reports site
Library requests		Library requests
Misc Queries		Misc Queries
Testing		Testing
.gitattributes		.gitattributes
.gitignore		.gitignore
JSON import ISBNs into Create Lists.xlsx		JSON import ISBNs into Create Lists.xlsx
Patrons with high fines detail.sql		Patrons with high fines detail.sql
README		README
README.md		README.md
average age by last_checkout.sql		average age by last_checkout.sql
average age by scat.sql		average age by scat.sql
avg checkouts per library by amt owed ranges.sql		avg checkouts per library by amt owed ranges.sql
blocked patron stats by itype.sql		blocked patron stats by itype.sql
call number lookup.sql		call number lookup.sql
call number range - collection development.sql		call number range - collection development.sql
call number range experiment supplemental.sql		call number range experiment supplemental.sql
call number range experiment.sql		call number range experiment.sql
circ activity report.sql		circ activity report.sql
item reallocation experiment.sql		item reallocation experiment.sql
items with multiple barcode fields.sql		items with multiple barcode fields.sql
itype mattype mismatches.sql		itype mattype mismatches.sql
library transit counts.sql		library transit counts.sql
loan rule snapshot by checkout.sql		loan rule snapshot by checkout.sql
loan rule snapshot by fine with non-local checkouts.sql		loan rule snapshot by fine with non-local checkouts.sql
loan rule snapshot by fine.sql		loan rule snapshot by fine.sql
loan rule snapshot stats.sql		loan rule snapshot stats.sql
local holds paging all locations.sql		local holds paging all locations.sql
locally fulfillable holds paging.sql		locally fulfillable holds paging.sql
new books list_csv.py		new books list_csv.py
new books list_html.py		new books list_html.py
outstanding holds report.sql		outstanding holds report.sql
overdrive booklist converter.sql		overdrive booklist converter.sql
overdue books and patron counts by amt owed.sql		overdue books and patron counts by amt owed.sql
overdues and bills by library by checkouts.sql		overdues and bills by library by checkouts.sql
overdues and bills by library.sql		overdues and bills by library.sql
patron activity by age.sql		patron activity by age.sql
patron data for geocoder.sql		patron data for geocoder.sql
patrons created by hour.sql		patrons created by hour.sql
popular titles by call # range.sql		popular titles by call # range.sql
ptype location by checkout loanrule.sql		ptype location by checkout loanrule.sql
python_script_template.py		python_script_template.py
relative patron checkouts.sql		relative patron checkouts.sql
unbalanced holds (draft).sql		unbalanced holds (draft).sql

Repository files navigation

Collection of SQL queries for use with Sierra ILS. Created and maintained by Jeremy Goldstein for test purposes only. Use at your own risk. Not supported by the Minuteman Library Network.

View the Wiki pages for useful code snippets and a more oganized view of available queries.

jmgold/SQL-Queries

Folders and files

Latest commit

History

Repository files navigation

About

Topics

Resources

Stars

Watchers

Forks

Languages