loa_long_odue script
Submitted by Darren Ragsdell on Thu, 2010-01-07 13:15.
Has anyone noticed that borrowers who have had previous long overdue items do not get the (selected) borrower message automatically added to their borrower record, when they have further items that reach 'long overdue' status?
Can't see anything obvious in the script that might result in borrowers with previously long overdue items being excluded from getting a 'new' long overdue borrower message, but hoping someone can explain it?
Thanks...
loa_long_odue script
Even when a message is removed from a borrower (or an item) the row is not removed from the PLACED_MESSAGE table. The EXPIRY_DATE of the row is changed to the current date time and therefore it is not displayed in Alto.
The script takes account of this and if there is an expired row for the borrower and message combination then the existing row is updated with the ACTIVE_DATE and EDIT_DATE being updated to the current date time and the EXPIRY_DATE being updated to to "Dec 31 2030".
There is no reason in the code why a borrower should not have a message seen against them even if they have had a message seen previously. Obviously you will never will never see the same message twice for a borrower.
If you have specific examples then you could raise a case as it is a standard Talis script for further investigation.
Thanks
Brian Crampton
Developer, Talis