Index: openacs-4/packages/assessment/www/admin/results-users.xql =================================================================== RCS file: /usr/local/cvsroot/openacs-4/packages/assessment/www/admin/Attic/results-users.xql,v diff -u -N --- openacs-4/packages/assessment/www/admin/results-users.xql 24 Jan 2005 14:54:31 -0000 1.1 +++ /dev/null 1 Jan 1970 00:00:00 -0000 @@ -1,23 +0,0 @@ - - - - - - select s.session_id, s.subject_id, s.percent_score, - to_char(s.completed_datetime, :format) as completed_datetime, - p.first_names || ' ' || p.last_name AS subject_name, - :assessment_id as assessment_id - from as_sessions s, persons p, - (select max(s2.session_id) as session_id, s2.subject_id - from as_sessions s2, cr_revisions r - where r.item_id = :assessment_id - and s2.assessment_id = r.revision_id - and s2.completed_datetime is not null - group by s2.subject_id) sub - where s.session_id = sub.session_id - and sub.subject_id = p.person_id - order by s.completed_datetime - - - -