Index: openacs-4/contrib/packages/project-manager/www/task-one-postgresql.xql =================================================================== RCS file: /usr/local/cvsroot/openacs-4/contrib/packages/project-manager/www/Attic/task-one-postgresql.xql,v diff -u -r1.19 -r1.20 --- openacs-4/contrib/packages/project-manager/www/task-one-postgresql.xql 12 Mar 2004 13:44:45 -0000 1.19 +++ openacs-4/contrib/packages/project-manager/www/task-one-postgresql.xql 27 Apr 2004 00:49:29 -0000 1.20 @@ -18,6 +18,7 @@ t.item_id, t.title as task_title, t.description, + t.mime_type, to_char(t.end_date,'Mon DD ''YY') as end_date, to_char(t.earliest_start,'Mon DD ''YY') as earliest_start, to_char(t.earliest_start,'J') as earliest_start_j, @@ -51,7 +52,9 @@ t.revision_id, i.live_revision, t.title as task_title, - t.description || ' -- ' || p.first_names || ' ' || p.last_name as description, + t.description || ' -- ' || p.first_names || ' ' || p.last_name + as description, + t.mime_type, to_char(t.end_date,'MM/DD/YYYY') as end_date, t.percent_complete, t.estimated_hours_work_min, @@ -145,7 +148,7 @@ pm_task_xref x, pm_tasks_revisionsx r, cr_items i WHERE x.task_id_2 = :task_id and - x.task_id_2 = r.item_id and + x.task_id_1 = r.item_id and r.revision_id = i.live_revision UNION SELECT @@ -166,7 +169,7 @@ pm_task_xref x2, pm_tasks_revisionsx r2, cr_items i2 WHERE x2.task_id_1 = :task_id and - x2.task_id_1 = r2.item_id and + x2.task_id_2 = r2.item_id and i2.live_revision = r2.revision_id