Skip to content

LynnAUhlman/PolarisSQL

BranchesTags

Folders and files

NameName
Last commit message
Last commit date

Latest commit

 

History

41 Commits
ACQ_FUNDS List.txt
ACQ_FUNDS List.txt
 
 
BIB 007 and Mattype .txt
BIB 007 and Mattype .txt
 
 
BIB Created Date Range.txt
BIB Created Date Range.txt
 
 
BIB Creator ID Record ID.txt
BIB Creator ID Record ID.txt
 
 
BIB Creator ID_.txt
BIB Creator ID_.txt
 
 
BIB Distinct Creation Date.txt
BIB Distinct Creation Date.txt
 
 
BIB Ecoding level.txt
BIB Ecoding level.txt
 
 
BIB Encoding level.txt
BIB Encoding level.txt
 
 
BIB Genre Heading_SSMS.txt
BIB Genre Heading_SSMS.txt
 
 
BIB ISBN Duplicates.txt
BIB ISBN Duplicates.txt
 
 
BIB Import Profile File Search.txt
BIB Import Profile File Search.txt
 
 
BIB LDR equal to and unique.txt
BIB LDR equal to and unique.txt
 
 
BIB NO 006 and 007 .txt
BIB NO 006 and 007 .txt
 
 
BIB No Items Attached Provisional.txt
BIB No Items Attached Provisional.txt
 
 
BIB No Items Attached.txt
BIB No Items Attached.txt
 
 
BIB Not Equal To Multi ROUGH DRAFT.txt
BIB Not Equal To Multi ROUGH DRAFT.txt
 
 
BIB Record ID.txt
BIB Record ID.txt
 
 
BIB Record Status.txt
BIB Record Status.txt
 
 
BIB TOM Material Type Analysis_SSMS.txt
BIB TOM Material Type Analysis_SSMS.txt
 
 
BIB Tag and Subfield .txt
BIB Tag and Subfield .txt
 
 
BIB Tag equal to 852 and contains spec subfield and data.txt
BIB Tag equal to 852 and contains spec subfield and data.txt
 
 
BIB Tag equal to 852 and contains spec subfield.txt
BIB Tag equal to 852 and contains spec subfield.txt
 
 
BIB Tag equal to 852 contains branch code and import date.txt
BIB Tag equal to 852 contains branch code and import date.txt
 
 
BIB Tag equal to 852.txt
BIB Tag equal to 852.txt
 
 
BIB Tag equal to Data LIKE Data NOT Mattype NOT.txt
BIB Tag equal to Data LIKE Data NOT Mattype NOT.txt
 
 
BIB Tags Missing - Minimal Cataloging
BIB Tags Missing - Minimal Cataloging
 
 
BIB Top Titles.txt
BIB Top Titles.txt
 
 
BIB Unique BETWEEN Dates Ignores ILL.txt
BIB Unique BETWEEN Dates Ignores ILL.txt
 
 
BIB Unique Bibs by AssignedBranchID Without Certain Tags.txt
BIB Unique Bibs by AssignedBranchID Without Certain Tags.txt
 
 
BIB Unique Created Between AND Ignores ILL items.txt
BIB Unique Created Between AND Ignores ILL items.txt
 
 
BIBs ISBN Duplicates with RecordID.txt
BIBs ISBN Duplicates with RecordID.txt
 
 
BSLW BIB Search.txt
BSLW BIB Search.txt
 
 
Bib 007 and Material Type
Bib 007 and Material Type
 
 
Bib Holds for Created Denied Cancelled and Transferred
Bib Holds for Created Denied Cancelled and Transferred
 
 
CIRC STATS Patron Checkouts by Shelf Location.txt
CIRC STATS Patron Checkouts by Shelf Location.txt
 
 
CODES - Collections.txt
CODES - Collections.txt
 
 
CODES - Item Statuses.txt
CODES - Item Statuses.txt
 
 
CODES - ItemBlockDescriptions.txt
CODES - ItemBlockDescriptions.txt
 
 
CODES - ItemTemplates.txt
CODES - ItemTemplates.txt
 
 
CODES - LoanPeriodCodes.txt
CODES - LoanPeriodCodes.txt
 
 
CODES - PatronCodes.txt
CODES - PatronCodes.txt
 
 
CODES - PatronStatClassCodes.txt
CODES - PatronStatClassCodes.txt
 
 
CODES - ShelfLocations.txt
CODES - ShelfLocations.txt
 
 
CODES - StatisticalCode.txt
CODES - StatisticalCode.txt
 
 
CODES - Type of Materials.txt
CODES - Type of Materials.txt
 
 
CircItemRecords_excludecriteria.txt
CircItemRecords_excludecriteria.txt
 
 
CircItemRecords_not set to noncirc.txt
CircItemRecords_not set to noncirc.txt
 
 
HoldRoutingSeqencePrimary
HoldRoutingSeqencePrimary
 
 
Holds Activity at a Branch or Library_SSMS.txt
Holds Activity at a Branch or Library_SSMS.txt
 
 
ILL Holds_SSMS.txt
ILL Holds_SSMS.txt
 
 
ILL Transaction Report_SSMS.txt
ILL Transaction Report_SSMS.txt
 
 
ILLIncomingDRAFT_SSMS.txt
ILLIncomingDRAFT_SSMS.txt
 
 
ILLTransactionData
ILLTransactionData
 
 
INN-Reach Contribution.txt
INN-Reach Contribution.txt
 
 
INNREACH_CircStats_Outgoing.txt
INNREACH_CircStats_Outgoing.txt
 
 
INNReach MILS Item Out to MaineCat Patron.txt
INNReach MILS Item Out to MaineCat Patron.txt
 
 
INNReachPastHoldDate
INNReachPastHoldDate
 
 
ITEM Material Type and Holdable.txt
ITEM Material Type and Holdable.txt
 
 
ITEM Barcode List.txt
ITEM Barcode List.txt
 
 
ITEM Branch Loan Period Collection.txt
ITEM Branch Loan Period Collection.txt
 
 
ITEM Branch Shelf Location.txt
ITEM Branch Shelf Location.txt
 
 
ITEM Branch and fine code.txt
ITEM Branch and fine code.txt
 
 
ITEM Branch and loan period code.txt
ITEM Branch and loan period code.txt
 
 
ITEM Branch fine code not equal to.txt
ITEM Branch fine code not equal to.txt
 
 
ITEM Call No Final Status Branch.txt
ITEM Call No Final Status Branch.txt
 
 
ITEM Call No Review_SSMS.txt
ITEM Call No Review_SSMS.txt
 
 
ITEM Call No with RegEx Final Status Branch.txt
ITEM Call No with RegEx Final Status Branch.txt
 
 
ITEM Call No with RegEx Final Status OR statement Branch.txt
ITEM Call No with RegEx Final Status OR statement Branch.txt
 
 
ITEM Circulation by Item.txt
ITEM Circulation by Item.txt
 
 
ITEM Collection Price by Branch_SSMS.txt
ITEM Collection Price by Branch_SSMS.txt
 
 
ITEM Control No List.txt
ITEM Control No List.txt
 
 
ITEM Created and not ILL.txt
ITEM Created and not ILL.txt
 
 
ITEM Due Date and Branch_SSMS.txt
ITEM Due Date and Branch_SSMS.txt
 
 
ITEM EMBARGO.txt
ITEM EMBARGO.txt
 
 
ITEM EMBARGO.txt.bak
ITEM EMBARGO.txt.bak
 
 
ITEM Existing for Assigned Branch.txt
ITEM Existing for Assigned Branch.txt
 
 
ITEM FreeTextBlock Barcode Control NO SSMS.txt
ITEM FreeTextBlock Barcode Control NO SSMS.txt
 
 
ITEM Import Profile File and Assigned Branch.txt
ITEM Import Profile File and Assigned Branch.txt
 
 
ITEM Material Type comparison to Collection Count Branch_SSMS.txt
ITEM Material Type comparison to Collection Count Branch_SSMS.txt
 
 
ITEM Material Type comparison to Collection Count MILS.txt
ITEM Material Type comparison to Collection Count MILS.txt
 
 
ITEM Not Contributed to MaineCat.txt
ITEM Not Contributed to MaineCat.txt
 
 
ITEM QuickCirc On the Fly.txt
ITEM QuickCirc On the Fly.txt
 
 
ITEM Shelf Location Count no Description name.txt
ITEM Shelf Location Count no Description name.txt
 
 
ITEM Shelf Location Count with Description name.txt
ITEM Shelf Location Count with Description name.txt
 
 
ITEM Shelf Location Information_SSMS.txt
ITEM Shelf Location Information_SSMS.txt
 
 
ITEM Shelf Location NULL Record Status FINAL.txt
ITEM Shelf Location NULL Record Status FINAL.txt
 
 
ITEM Shelf Location Organization and Shelf Name.txt
ITEM Shelf Location Organization and Shelf Name.txt
 
 
ITEM Shelf Location _ Record Status FINAL.txt
ITEM Shelf Location _ Record Status FINAL.txt
 
 
ITEM Short barcodes.txt
ITEM Short barcodes.txt
 
 
ITEM Statistical Code NOT EQUAL TO.txt
ITEM Statistical Code NOT EQUAL TO.txt
 
 
ITEM Status and FreeTextBlock.txt
ITEM Status and FreeTextBlock.txt
 
 
ITEM Template.txt
ITEM Template.txt
 
 
ITEM_HOLD holdably by limiting to own library.txt
ITEM_HOLD holdably by limiting to own library.txt
 
 
InTransitTransferredStatus
InTransitTransferredStatus
 
 
Item Record Set Data Based on Organization Owner.txt
Item Record Set Data Based on Organization Owner.txt
 
 
Item_Branch-Location_SSMS.txt
Item_Branch-Location_SSMS.txt
 
 
Item_Branch-Location_svlHoliday.txt
Item_Branch-Location_svlHoliday.txt
 
 
MILS Distinct Patron Circ by Stat Code.txt
MILS Distinct Patron Circ by Stat Code.txt
 
 
MILS Patron Circ by Stat Code.txt
MILS Patron Circ by Stat Code.txt
 
 
MILSBounceReportFormatting.txt
MILSBounceReportFormatting.txt
 
 

Repository files navigation

PolarisSQL

Innovative Polaris ILS

This repository is a collection of SQL queries for use with the Polaris ILS. These are created, amalgamated, and maintained by Lynn Uhlman for use in the Maine InfoNet supported systems. Use at your own risk.

About

Useful Polaris SQL queries

Resources

Readme
Activity

Stars

3 stars

Watchers

1 watching

Forks

0 forks
Report repository

Releases

No releases published

Packages

No packages published