Index: openacs-4/packages/evaluation/www/admin/evaluations/student-list.xql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/evaluation/www/admin/evaluations/student-list.xql,v
diff -u -r1.11 -r1.11.2.1
--- openacs-4/packages/evaluation/www/admin/evaluations/student-list.xql 7 Apr 2005 11:26:59 -0000 1.11
+++ openacs-4/packages/evaluation/www/admin/evaluations/student-list.xql 31 May 2005 23:13:11 -0000 1.11.2.1
@@ -112,15 +112,40 @@
et.weight as task_weight,
to_char(et.due_date, 'YYYY-MM-DD HH24:MI:SS') as due_date_ansi,
et.number_of_members,
- et.online_p
+ et.online_p,
+ et.points,
+ et.perfect_score,
+ et.forums_related_p
from evaluation_grades eg, evaluation_tasks et, cr_items cri
where et.task_id = :task_id
and et.grade_item_id = eg.grade_item_id
and cri.live_revision = eg.grade_id
+
+
+ select ev.party_id,
+ case when et.number_of_members = 1 then
+ (select last_name||', '||first_names from persons where person_id = ev.party_id)
+ else
+ (select group_name from groups where group_id = ev.party_id)
+ end as party_name
+ from evaluation_answersi ev,
+ evaluation_tasks et,
+ $roles_table
+ cr_items cri
+ where ev.task_item_id = et.task_item_id
+ and et.task_id = :task_id
+ and ev.data is not null
+ $roles_clause
+ and cri.live_revision = ev.answer_id
+ $processed_clause
+ union $sql_query
+
+
+