Index: openacs-4/packages/project-manager/lib/tasks-postgresql.xql =================================================================== RCS file: /usr/local/cvsroot/openacs-4/packages/project-manager/lib/tasks-postgresql.xql,v diff -u -r1.7 -r1.8 --- openacs-4/packages/project-manager/lib/tasks-postgresql.xql 23 Aug 2005 16:37:50 -0000 1.7 +++ openacs-4/packages/project-manager/lib/tasks-postgresql.xql 14 Sep 2005 22:15:28 -0000 1.8 @@ -25,6 +25,7 @@ u.person_id, u.first_names, u.last_name, + $extra_column t.percent_complete, d.parent_task_id, d.dependency_type, @@ -66,6 +67,9 @@ persons u ON t.party_id = u.person_id + + $extra_join + LEFT JOIN pm_roles r ON t.role_id = r.role_id, @@ -130,6 +134,9 @@ persons u ON t.party_id = u.person_id + + $extra_join + LEFT JOIN pm_roles r ON t.role_id = r.role_id,