Index: openacs-4/packages/survey/sql/oracle/survey-package-create.sql =================================================================== RCS file: /usr/local/cvsroot/openacs-4/packages/survey/sql/oracle/survey-package-create.sql,v diff -u -N -r1.5 -r1.5.2.1 --- openacs-4/packages/survey/sql/oracle/survey-package-create.sql 11 Dec 2003 21:40:14 -0000 1.5 +++ openacs-4/packages/survey/sql/oracle/survey-package-create.sql 24 Aug 2004 21:42:32 -0000 1.5.2.1 @@ -468,9 +468,11 @@ -- this view contains only the most recently edited version -- of each survey response. + create or replace view survey_responses_latest as -select sr.*, o.creation_date, - o.creation_user as initial_user_id +select sr.*, o.creation_date, + o.creation_user, + survey_response.initial_user_id(sr.response_id) as initial_user_id from survey_responses sr, acs_objects o, (select max(response_id) as response_id