Index: openacs-4/packages/project-manager/lib/projects-postgresql.xql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/project-manager/lib/projects-postgresql.xql,v
diff -u -r1.5 -r1.6
--- openacs-4/packages/project-manager/lib/projects-postgresql.xql	23 Aug 2005 16:37:50 -0000	1.5
+++ openacs-4/packages/project-manager/lib/projects-postgresql.xql	26 Aug 2005 17:10:28 -0000	1.6
@@ -26,7 +26,10 @@
         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
+        o.organization_id as customer_id,
+	f.package_id,
+	to_char(p.creation_date, 'YYYY-MM_DD HH24:MI:SS') as creation_date,
+	to_char(p.planned_start_date, 'YYYY-MM_DD HH24:MI:SS') as start_date
         FROM pm_projectsx p 
              LEFT JOIN pm_project_assignment pa 
                 ON p.item_id = pa.project_id
@@ -52,12 +55,13 @@
         WHERE 
         p.project_id = i.live_revision 
 	and i.parent_id = f.folder_id
+	and f.package_id in ($package_ids)
         and exists (select 1 from acs_object_party_privilege_map ppm 
                     where ppm.object_id = p.project_id
                     and ppm.privilege = 'read'
                     and ppm.party_id = :user_id)
-        [template::list::filter_where_clauses -and -name "projects_${package_id}"]
-        [template::list::orderby_clause -orderby -name "projects_${package_id}"]
+        [template::list::filter_where_clauses -and -name projects]
+        [template::list::orderby_clause -orderby -name projects]
     </querytext>
 </fullquery>