Index: openacs-4/packages/evaluation/tcl/evaluation-procs-oracle.xql =================================================================== RCS file: /usr/local/cvsroot/openacs-4/packages/evaluation/tcl/evaluation-procs-oracle.xql,v diff -u -r1.4 -r1.4.14.1 --- openacs-4/packages/evaluation/tcl/evaluation-procs-oracle.xql 7 Apr 2005 18:57:01 -0000 1.4 +++ openacs-4/packages/evaluation/tcl/evaluation-procs-oracle.xql 21 Jul 2017 16:27:57 -0000 1.4.14.1 @@ -43,7 +43,7 @@ select cu.person_id as party_id, cu.last_name||' - '||cu.first_names as party_name, round(ese.grade,2) as grade, ese.description as comments - from cc_users cu left outer join evaluation_student_evalsi ese on (ese.party_id = cu.person_id + from cc_users cu left join evaluation_student_evalsi ese on (ese.party_id = cu.person_id and ese.task_item_id = :task_item_id and content_revision.is_live(ese.evaluation_id) = 't') @@ -56,7 +56,7 @@ ese.description as comments from registered_users ru, dotlrn_member_rels_approved app, - persons p left outer join evaluation_student_evalsi ese on (ese.party_id = p.person_id + persons p left join evaluation_student_evalsi ese on (ese.party_id = p.person_id and ese.task_item_id = :task_item_id and content_revision.is_live(ese.evaluation_id) = 't') where app.community_id = :community_id @@ -73,7 +73,7 @@ grade, ese.description as comments from groups g, - evaluation_task_groups etg left outer join evaluation_student_evalsi ese on (ese.party_id = etg.group_id + evaluation_task_groups etg left join evaluation_student_evalsi ese on (ese.party_id = etg.group_id and ese.task_item_id = :task_item_id and content_revision.is_live(ese.evaluation_id) = 't') where etg.task_item_id = :task_item_id Index: openacs-4/packages/evaluation/www/view/task-view-oracle.xql =================================================================== RCS file: /usr/local/cvsroot/openacs-4/packages/evaluation/www/view/task-view-oracle.xql,v diff -u -r1.2 -r1.2.10.1 --- openacs-4/packages/evaluation/www/view/task-view-oracle.xql 8 Aug 2006 21:26:43 -0000 1.2 +++ openacs-4/packages/evaluation/www/view/task-view-oracle.xql 21 Jul 2017 16:27:57 -0000 1.2.10.1 @@ -18,7 +18,7 @@ eg.grade_plural_name, eg.weight as grade_weight, ets.revision_id as solution_revision_id from evaluation_grades eg, - evaluation_tasksi et left outer join evaluation_tasks_solsi ets on (ets.task_item_id = et.task_item_id and content_revision.is_live(ets.solution_id) = 't') + evaluation_tasksi et left join evaluation_tasks_solsi ets on (ets.task_item_id = et.task_item_id and content_revision.is_live(ets.solution_id) = 't') where et.task_id = :task_id and et.grade_item_id = eg.grade_item_id and content_revision.is_live(eg.grade_id) = 't'