Repository navigation

Polaris-TSQL

Public

About

SQL for Polaris

Custom properties

3 stars

1 watching

Report repository

Name		Name	Last commit message	Last commit date
3m items stuck as held hold.sql		3m items stuck as held hold.sql
Audiobooks_by_duration_FindTool.sql		Audiobooks_by_duration_FindTool.sql
Average Age of Collection.sql		Average Age of Collection.sql
Batch changing 020 $a and Missing Cover Art.sql		Batch changing 020 $a and Missing Cover Art.sql
Bib data presence in 856.sql		Bib data presence in 856.sql
Bib missing tag in a certain collection.sql		Bib missing tag in a certain collection.sql
Bib record find OCLC in 035.sql		Bib record find OCLC in 035.sql
Bibs with 1 attached record that is withdrawn.sql		Bibs with 1 attached record that is withdrawn.sql
Bibs with 1 attached record thats withdrawn.sql		Bibs with 1 attached record thats withdrawn.sql
Checkouts in the last month based upon patron city's code.sql		Checkouts in the last month based upon patron city's code.sql
Checkouts_by_patron_branch_no_renewals.sql		Checkouts_by_patron_branch_no_renewals.sql
Circ by shelf location.sql		Circ by shelf location.sql
Circulation In house use.sql		Circulation In house use.sql
Circulation Statistics.sql		Circulation Statistics.sql
Circulation by collection for system.sql		Circulation by collection for system.sql
Circulation compaing day this year to one last year.sql		Circulation compaing day this year to one last year.sql
Circulation count by patron statistical class.sql		Circulation count by patron statistical class.sql
Circulation of Collection by Age of Item.sql		Circulation of Collection by Age of Item.sql
Circulation statistical for a given date range by patron statistical class.sql		Circulation statistical for a given date range by patron statistical class.sql
ClosedBranch_List.sql		ClosedBranch_List.sql
ClosedBranch_Maintenance.sql		ClosedBranch_Maintenance.sql
ClosedBranch_OriginalHours.sql		ClosedBranch_OriginalHours.sql
ClosedBranch_Restore.sql		ClosedBranch_Restore.sql
Closed_Branch_List.sql		Closed_Branch_List.sql
Closed_Branch_Maintenance.sql		Closed_Branch_Maintenance.sql
Collection development report.sql		Collection development report.sql
CountOfItemsCreatedByUserCollection.sql		CountOfItemsCreatedByUserCollection.sql
DatesClosed.sql		DatesClosed.sql
Deleted Patron Records.sql		Deleted Patron Records.sql
Deleted bib records.sql		Deleted bib records.sql
Deleted item records.sql		Deleted item records.sql
ExaminePatronItemCrossBorrowing.sql		ExaminePatronItemCrossBorrowing.sql
Export bibliographic records.sql		Export bibliographic records.sql
Exporting a record set.sql		Exporting a record set.sql
Exporting bib record sets.sql		Exporting bib record sets.sql
Filtering_Bibs_by008_23_Form.sql		Filtering_Bibs_by008_23_Form.sql
Find Bibs by 007 Code.sql		Find Bibs by 007 Code.sql
Find Dormant Polaris Users.sql		Find Dormant Polaris Users.sql
Find specific tag.sql		Find specific tag.sql
FindTool No longer used record sets.sql		FindTool No longer used record sets.sql
FindTool PatronCode Staff.sql		FindTool PatronCode Staff.sql
FindTool_retrieve_patrons_with_incomplete_phone.sql		FindTool_retrieve_patrons_with_incomplete_phone.sql
High_priced_item_records.sql		High_priced_item_records.sql
Hold counts patron branch vs pickup branch.sql		Hold counts patron branch vs pickup branch.sql
HoldDenials_Suspension.sql		HoldDenials_Suspension.sql
Hold_Inactivations.sql		Hold_Inactivations.sql
Holds for items in processing.sql		Holds for items in processing.sql
Holds in processing.sql		Holds in processing.sql
Holds more than allowed created from PAC.sql		Holds more than allowed created from PAC.sql
Holds_Data_with_Final_Statuses.sql		Holds_Data_with_Final_Statuses.sql
Holds_Inactivations.sql		Holds_Inactivations.sql
Hourly circulation by user.sql		Hourly circulation by user.sql
IHUwMT_LastMonth.sql		IHUwMT_LastMonth.sql
ILL Request Creator_WorkingOn.sql		ILL Request Creator_WorkingOn.sql
In transit and transferred counts.sql		In transit and transferred counts.sql
Inhouse Circ Stats by Month.sql		Inhouse Circ Stats by Month.sql
Invoice Line Items Transaction Counts.sql		Invoice Line Items Transaction Counts.sql
Item Records in Smaller Collections.sql		Item Records in Smaller Collections.sql
Items In transit and transferred counts.sql		Items In transit and transferred counts.sql
Items Replaced on Existing Bib Records.sql		Items Replaced on Existing Bib Records.sql
Items out by collection.sql		Items out by collection.sql
Items with no price.sql		Items with no price.sql
LICENSE		LICENSE
LargePrintCircFromOtherLib.sql		LargePrintCircFromOtherLib.sql
Loanable_outside_system_First_availability.sql		Loanable_outside_system_First_availability.sql
Loanable_outside_system_yes_no.sql		Loanable_outside_system_yes_no.sql
Locate English bibs with the wrong non-filing characters for common initial articles.sql		Locate English bibs with the wrong non-filing characters for common initial articles.sql
Multiple item copies at a specific branch.sql		Multiple item copies at a specific branch.sql
Multiple_items_per_bib.sql		Multiple_items_per_bib.sql
Number of items checked out in the last month based upon patron city's code.sql		Number of items checked out in the last month based upon patron city's code.sql
Number of unique patrons checking out.sql		Number of unique patrons checking out.sql
On_Order_with_holds.sql		On_Order_with_holds.sql
Overdue holds.sql		Overdue holds.sql
OverdueMoreThan7.sql		OverdueMoreThan7.sql
PAC search term history.sql		PAC search term history.sql
Patron Reading History_better_.sql		Patron Reading History_better_.sql
Patron Records Patrons with more than 20 items checked out.sql		Patron Records Patrons with more than 20 items checked out.sql
Patron and fine purges.sql		Patron and fine purges.sql
Patron checkouts by City.sql		Patron checkouts by City.sql
Patron reading history.sql		Patron reading history.sql
Patron time_date PAC login.sql		Patron time_date PAC login.sql
PatronBounceBackWithAmbiguousPhone.sql		PatronBounceBackWithAmbiguousPhone.sql
PatronCode Staff.sql		PatronCode Staff.sql
Patron_Browse_vs_Pickup.sql		Patron_Browse_vs_Pickup.sql
Patron_ID_cleanup.sql		Patron_ID_cleanup.sql
Patron_Mobile_Carriers.sql		Patron_Mobile_Carriers.sql
Patron_Text_Carrier.sql		Patron_Text_Carrier.sql
Patrons Use at Circ Desk.sql		Patrons Use at Circ Desk.sql
Patrons checking out particular items during date range.sql		Patrons checking out particular items during date range.sql
Patrons who have email as notification method but have no email address on file .sql		Patrons who have email as notification method but have no email address on file .sql
Patrons who have email as notification method but have no email address on file.sql		Patrons who have email as notification method but have no email address on file.sql
Patrons who have phone as notification method but have no phone number on file.sql		Patrons who have phone as notification method but have no phone number on file.sql
Patrons with more than one address.sql		Patrons with more than one address.sql
Patrons with more than x items checked out.sql		Patrons with more than x items checked out.sql
Patrons with multiple waived fines.sql		Patrons with multiple waived fines.sql
Previous month PAC searches.sql		Previous month PAC searches.sql
Pull Email List for Patrons Based on Circ Activity.sql		Pull Email List for Patrons Based on Circ Activity.sql
README.md		README.md
RPT_ClosedBranches.sql		RPT_ClosedBranches.sql
Report of circulation for a particular time frame.sql		Report of circulation for a particular time frame.sql

Repository files navigation

Polaris

SQL for Polaris

About

SQL for Polaris

Custom properties

3 stars

1 watching

Report repository

Releases

Packages

Contributors

Languages