That's fairly straightforward. If you wanted to make sure every user was at least 18 years old you could do something like
update actor.usr set dob = now() - interval '18 years' where dob is null; On Mon, Feb 16, 2015 at 4:50 PM, Holly Brennan <[email protected]> wrote: > There is an issue with requiring DOB if you don’t already have a DOB > entered for every user. We added a dummy DOB to each user who didn’t have > one (01/01/1901) when migrating to Evergreen. That way no one was blocked > for not having a DOB, and we were still able to make the switch and require > the DOB field to be entered with new users. We now check for that dummy DOB > when updating patrons records, adding the true DOB. > > > > Equinox managed our migration, so I don’t know the details of how to go > about adding a DOB to all users who contain a blank. > > > > -Holly > > > > Holly Brennan > > Library Technology Specialist > > Homer Public Library, Alaska > > > > [email protected] > > 907-235-3180 (main) > > 907-435-3154 (direct) > > > > > > *From:* Open-ils-general [mailto: > [email protected]] *On Behalf Of *Jackson, > Robert > *Sent:* Monday, February 16, 2015 5:18 AM > *To:* Evergreen Discussion Group > *Subject:* Re: [OPEN-ILS-GENERAL] DOB field in patron accounts > > > > The local administrator should be able to use the Admin->Local > Administration->Library Setting Editor to accommodate this. Filter on DOB > and Edit the “Require dob field on patron registration” setting. > > > > ----------------------------- > Robert J. Jackson > Systems Administrator Int. > Indiana State Library > http://library.in.gov > 315 W Ohio St > Indianapolis, IN 46202 > (317) 234-7317 > [email protected] > > *From:* Open-ils-general [ > mailto:[email protected] > <[email protected]>] *On Behalf Of *Pippin, > Johnnie > *Sent:* Monday, February 16, 2015 9:04 AM > *To:* [email protected] > *Subject:* [OPEN-ILS-GENERAL] DOB field in patron accounts > > > > *Good morning,* > > > > *Our system is looking at making the DOB field within patron accounts > required in order to save their information. We feel that this helps at the > granular scale of distinguishing multiple patrons with the same name. At > patron registration, the DOB field is yellow shaded. However, once any of > the other required fields are completed, the DOB field becomes white and is > not required. I have read that having the DOB field mandatory is possible > within Evergreen. If this is true, how can it be done? If it is false, can > it be changed?* > > > > > > Thanks! > > > > -Johnnie > > > > -------------------------------------------------------------------- > > Johnnie Pippin - NC Cardinal Consultant > > State Library of North Carolina > 4640 Mail Service Center > Raleigh, NC 27699-4640 > [email protected] > > Office: 919.807.7408 / Fax: 919.733.8748 > > [image: Cardinal][image: Cardinal 2] > > ------------------------------------------------------------------- > > > > North Carolina Department of Cultural Resources > > > > Opinions expressed in this message may not represent the policy of my > agency. Email correspondence to and from this address may be subject to > the North Carolina Public Records law “NCGS.Ch. 132” and may be disclosed > to third parties by an authorized state official. > > > > > > > > > -- 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>
