Find Patrons who won't get Overdue and Bill Notices

Clearinghouse Repository Polaris Repository
1

If patrons are excluded from Overdue, Bill notices or have their notification preference set to NONE, then any items they have CKO’d won’t go to lost.

You can use the follow SQL in the Patron Find Tool to locate patrons who match any of these criteria.

SELECT pr.PatronID 
FROM polaris.polaris.PatronRegistration pr
WHERE 
pr.DeliveryOptionID IS NULL OR 
pr.ExcludeFromOverdues = 1 OR 
pr.ExcludeFromBills = 1
3 Likes
2

Thank you for this! I had clunkier versions for each issue - but having it in one makes it so much faster.

1 Like