Index: openacs-4/contrib/packages/project-manager/www/index-postgresql.xql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/contrib/packages/project-manager/www/Attic/index-postgresql.xql,v
diff -u -r1.9 -r1.10
--- openacs-4/contrib/packages/project-manager/www/index-postgresql.xql	11 Dec 2003 21:39:44 -0000	1.9
+++ openacs-4/contrib/packages/project-manager/www/index-postgresql.xql	26 Jan 2004 15:39:40 -0000	1.10
@@ -20,10 +20,12 @@
         p.estimated_hours_total,
         to_char(p.estimated_finish_date, 'MM/DD/YY') as estimated_finish_date,
         to_char(p.earliest_finish_date, 'MM/DD/YY') as earliest_finish_date,
-        to_char(p.latest_finish_date, 'MM/DD/YY') as latest_finish_date
-        FROM pm_projectsx p LEFT JOIN (select om.category_id, om.object_id, t.name as category_name from category_object_map om, category_translations t where om.category_id = t.category_id) c ON p.item_id = c.object_id, cr_items i, pm_project_status s
+        to_char(p.latest_finish_date, 'MM/DD/YY') as latest_finish_date,
+        o.name as customer_name
+        FROM pm_projectsx p LEFT JOIN organizations o ON p.customer_id = o.organization_id LEFT JOIN (select om.category_id, om.object_id, t.name as category_name from category_object_map om, category_translations t, categories ctg where om.category_id = t.category_id and ctg.category_id = t.category_id and ctg.deprecated_p = 'f') c ON p.item_id = c.object_id, 
+        cr_items i, 
+        pm_project_status s
         WHERE p.project_id = i.live_revision and
-        p.parent_id = :root_folder and
         s.status_id = p.status_id
         [template::list::filter_where_clauses -and -name projects]
         [template::list::orderby_clause -orderby -name projects]