Index: openacs-4/packages/project-manager-portlet/lib/projects-postgresql.xql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/project-manager-portlet/lib/projects-postgresql.xql,v
diff -u -r1.2 -r1.3
--- openacs-4/packages/project-manager-portlet/lib/projects-postgresql.xql	15 Aug 2005 09:21:01 -0000	1.2
+++ openacs-4/packages/project-manager-portlet/lib/projects-postgresql.xql	24 Aug 2005 15:04:05 -0000	1.3
@@ -12,40 +12,10 @@
         p.object_type as content_type,
         p.title as project_name,
         p.project_code,
-        to_char(p.planned_start_date, 'YYYY-MM-DD HH24:MI:SS') as planned_start_date,
         to_char(p.planned_end_date, 'YYYY-MM-DD HH24:MI:SS') as planned_end_date,
         p.ongoing_p,
-        c.category_id,
-        c.category_name,
-        p.earliest_finish_date - current_date as days_to_earliest_finish,
-        p.latest_finish_date - current_date as days_to_latest_finish,
-        p.actual_hours_completed,
-        p.estimated_hours_total,
-        to_char(p.estimated_finish_date, 'YYYY-MM-DD HH24:MI:SS') as estimated_finish_date,
-        to_char(p.earliest_finish_date, 'YYYY-MM-DD HH24:MI:SS') as earliest_finish_date,
-        to_char(p.latest_finish_date, 'YYYY-MM-DD HH24:MI:SS') 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, f.package_id
-        FROM pm_projectsx p 
-             LEFT JOIN pm_project_assignment pa 
-                ON p.item_id = pa.project_id
-             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, 
+        p.customer_id as customer_id, f.package_id
+        FROM pm_projectsx p, 
         cr_items i, 
 	cr_folders f
         WHERE