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." -- C.S. Lewis <http://www.goodreads.com/author/show/1069006.C_S_Lewis>
