Index: openacs-4/contrib/packages/project-manager/www/tasks-postgresql.xql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/contrib/packages/project-manager/www/Attic/tasks-postgresql.xql,v
diff -u -r1.6 -r1.7
--- openacs-4/contrib/packages/project-manager/www/tasks-postgresql.xql	27 Apr 2004 00:49:29 -0000	1.6
+++ openacs-4/contrib/packages/project-manager/www/tasks-postgresql.xql	3 Jun 2004 21:32:13 -0000	1.7
@@ -12,6 +12,8 @@
         t.title,
         t.description,
         t.parent_id as project_item_id,
+        proj_rev.logger_project,
+        proj_rev.title as project_name,
         to_char(t.earliest_start,'J') as earliest_start_j,
         to_char(current_timestamp,'J') as today_j,
         to_char(t.latest_start,'J') as latest_start_j,
@@ -36,11 +38,15 @@
           LEFT JOIN pm_task_assignment ta
           ON t.item_id = ta.task_id
             LEFT JOIN persons p 
-            ON ta.party_id = p.person_id
+            ON ta.party_id = p.person_id,
+        cr_items proj,
+        pm_projectsx proj_rev
         WHERE
         ts.task_id  = t.item_id and
         i.item_id   = t.item_id and
-        t.task_revision_id = i.live_revision
+        t.task_revision_id = i.live_revision and 
+        t.parent_id = proj.item_id and
+        proj.live_revision = proj_rev.revision_id
         [template::list::filter_where_clauses -and -name tasks]
         [template::list::orderby_clause -orderby -name tasks]
     </querytext>