It leads to the questions: what is your library's policy and what is the reason for marking patrons inactive? I would tend to think the main reason would be for accurate statistics -- so your patron count wouldn't be inflated with accounts that have expired years ago.
Thanks. George Tuttle Computer Services Librarian Piedmont Regional Library System 770-867-2762 x113 770-891-0654 (cell) 770-867-7483 (fax) [email protected] LOGOFEB2013 From: [email protected] [mailto:[email protected]] On Behalf Of Rogan Hamby Sent: Thursday, May 09, 2013 11:11 AM To: Evergreen Discussion Group Subject: Re: [OPEN-ILS-GENERAL] Converting large numbers of patron records to inactive I think Jason's is a bit more elegant but if you have a specific need for that kind of criteria that can be done a slightly more involved SQL statement to run periodically too (daily). On Thu, May 9, 2013 at 10:59 AM, Jason Etheridge <[email protected]> wrote: > Would it be possible to have a set of criteria like: <snip> If not not using expire dates set far in the future, it may be simpler to just base it off of expire date. If the account has been expired for over X amount of time, then flag the account inactive. What do you think? We could do that with a one-line SQL command made to run periodically. -- Jason Etheridge | Support Manager | Equinox Software, Inc. / The Open Source Experts | phone: 1-877-OPEN-ILS (673-6457) | email: [email protected] | web: http://www.esilibrary.com -- Rogan Hamby, MLS, CCNP, MIA Managers Headquarters Library and Reference Services, York County Library System "You can never get a cup of tea large enough or a book long enough to suit me." ― <http://www.goodreads.com/author/show/1069006.C_S_Lewis> C.S. Lewis
<<image003.png>>
