|
Who Modified a Patron Registration
|
|
1
|
128
|
November 3, 2025
|
|
SQL EXISTS Use Cases and Examples
|
|
0
|
76
|
October 23, 2025
|
|
Hold Modifications by Staff
|
|
0
|
54
|
October 22, 2025
|
|
You Saved Amounts - Minus Renewals
|
|
2
|
456
|
October 16, 2025
|
|
Deleted Items on Patron Accounts with Outstanding Balances
|
|
1
|
91
|
October 14, 2025
|
|
Using the Locations Served or portloca flat file in a query with iii_user
|
|
0
|
48
|
October 10, 2025
|
|
Held Items Transferred by Sending and Receiving Branch
|
|
0
|
62
|
October 9, 2025
|
|
Automatically sending CollectionHQ MARC files
|
|
8
|
438
|
October 7, 2025
|
|
Hoopla ID mismatches: Find where 037$a and ID in hoopla URLs don't match
|
|
0
|
39
|
October 6, 2025
|
|
Average Cost By Material Type
|
|
0
|
54
|
October 6, 2025
|
|
Find who placed recent holds for patron over a certain limit
|
|
0
|
52
|
September 30, 2025
|
|
Titles with the highest and lowest page count - rough draft
|
|
3
|
70
|
September 30, 2025
|
|
Create Lists Cleanup Accountability
|
|
1
|
78
|
September 29, 2025
|
|
Find which SSRS reports are associated with SQL Job GUIDs
|
|
0
|
167
|
September 26, 2025
|
|
Backing up the Custom SSRS Folder
|
|
0
|
41
|
September 25, 2025
|
|
5-Way Sierra User Permissions Comparison Query
|
|
0
|
42
|
September 24, 2025
|
|
Finding Bibs with ONLY Lost and Missing Items
|
|
0
|
77
|
September 22, 2025
|
|
Script to correct Items that are both checked out and in transit
|
|
7
|
101
|
September 10, 2025
|
|
Find Bib Records With Active Holds But No Items
|
|
1
|
402
|
August 20, 2025
|
|
Patrons With Outstanding Charges for Deleted Items
|
|
2
|
128
|
August 19, 2025
|
|
Hold-to-Item Ratio SQL Query
|
|
2
|
140
|
August 14, 2025
|
|
Find Active Holds on Lost, Claimed, and Missing Items
|
|
0
|
249
|
June 2, 2023
|
|
Circ Counts for All Items in a Record Set
|
|
0
|
112
|
July 24, 2025
|
|
Excluding graphic novels from PAC search results via record set
|
|
0
|
60
|
July 17, 2025
|
|
ILL Item History by PatronID
|
|
0
|
47
|
July 18, 2025
|
|
Show payment information for items not owned by your branch
|
|
0
|
53
|
July 14, 2025
|
|
ChiliCheck - a Python script that looks for missing cover images
|
|
4
|
149
|
July 10, 2025
|
|
Query SSRS Report Execution Log
|
|
3
|
633
|
June 30, 2025
|
|
Hold Counts - Patron Branch vs Pickup Branch
|
|
1
|
434
|
March 17, 2024
|
|
Deleted Items Billed and Overdue
|
|
5
|
115
|
June 27, 2025
|