Index: openacs-4/packages/evaluation/lib/tasks-chunk-postgresql.xql =================================================================== RCS file: /usr/local/cvsroot/openacs-4/packages/evaluation/lib/Attic/tasks-chunk-postgresql.xql,v diff -u -r1.14 -r1.15 --- openacs-4/packages/evaluation/lib/tasks-chunk-postgresql.xql 31 Mar 2005 11:09:27 -0000 1.14 +++ openacs-4/packages/evaluation/lib/tasks-chunk-postgresql.xql 22 Nov 2017 11:33:32 -0000 1.15 @@ -3,34 +3,6 @@ postgresql7.3 - - - - select et.task_name, et.number_of_members, et.task_id, - to_char(et.due_date,'YYYY-MM-DD HH24:MI:SS') as due_date_ansi, - et.online_p, - et.late_submit_p, - et.task_item_id, - et.item_id, - et.requires_grade_p, et.description, et.grade_item_id, - coalesce(round(cr.content_length/1024,0),0) as content_length, - et.data as task_data, - crmt.label as pretty_mime_type, - cr.title as task_title, - et.task_id as revision_id - from cr_revisions cr, - evaluation_tasksi et, - cr_items cri, - cr_mime_types crmt - where cr.revision_id = et.revision_id - and et.grade_item_id = :grade_item_id - and cri.live_revision = et.task_id - and et.mime_type = crmt.mime_type - $assignments_orderby - - - -