# \#polaris-items **URL:** https://forum.innovativeusers.org/tag/polaris-items/42.md [Latest](https://forum.innovativeusers.org/latest.md) · [Categories](https://forum.innovativeusers.org/categories.md) · [Tags](https://forum.innovativeusers.org/tags.md) --- ## [Browse vs Holds Circulation](https://forum.innovativeusers.org/t/browse-vs-holds-circulation/1390)
**Author:** [@mfields](https://forum.innovativeusers.org/u/mfields)\ **Replies:** 4\ **Last updated:** [January 9, 2026, 8:49pm UTC](https://forum.innovativeusers.org/t/browse-vs-holds-circulation/1390 "2026-01-09T20:49:55Z")
Browse vs Holds Circulation Browse vs Holds Circulation.rdl (81.7 KB) Displays the number of browse and hold first time checkouts for a specified library’s branches between two dates. Results can be grouped by either c… --- ## [You Saved Amounts - Minus Renewals](https://forum.innovativeusers.org/t/you-saved-amounts-minus-renewals/1742)
**Author:** [@CyberpunkLibrarian](https://forum.innovativeusers.org/u/CyberpunkLibrarian)\ **Replies:** 2\ **Last updated:** [October 16, 2025, 2:58pm UTC](https://forum.innovativeusers.org/t/you-saved-amounts-minus-renewals/1742 "2025-10-16T14:58:22Z")
– NOTICE – NOTICE – NOTICE – Please check the comments for updates to this query, especially the one that updates the logic to account for checking out multiple items under the same bibliographic record. This query pul… --- ## [Detailed Item List with Low Item Counts in Collection Codes](https://forum.innovativeusers.org/t/detailed-item-list-with-low-item-counts-in-collection-codes/1204)
**Author:** [@system](https://forum.innovativeusers.org/u/system)\ **Replies:** 0\ **Last updated:** [June 2, 2023, 9:01pm UTC](https://forum.innovativeusers.org/t/detailed-item-list-with-low-item-counts-in-collection-codes/1204 "2023-06-02T21:01:29Z")
Detailed Item List with Low Item Counts in Collection Codes This query looks at your collection codes and checks to see if there are any collection codes with a low number of items. It’s set to operate at the level of a … --- ## [Lost item to Claims Returned - is it possible?](https://forum.innovativeusers.org/t/lost-item-to-claims-returned-is-it-possible/2087)
**Author:** [@smcclain](https://forum.innovativeusers.org/u/smcclain)\ **Replies:** 2\ **Last updated:** [November 18, 2024, 7:47pm UTC](https://forum.innovativeusers.org/t/lost-item-to-claims-returned-is-it-possible/2087 "2024-11-18T19:47:24Z")
Hello all, We migrated to Polaris on 10/14 and today is the day bills went out for the first time. We have customers who have received bills today for lost items. Customers now claim they returned the items. We want to … --- ## [Resetting Due Dates Based on Current Due Date](https://forum.innovativeusers.org/t/resetting-due-dates-based-on-current-due-date/2069)
**Author:** [@CyberpunkLibrarian](https://forum.innovativeusers.org/u/CyberpunkLibrarian)\ **Replies:** 0\ **Last updated:** [October 30, 2024, 1:33pm UTC](https://forum.innovativeusers.org/t/resetting-due-dates-based-on-current-due-date/2069 "2024-10-30T13:33:50Z")
This query will help you adjust due dates en masse, especially if a Reset Due Date operation has gone wrong. The query pulls in needed information and drops it into a temporary table that can be used to calculate the pro… --- ## [Examine Patron and Item Cross Borrowing](https://forum.innovativeusers.org/t/examine-patron-and-item-cross-borrowing/2068)
**Author:** [@CyberpunkLibrarian](https://forum.innovativeusers.org/u/CyberpunkLibrarian)\ **Replies:** 0\ **Last updated:** [October 30, 2024, 1:31pm UTC](https://forum.innovativeusers.org/t/examine-patron-and-item-cross-borrowing/2068 "2024-10-30T13:31:03Z")
This query is designed to pull counts of items circulated at given branches, specifically looking for items circulated at branches that are outside of the items’ assigned branch. Used for various state reports, this quer… --- ## [Count of Items Created by User and Collection](https://forum.innovativeusers.org/t/count-of-items-created-by-user-and-collection/2067)
**Author:** [@CyberpunkLibrarian](https://forum.innovativeusers.org/u/CyberpunkLibrarian)\ **Replies:** 0\ **Last updated:** [October 30, 2024, 1:28pm UTC](https://forum.innovativeusers.org/t/count-of-items-created-by-user-and-collection/2067 "2024-10-30T13:28:08Z")
This query produces a count, by collection, of items created by the Polaris Users on your system. It’s useful to see who’s working in which collections the most often and tracking item creation statistics. The logic also… --- ## [Find Items Denied Transit Without Branch Update](https://forum.innovativeusers.org/t/find-items-denied-transit-without-branch-update/1211)
**Author:** [@system](https://forum.innovativeusers.org/u/system)\ **Replies:** 0\ **Last updated:** [June 2, 2023, 9:01pm UTC](https://forum.innovativeusers.org/t/find-items-denied-transit-without-branch-update/1211 "2023-06-02T21:01:35Z")
Find Items Denied Transit Without Branch Update Submitted by Gabrielle Gosselin at Richland Library (Columbia, SC) - Thank you! The goal: find items where staff denied transit at CKI but didn’t update the assigned branc… --- ## [Items Replaced on Existing Bib Records](https://forum.innovativeusers.org/t/items-replaced-on-existing-bib-records/1745)
**Author:** [@CyberpunkLibrarian](https://forum.innovativeusers.org/u/CyberpunkLibrarian)\ **Replies:** 0\ **Last updated:** [March 17, 2024, 3:05pm UTC](https://forum.innovativeusers.org/t/items-replaced-on-existing-bib-records/1745 "2024-03-17T15:05:07Z")
This query looks for items added to existing bibliographic records in order to see if cataloguers are creating new bib records for newer items or if they’re adding the items to the extant bibs that are already in the sys… --- ## [Item Records in Smaller Collections](https://forum.innovativeusers.org/t/item-records-in-smaller-collections/1744)
**Author:** [@CyberpunkLibrarian](https://forum.innovativeusers.org/u/CyberpunkLibrarian)\ **Replies:** 0\ **Last updated:** [March 17, 2024, 2:44pm UTC](https://forum.innovativeusers.org/t/item-records-in-smaller-collections/1744 "2024-03-17T14:44:48Z")
This query looks for low number counts of items in your collections, the idea being that you might have items miscatalogued or mis-assigned to given collections that may not be used at a particular branch or location. It… --- ## [List of Items Checked In Through In-House Check In](https://forum.innovativeusers.org/t/list-of-items-checked-in-through-in-house-check-in/1740)
**Author:** [@CyberpunkLibrarian](https://forum.innovativeusers.org/u/CyberpunkLibrarian)\ **Replies:** 0\ **Last updated:** [March 17, 2024, 2:10pm UTC](https://forum.innovativeusers.org/t/list-of-items-checked-in-through-in-house-check-in/1740 "2024-03-17T14:10:36Z")
This query will pull a list of items that have been checked in via in-house check in between two given dates. Along with branch, title, and author information, the subjects for each item are also included in a single col… --- ## [Item Missing In-Transit/Hold Shelf-Check Reports (SSRS)](https://forum.innovativeusers.org/t/item-missing-in-transit-hold-shelf-check-reports-ssrs/1586)
**Author:** [@jtenter](https://forum.innovativeusers.org/u/jtenter)\ **Replies:** 0\ **Last updated:** [November 23, 2023, 9:20pm UTC](https://forum.innovativeusers.org/t/item-missing-in-transit-hold-shelf-check-reports-ssrs/1586 "2023-11-23T21:20:49Z")
These SSRS reports are designed to help locate items that have been too long In-Transit, Hold In-Transit, or Held, so that staff can do a self-check for any identified items. The first looks based on Assigned Branch, an… --- ## [Leap receipt printing on Epson IV printers auto-cut not working](https://forum.innovativeusers.org/t/leap-receipt-printing-on-epson-iv-printers-auto-cut-not-working/1495)
**Author:** [@JenniferHoffman](https://forum.innovativeusers.org/u/JenniferHoffman)\ **Replies:** 2\ **Last updated:** [October 13, 2023, 4:22pm UTC](https://forum.innovativeusers.org/t/leap-receipt-printing-on-epson-iv-printers-auto-cut-not-working/1495 "2023-10-13T16:22:57Z")
We are having issues with drivers for Epson IV printers and Leap receipts. We are able to autocut on Epson V printers but not on Epson IV. Has anyone got a solution they can share? --- ## [Item Processing Time](https://forum.innovativeusers.org/t/item-processing-time/1394)
**Author:** [@mfields](https://forum.innovativeusers.org/u/mfields)\ **Replies:** 0\ **Last updated:** [August 10, 2023, 9:25am UTC](https://forum.innovativeusers.org/t/item-processing-time/1394 "2023-08-10T09:25:24Z")
Item Processing Time Item Processing Time.rdl (46.1 KB) Displays the number of days between when an item is received and when it is made available. --- ## [Percent Checked Out Location Heat Map](https://forum.innovativeusers.org/t/percent-checked-out-location-heat-map/1393)
**Author:** [@mfields](https://forum.innovativeusers.org/u/mfields)\ **Replies:** 0\ **Last updated:** [August 10, 2023, 9:23am UTC](https://forum.innovativeusers.org/t/percent-checked-out-location-heat-map/1393 "2023-08-10T09:23:51Z")
Percent Checked Out Location Heat Map Percent Checked Out Location Heat Map.rdl (89.5 KB) This is a copy of a CML report (thanks Susan!) that’s been adapted for use by other libraries. Displays the collection utilizati… --- ## [Item Overdue Durations (Improved)](https://forum.innovativeusers.org/t/item-overdue-durations-improved/1290)
**Author:** [@CyberpunkLibrarian](https://forum.innovativeusers.org/u/CyberpunkLibrarian)\ **Replies:** 0\ **Last updated:** [June 16, 2023, 7:45pm UTC](https://forum.innovativeusers.org/t/item-overdue-durations-improved/1290 "2023-06-16T19:45:59Z")
This query pulls a list of items that were checked in overdue and reports each item’s overdue duration in days. You’ll likely need to adjust this to suit your own needs and, as a big warning, this query is geared to work… --- ## [Items Checked Out and Declared Lost at Branch](https://forum.innovativeusers.org/t/items-checked-out-and-declared-lost-at-branch/1289)
**Author:** [@CyberpunkLibrarian](https://forum.innovativeusers.org/u/CyberpunkLibrarian)\ **Replies:** 0\ **Last updated:** [June 16, 2023, 7:43pm UTC](https://forum.innovativeusers.org/t/items-checked-out-and-declared-lost-at-branch/1289 "2023-06-16T19:43:38Z")
I had a request to create a report of items checked out at a given branch that were later declared lost by the same branch. This query pulls in a list of items checked out and then compares them to a list of items declar… --- ## [Material Type Limits With Realistic Data](https://forum.innovativeusers.org/t/material-type-limits-with-realistic-data/1220)
**Author:** [@system](https://forum.innovativeusers.org/u/system)\ **Replies:** 0\ **Last updated:** [June 2, 2023, 9:01pm UTC](https://forum.innovativeusers.org/t/material-type-limits-with-realistic-data/1220 "2023-06-02T21:01:50Z")
Material Type Limits With Realistic Data Pull Material Type Loan Limit table and replicate the layout you see in Polaris SA. Output is limited to Patron Codes and Material Types actually used by the library. SELECT … --- ## [Low Item Counts by Collection and Material Type](https://forum.innovativeusers.org/t/low-item-counts-by-collection-and-material-type/1219)
**Author:** [@system](https://forum.innovativeusers.org/u/system)\ **Replies:** 0\ **Last updated:** [June 2, 2023, 9:01pm UTC](https://forum.innovativeusers.org/t/low-item-counts-by-collection-and-material-type/1219 "2023-06-02T21:01:49Z")
Low Item Counts by Collection and Material Type This query first pulls a table of low item counts based upon collection and material type. From that it’ll build a list of actual items that fall within the low item count … --- ## [Items Charged as Replacement With a Circulating Status](https://forum.innovativeusers.org/t/items-charged-as-replacement-with-a-circulating-status/1218)
**Author:** [@system](https://forum.innovativeusers.org/u/system)\ **Replies:** 0\ **Last updated:** [June 2, 2023, 9:01pm UTC](https://forum.innovativeusers.org/t/items-charged-as-replacement-with-a-circulating-status/1218 "2023-06-02T21:01:47Z")
Items Charged as Replacement With a Circulating Status If a patron has a lost item, and they’ve paid a portion of the replacement fee, but then they hand it in? Polaris will not automatically wave the fines and fees. The… --- ## [Get Useful Information from Item Record History](https://forum.innovativeusers.org/t/get-useful-information-from-item-record-history/1217)
**Author:** [@system](https://forum.innovativeusers.org/u/system)\ **Replies:** 0\ **Last updated:** [June 2, 2023, 9:01pm UTC](https://forum.innovativeusers.org/t/get-useful-information-from-item-record-history/1217 "2023-06-02T21:01:46Z")
Get Useful Information from Item Record History This query pulls the complete item history for a given item record ID. The data is pulled from the ItemRecordHistory table, so it may not be what you want for a full histor… --- ## [Get Item Record Set Data Based on Organization Owner](https://forum.innovativeusers.org/t/get-item-record-set-data-based-on-organization-owner/1216)
**Author:** [@system](https://forum.innovativeusers.org/u/system)\ **Replies:** 0\ **Last updated:** [June 2, 2023, 9:01pm UTC](https://forum.innovativeusers.org/t/get-item-record-set-data-based-on-organization-owner/1216 "2023-06-02T21:01:45Z")
Get Item Record Set Data Based on Organization Owner This query pulls item record information from item record sets based upon a given record set owner. So if you need to see the information in record sets owned by branc… --- ## [Find Last Patrons That Checked Out a Now Deleted Item](https://forum.innovativeusers.org/t/find-last-patrons-that-checked-out-a-now-deleted-item/1215)
**Author:** [@system](https://forum.innovativeusers.org/u/system)\ **Replies:** 0\ **Last updated:** [June 2, 2023, 9:01pm UTC](https://forum.innovativeusers.org/t/find-last-patrons-that-checked-out-a-now-deleted-item/1215 "2023-06-02T21:01:44Z")
Find Last Patrons That Checked Out a Now Deleted Item This query finds the last patrons to use an item that was deleted from the system. This is useful when you find yourself looking at an item that may remain on a patro… --- ## [Deleted Items Count Between Two Dates](https://forum.innovativeusers.org/t/deleted-items-count-between-two-dates/1214)
**Author:** [@system](https://forum.innovativeusers.org/u/system)\ **Replies:** 0\ **Last updated:** [June 2, 2023, 9:01pm UTC](https://forum.innovativeusers.org/t/deleted-items-count-between-two-dates/1214 "2023-06-02T21:01:42Z")
Deleted Items Count Between Two Dates This is just a quick query that'll get you a count of items deleted between two given dates.\`\`\`SQL SELECT o.Name AS \[Library\], COUNT(DISTINCT th.TransactionID) AS \[Total\] FRO… --- ## [Check Items in a Record Set for Display in PAC](https://forum.innovativeusers.org/t/check-items-in-a-record-set-for-display-in-pac/1213)
**Author:** [@system](https://forum.innovativeusers.org/u/system)\ **Replies:** 0\ **Last updated:** [June 2, 2023, 9:01pm UTC](https://forum.innovativeusers.org/t/check-items-in-a-record-set-for-display-in-pac/1213 "2023-06-02T21:01:38Z")
Check Items in a Record Set for Display in PAC This query checks the items in an item record set to see if they’re set to Display in PAC. Additionally it checks the item’s bib record to see if it’s set to Display in PAC.… --- ## [Create Item Record Set and List for Deleting Withdrawn Items](https://forum.innovativeusers.org/t/create-item-record-set-and-list-for-deleting-withdrawn-items/1212)
**Author:** [@system](https://forum.innovativeusers.org/u/system)\ **Replies:** 0\ **Last updated:** [June 2, 2023, 9:01pm UTC](https://forum.innovativeusers.org/t/create-item-record-set-and-list-for-deleting-withdrawn-items/1212 "2023-06-02T21:01:36Z")
Create Item Record Set and List for Deleting Withdrawn Items Typically, we delete withdrawn items after they’ve been withdrawn for a certain amount of time. Because I’m a paranoid kind of DBA, I want to keep a record of … --- ## [Complete Item Circulation History](https://forum.innovativeusers.org/t/complete-item-circulation-history/1210)
**Author:** [@system](https://forum.innovativeusers.org/u/system)\ **Replies:** 0\ **Last updated:** [June 2, 2023, 9:01pm UTC](https://forum.innovativeusers.org/t/complete-item-circulation-history/1210 "2023-06-02T21:01:34Z")
Complete Item Circulation History This query produces a complete item circulation history based on an ItemRecordID. Basically, it pulls anything from the Transactions database with a TransactionTypeID between 6001 and 69… --- ## [Get Item History Based on ItemRecordID](https://forum.innovativeusers.org/t/get-item-history-based-on-itemrecordid/1209)
**Author:** [@system](https://forum.innovativeusers.org/u/system)\ **Replies:** 0\ **Last updated:** [June 2, 2023, 9:01pm UTC](https://forum.innovativeusers.org/t/get-item-history-based-on-itemrecordid/1209 "2023-06-02T21:01:33Z")
Get Item History Based on ItemRecordID This query pulls a basic transaction history (from the Transactions database) for a given item based upon the ItemRecordID. While SimplyReports can produce a similar report, it does… --- ## [Items with Anomalous Collection Codes and Material Types](https://forum.innovativeusers.org/t/items-with-anomalous-collection-codes-and-material-types/1208)
**Author:** [@system](https://forum.innovativeusers.org/u/system)\ **Replies:** 0\ **Last updated:** [June 2, 2023, 9:01pm UTC](https://forum.innovativeusers.org/t/items-with-anomalous-collection-codes-and-material-types/1208 "2023-06-02T21:01:32Z")
Items with Anomalous Collection Codes and Material Types This query looks for collections and material types with low item counts, which could indicate that the items have the wrong material type and/or collection design… --- ## [Deleted Item Counts by Branch, Collection, and User](https://forum.innovativeusers.org/t/deleted-item-counts-by-branch-collection-and-user/1207)
**Author:** [@system](https://forum.innovativeusers.org/u/system)\ **Replies:** 0\ **Last updated:** [June 2, 2023, 9:01pm UTC](https://forum.innovativeusers.org/t/deleted-item-counts-by-branch-collection-and-user/1207 "2023-06-02T21:01:32Z")
Deleted Item Counts by Branch, Collection, and User So long as items are deleted through Polaris and not through a SQL query, this code will provide a count of items deleted by branch, collection, and user. SELECT C… [Next page](https://forum.innovativeusers.org/tag/polaris-items/42.md?match_all_tags=true&page=1&tags%5B%5D=polaris-items)