Skip to content

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

17 stars 3 forks
Star
Watch
master
2 branches 0 tags
Go to file
Code
Clone

Use Git or checkout with SVN using the web URL.

Latest commit

 

Git stats

Files

Permalink
Failed to load latest commit information.
Type
Name
Latest commit message
Commit time
Custom reports site
 
 
Library requests
 
 
Seasonal booklists
 
 
Testing
 
 
.gitattributes
 
 
.gitignore
 
 
2010's highest use.sql
 
 
Average time to pay fine.sql
 
 
Bad e-mail fields.sql
 
 
Bad item barcodes.sql
 
 
Bad price fields.sql
 
 
Comcat record details.sql
 
 
Expired patrons.sql
 
 
Expiring patrons.sql
 
 
False holdshelf status.sql
 
 
Fines_overview_residents.sql
 
 
Holdings Profile.sql
 
 
ISBN to rec numbers.sql
 
 
Item status count.sql
 
 
JSON import ISBNs into Create Lists.xlsx
 
 
On shelf rate.sql
 
 
Patrons with high fines detail.sql
 
 
Payments against a fund.sql
 
 
Payments on standing orders.sql
 
 
README
 
 
README.md
 
 
WILIUG_Sierra_Direct_SQL_Access_101_PPT_061214.pdf
 
 
age of collection.sql
 
 
amount spent per scat.sql
 
 
annual items added summary.sql
 
 
aris holdings count by itype.sql
 
 
aris holdings count version 2.sql
 
 
aris holdings count.sql
 
 
authors in multiple genres.sql
 
 
auto renewal stats.sql
 
 
average age by last_checkout.sql
 
 
average age by scat.sql
 
 
average item price.sql
 
 
average price per item by year.sql
 
 
avg checkouts per library by amt owed ranges.sql
 
 
avg patron.sql
 
 
bibs in a subject with x copies.sql
 
 
bibs with duplicate 245 fields.sql
 
 
bibs with items in one itype but not others.sql
 
 
bibs with multiple copies owned by 1 library.sql
 
 
bibs with paid orders and not items.sql
 
 
blocked patron by town.sql
 
 
blocked patron stats by age.sql
 
 
blocked patron stats by itype.sql
 
 
blocked patron stats by loanrule.sql
 
 
blocked patron stats.sql
 
 
booklist importer.sql
 
 
books about books.sql
 
 
broken comcat holds.sql
 
 
call number browse.sql
 
 
call number lookup.sql
 
 
call number range - collection development.sql
 
 
call number range experiment supplemental.sql
 
 
call number range experiment.sql
 
 
checkin box export.sql
 
 
checkouts by MA town.sql
 
 
checkouts by library format and fines.sql
 
 
circ_trans snapshot.sql
 
 
circulation dashboard.sql
 
 
clear hold shelf audit.sql
 
 
collection dev Scat by time.sql
 
 
collection dev by language.sql
 
 
collection dev item report with relative totals ytd.sql
 
 
collection dev item report with relative totals.sql
 
 
collection dev item report.sql
 
 
collection dev order report.sql
 
 
collection dev report with mode price calculation.sql
 
 
collection dev report ytd for BRK.sql
 
 
collection dev report.sql
 
 
collection value by location and itype.sql
 
 
comcat records.sql
 
 
coming soon books.sql
 
 
coming soon video.sql
 
 
count scat usage.sql
 
 
course reserve items off reserve.sql
 
 
course reserves full list.sql
 
 
current sql activity.sql
 
 
daily holds counts.sql
 
 
days late by loan rule.sql
 
 
deleted records.sql
 
 
doa by collection.sql
 
 
doa titles.sql
 
 
duplicate Axis 360 records records.sql
 
 
duplicate patron records by name and bdate.sql
 
 
duplicate patron records.sql
 
 
duplicate records by 001.sql
 
 
duplicate records by index i.sql
 
 
edifact usage.sql
 
 
example - count order status use.sql
 
 
example - count orders by month using case.sql
 
 
example - like title contains blank.sql
 
 
expenditure audit.sql
 
 
expiring holds.sql
 
 
fine ranges.sql
 
 
fines by location.sql
 
 
fines paid item data.sql
 
 
frequently overdue titles.sql
 
 
fund audit.sql
 
 
fund encumbrance audit.sql
 
 
fund summary.sql
 
 
high demand holds.sql
 
 
high utilization - not owned.sql
 
 
high utilization - owned.sql
 
 
hold ready for pickup and patron blocked.sql
 
 
holdings by status.sql
 
 
holdings crosstab by location.sql
 
 
holdings loc by itype.sql
 
 
holds usage snapshot.sql
 
 
in transit hold errors.sql
 
 
in transit snapshot.sql
 
 
index listing.sql
 
 
invalid duplicate holds from Encore.sql
 
 
invalid patron records.sql
 
 
invoice line items.sql
 
 
invoice summary.sql
 
 
item count by location and language.sql
 
 
item holds on bibs with available copies.sql
 
 
item list, days late by itype.sql
 
 
item reallocation experiment.sql
 
 
items added loc by itype.sql
 
 
items attached to multiple bibs.sql
 
 
items on holdshelf by patron.sql
 
 
items with multiple barcode fields.sql
 
 
items without parents.sql
 
 
itype mattype mismatches.sql
 
 
just returned.sql
 
 
language by location.sql
 
 
last issue received.sql
 
 
library of things list.sql
 
 
library transit counts.sql
 
 
loan rule snapshot by checkout.sql
 
 
loan rule snapshot by fine with non-local checkouts.sql
 
 
loan rule snapshot by fine.sql
 
 
loan rule snapshot stats.sql
 
 
loan rule snapshot.sql
 
 
local holds paging all locations.sql
 
 
locally fulfillable holds paging.sql
 
 
locked order records.sql
 
 
lost in transit.sql
 
 
magazine count checkin.sql
 
 
magazine count item.sql
 
 
magazine count.sql
 
 
missing holds.sql
 
 
missing titles.sql
 
 
new audiobook list.sql
 
 
new books list.sql
 
 
new books list_csv.py
 
 
new books list_html.py
 
 
new overdrive ebook list.sql
 
 
new patron count by pcode 4.sql
 
 
new patron count.sql
 
 
new title list.sql
 
 
new video list.sql
 
 
old order records.sql
 
 
on the fly records.sql
 
 
online patron conversion errors.sql
 
 
order count.sql
 
 
order records without grids.sql
 
 
orders on hold.sql
 
 
outstanding holds report.sql
 
 
paperbacks.sql
 
 
patron activity by age.sql
 
 
patron addresses.sql
 
 
patron amt owed errors.sql
 
 
patron count by barcode prefix.sql
 
 
patron count by ptype.sql
 
 
patron count by zip code.sql
 
 
patron counts at a location.sql
 
 
patrons by age.sql
 
 
patrons created by hour.sql
 
 
patrons with duplicate charges.sql
 
 
patrons with multiple barcodes.sql
 
 
patrons with x holds to pick up.sql
 
 
periodical circulation by title.sql
 
 
periodical circulation counts by title arl.sql
 
 
periodical circulation counts by title.sql
 
 
pmccollection dev call#.sql
 
 
popular authors.sql
 
 
popular foreign language titles.sql
 
 
popular titles by call # range.sql
 
 
purchase alert with orders.sql
 
 
purchase alert with orders_concord_version.sql
 
 
purchase alert without local holds.sql
 
 
python_script_template.py
 
 
query review file.sql
 
 
random available titles.sql
 
 
random sampling of records.sql
 
 
read alikes.sql
 
 
read the book first.sql
 
 
rec2check.sql
 
 
recent circ transaction by pnumber.sql
 
 
record count.sql
 
 
record metadata table errors.sql
 
 
record ranges.sql
 
 
records with duplicate non-repeating fields.sql
 
 
relative patron checkouts.sql
 
 
renewals on network transfers.sql
 
 
returning patron checkouts.sql
 
 
review file book list.sql
 
 
review file item count and url.sql
 
 
review file location count.sql
 
 
search api prototype.sql
 
 
sent order errors.sql
 
 
shelf list.sql
 
 
sierra feature usage.sql
 
 
staff picks f&sf.sql
 
 
staff picks teens.sql
 
 
staff picks.sql
 
 
staff picks_end of year.sql
 
 
standing order paid fields (alternate).sql
 
 
standing order paid fields (duplicate entries).sql
 
 
steam list.sql
 
 
table sizes.sql
 
 
temps with multiple items (broken).sql
 
 
time on holdshelf.sql
 
 
too many renewals.sql
 
 
top audiobook requests list.sql
 
 
top cd requests list.sql
 
 
top circ new title by library.sql
 
 
top request at a library v2.sql
 
 
top request at a library.sql
 
 
top request by language.sql
 
 
top requests list.sql
 
 
top titles x years ago.sql
 
 
top video requests list.sql
 
 
top ya requests list.sql
 
 
transit snapshot.sql
 
 
trending titles list.sql
 
 
unavailable holds.sql
 
 
unbalanced holds (draft).sql
 
 
underutilized items.sql
 
 
unique patron checkouts.sql
 
 
unique patron counts.sql
 
 
unused itypes.sql
 
 
unused ptypes.sql
 
 
user permissions.sql
 
 
user settings.sql
 
 
user with sierraweb permission.sql
 
 
vendor stats.sql
 
 
view outstanding holds.sql
 
 
volume field problems.sql
 
 
weekly brief find rate.sql
 
 
weekly value calculator.sql
 
 
welcome e-mail.sql
 
 
where do i start_mysteries.sql
 
 
where do i start_superheroes.sql
 
 
world language print ownership.sql
 
 
x-order finder.sql
 
 

README.md

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.

About

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.

Topics

sql-queries sierra-ils

Resources

Readme

Releases

No releases published

Packages

No packages published

Languages

You can’t perform that action at this time.