Index: openacs-4/contrib/packages/project-manager/www/one-postgresql.xql =================================================================== RCS file: /usr/local/cvsroot/openacs-4/contrib/packages/project-manager/www/Attic/one-postgresql.xql,v diff -u -r1.23.2.7 -r1.23.2.8 --- openacs-4/contrib/packages/project-manager/www/one-postgresql.xql 9 Dec 2004 16:53:44 -0000 1.23.2.7 +++ openacs-4/contrib/packages/project-manager/www/one-postgresql.xql 5 Jan 2005 16:08:14 -0000 1.23.2.8 @@ -65,7 +65,8 @@ t.actual_hours_worked, s.status_type, s.description as status_description, - r.is_lead_p + r.is_lead_p, + t.priority FROM (select tr.item_id, ta.party_id, @@ -82,7 +83,8 @@ tr.estimated_hours_work_max, tr.actual_hours_worked, tr.parent_id, - tr.revision_id + tr.revision_id, + tr.priority from pm_tasks_revisionsx tr LEFT JOIN pm_task_assignment ta ON tr.item_id = ta.task_id) t