Index: openacs-4/packages/evaluation-portlet/lib/evaluations-chunk-postgresql.xql =================================================================== RCS file: /usr/local/cvsroot/openacs-4/packages/evaluation-portlet/lib/evaluations-chunk-postgresql.xql,v diff -u -r1.5 -r1.6 --- openacs-4/packages/evaluation-portlet/lib/evaluations-chunk-postgresql.xql 11 Sep 2004 00:41:09 -0000 1.5 +++ openacs-4/packages/evaluation-portlet/lib/evaluations-chunk-postgresql.xql 4 Apr 2005 18:23:47 -0000 1.6 @@ -3,44 +3,8 @@ postgresql7.3 - - - - select et.task_name, - round(et.weight,2) as task_weight, - et.task_id - from evaluation_tasksi et, cr_items cri - where grade_item_id = :grade_item_id - and cri.live_revision = et.task_id - $evaluations_orderby - - - - - - - - select et.task_name, - et.task_item_id, - et.weight as t_weight, - eg.weight as g_weight, - round((et.weight*eg.weight)/100,2) as task_weight, - et.number_of_members, - et.task_id - from evaluation_grades eg, - evaluation_tasksi et, - cr_items cri - where eg.grade_id = :grade_id - and eg.grade_item_id = et.grade_item_id - and cri.live_revision = et.task_id - $evaluations_orderby - - - - - select coalesce((select etg2.group_id from evaluation_task_groups etg2, evaluation_tasks et2, acs_rels map @@ -52,13 +16,11 @@ where et3.task_id = :task_id -- select evaluation__party_id(:user_id,:task_id) - - select round(ese.grade,2) as grade, ese.evaluation_id, ese.description as comments, @@ -84,13 +46,11 @@ where et3.task_id = :task_id ) -- evaluation__party_id(:user_id,:task_id) - - select ea.data as answer_data, ea.title as answer_title, ea.answer_id @@ -113,9 +73,7 @@ from evaluation_tasks et3 where et3.task_id = :task_id ) - -- evaluation__party_id(:user_id,:task_id) -