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.5 -r1.5.2.1
--- openacs-4/contrib/packages/project-manager/www/tasks-postgresql.xql	12 Mar 2004 13:44:45 -0000	1.5
+++ openacs-4/contrib/packages/project-manager/www/tasks-postgresql.xql	20 May 2004 17:30:05 -0000	1.5.2.1
@@ -6,10 +6,12 @@
     <querytext>
         SELECT
         ts.task_id,
+        ts.task_id as item_id,
         ts.task_number,
         t.task_revision_id,
         t.title,
         t.description,
+        t.parent_id as project_item_id,
         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,
@@ -29,13 +31,16 @@
         (select one_line from pm_roles r where ta.role_id = r.role_id) as role
         FROM
         pm_tasks ts, 
+        cr_items i,
         pm_tasks_revisionsx t 
           LEFT JOIN pm_task_assignment ta
           ON t.item_id = ta.task_id
             LEFT JOIN persons p 
             ON ta.party_id = p.person_id
         WHERE
-        ts.task_id  = t.item_id 
+        ts.task_id  = t.item_id and
+        i.item_id   = t.item_id and
+        t.task_revision_id = i.live_revision
         [template::list::filter_where_clauses -and -name tasks]
         [template::list::orderby_clause -orderby -name tasks]
     </querytext>