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.2.3 -r1.19.2.4
--- openacs-4/contrib/packages/project-manager/www/task-one-postgresql.xql	8 Oct 2004 21:25:05 -0000	1.19.2.3
+++ openacs-4/contrib/packages/project-manager/www/task-one-postgresql.xql	26 Oct 2004 01:21:11 -0000	1.19.2.4
@@ -23,20 +23,23 @@
         t.percent_complete,
         i.live_revision,
 	p.first_names || ' ' || p.last_name as creation_user,
-        proj_rev.title as project_name
+        proj_rev.title as project_name,
+        a.process_instance
 	FROM
 	pm_tasks_revisionsx t, 
         cr_items i,
         persons p,
         cr_items proj,
-        cr_revisions proj_rev
+        cr_revisions proj_rev,
+        pm_tasks_active a
 	WHERE
         t.item_id = :task_id and
         t.revision_id = :task_revision_id and
         t.item_id = i.item_id and
         t.creation_user = p.person_id and
         t.parent_id = proj.item_id and
-        proj.live_revision = proj_rev.revision_id
+        proj.live_revision = proj_rev.revision_id and
+        t.item_id = a.task_id
     </querytext>
   </fullquery>