Index: openacs-4/packages/evaluation/www/admin/evaluations/student-list-postgresql.xql =================================================================== RCS file: /usr/local/cvsroot/openacs-4/packages/evaluation/www/admin/evaluations/student-list-postgresql.xql,v diff -u -N -r1.11.2.4 -r1.11.2.5 --- openacs-4/packages/evaluation/www/admin/evaluations/student-list-postgresql.xql 4 Oct 2005 16:11:21 -0000 1.11.2.4 +++ openacs-4/packages/evaluation/www/admin/evaluations/student-list-postgresql.xql 4 Oct 2005 17:17:16 -0000 1.11.2.5 @@ -131,8 +131,8 @@ - select g.group_name as party_name, - g.group_id as party_id + select g.group_id as party_id, + g.group_name as party_name from groups g, evaluation_task_groups etg, evaluation_tasks et, acs_rels map where g.group_id = etg.group_id @@ -154,12 +154,12 @@ - select + 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,ev.party_id + end as party_name from evaluation_answersi ev, evaluation_tasks et, $roles_table