Bulk waive criteria should allow user to specify maximum or minimum amount of charge to be waived
The new(ish) bulk waive options in Leap are extremely useful, but library administrators often want to waive charges of a certain amount - usually "waive all charges of less than X dollars." The current interface, however, doesn't allow the user to specify an amount for the charge to be waived. This would be very useful and would avoid the need for creating a SQL statement to identify such charges. The scenario of waiving all charges greater than a given amount is less likely, but if you're adding the ability to specify a maximum, why not add the option for a minimum, too? :-)
Bill Taylor
shared this idea
-
AdminSamantha Quell
(Admin, Innovative)
commented
Here's a sample SQL query that can be used in the existing bulk waive workform. The query below would look for any outstanding charges up to 5.00.
SELECT TxnID FROM Polaris.Polaris.PatronAccount WHERE OutstandingAmount between 0.01 and 5.00
-
Vicky Moss
commented
This would save us be so helpful for this of us that are SQL challenged. Also, it could include the balance, and not just certain items.