sierra-ils

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.

Sierra API examples scripts

This automated report captures performance metrics for the vendor Midwest, specifically tracking fulfillment turnaround times from order placement to delivery for the previous quarter.

This automated report highlights adult print and media titles with high demand (a minimum 4:1 hold-to-item ratio) and those with holds but zero holdable copies. The ratio calculation only includes actively holdable items.

This automated report highlights youth print titles with high demand (a minimum 2:1 hold-to-item ratio) and those with holds but zero holdable copies. The ratio calculation only includes actively holdable items.

This automated report flags all titles in the collection with eight or more holds.

Scheduled for the close of business each quarter, this automated report delivers key statistics for California and Santa Clara County park passes.

This automated report captures performance metrics for the vendor Ingram, specifically tracking fulfillment turnaround times from order placement to delivery for the previous quarter.

This automated cleanup report identifies items that have stalled in the withdrawn workflow. Specifically, it captures any item that has held a "withdrawn" status for more than 3 weeks, but whose icode2 has not yet been updated to 'w'.

This automated report lists collection items loaned to INN-Reach (Link+) libraries that are 30+ days overdue.

This automated report identifies items billed between 30 and 60 days ago.

This weekly automated report captures items that have been in-transit for over a week.

This automated clean-up report identifies Link+ (INN-Reach) items returned by borrowing libraries over 30 days from the time of the report but are still in transit.