On Wed, Jan 7, 2009 at 4:53 PM, Boyer, Jason <[email protected]> wrote: > I was trying to register a new patron on the test server today and it > appears to be impossible because of some surveys that are marked > required and have no responses. Could someone remove all of the surveys > other than the few PINES examples? (Registering to vote, etc.)
Done! For reference: delete from "action".survey_question where id in (select q.id from "action".survey_question as q left join "action".survey_answer as a on a.question = q.id where a.id is null); delete from "action".survey where id in (select s.id from "action".survey as s left join "action".survey_question as q on q.survey = s.id where q.id is null); If anyone wants to rework the create survey interface (especially as remote xul instead of that chrome wizard), I'd be mighty obliged. HTML is fine too. :) -- Jason Etheridge | VP, Community Support and Advocacy | Equinox Software, Inc. / The Evergreen Experts | phone: 1-877-OPEN-ILS (673-6457) | email: [email protected] | web: http://www.esilibrary.com
