Thanks, Justin! Your messages were filtered to my junk – sorry for the late reply!
I can look at the whole database, but only change things I’m familiar with (and this is not one). -Holly From: Open-ils-general [mailto:open-ils-general-boun...@list.georgialibraries.org] On Behalf Of Justin Hopkins ?? Sent: Wednesday, June 10, 2015 12:11 PM To: Evergreen Discussion Group Subject: Re: [OPEN-ILS-GENERAL] alert for once juvenile becomes adult I should clarify that my previous suggestion was based on my recollection that you have access to the database and could set this up. Justin On 6/10/15 3:09 PM, Justin Hopkins 📖 wrote: Holly, I think the simplest solution would be to run a script on a nightly cron that updated the database as necessary. Flip the Juvenile flag, change their profile, possibly remove the grouping/ident2_value, and add an alert. I thought we might be running something like that ourselves, but either I'm not finding it, or it's just something we'd also talked about doing but never did. Justin On 6/10/15 3:00 PM, Holly Brennan wrote: We’d like to be alerted when a patron who was marked as juvenile (the checkbox based on their birth date) is now over 18. The goal would be to catch those now-adults and change their library card type from Juvenile to Adult, so they are now responsible for their library card rather than their parent. We would also enter their ID information, and remove the parent’s ID (typically their driver’s license). The staff notification could be just a alert message. We’d like to avoid having to look at an expired account and calculate whether that patron is now an adult, so please no solutions involving math. ☺ We’ve run a report for patrons who have Juvenile accounts but are 18+, and there are hundreds. I’m guessing we’re on our own fixing these ones, but maybe there is a miracle out there for adding the alert to these accounts too? Thanks! Holly Brennan Library Technology Specialist Homer Public Library, Alaska hbren...@cityofhomer-ak.gov<mailto:hbren...@cityofhomer-ak.gov> 907-235-3180 (main) 907-435-3154 (direct)