Index: openacs-4/packages/project-manager/www/index.xql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/project-manager/www/Attic/index.xql,v
diff -u -r1.1.2.1 -r1.1.2.2
--- openacs-4/packages/project-manager/www/index.xql	30 Nov 2005 06:47:37 -0000	1.1.2.1
+++ openacs-4/packages/project-manager/www/index.xql	2 Dec 2005 20:02:41 -0000	1.1.2.2
@@ -24,7 +24,9 @@
         to_char(p.latest_finish_date, 'MM/DD/YY') as latest_finish_date,
         case when o.name is null then '--no customer--' else o.name
                 end as customer_name,
-        o.organization_id as customer_id
+        o.organization_id as customer_id,
+        '' as indent,
+        '' as tasks
         FROM pm_projectsx p 
              LEFT JOIN pm_project_assignment pa 
                 ON p.item_id = pa.project_id
@@ -57,4 +59,13 @@
     </querytext>
 </fullquery>
 
+  <fullquery name="project_tasks">
+    <querytext>
+      SELECT title as task_title
+      FROM pm_tasks_revisionsx
+      WHERE parent_id = :project_item_id
+      ORDER BY earliest_start
+    </querytext>
+  </fullquery>
+
 </queryset>