Index: openacs-4/contrib/packages/project-manager/www/one-postgresql.xql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/contrib/packages/project-manager/www/Attic/one-postgresql.xql,v
diff -u -r1.22 -r1.23
--- openacs-4/contrib/packages/project-manager/www/one-postgresql.xql	26 Feb 2004 15:15:41 -0000	1.22
+++ openacs-4/contrib/packages/project-manager/www/one-postgresql.xql	12 Mar 2004 13:44:45 -0000	1.23
@@ -1,29 +1,6 @@
 <?xml version="1.0"?>
 <queryset>
 
-  <fullquery name="get_item_id">
-    <querytext>
-	SELECT
-        p.item_id as project_item_id
-	FROM
-	pm_projectsx p
-	WHERE
-	p.project_id = :project_id
-    </querytext>
-  </fullquery>
-
-  <fullquery name="get_project_id">
-    <querytext>
-	SELECT
-        p.project_id
-	FROM
-	pm_projectsx p, cr_items i
-	WHERE
-	p.item_id = :project_item_id and 
-        p.revision_id = i.live_revision
-    </querytext>
-  </fullquery>
-
   <fullquery name="project_query">
     <querytext>
 	SELECT
@@ -35,6 +12,7 @@
 	p.description,
 	to_char(p.planned_start_date,'YYYY-MM-DD HH24:MI') as planned_start_date,
 	to_char(p.planned_end_date,'YYYY-MM-DD HH24:MI') as planned_end_date,
+        p.logger_project,
 	p.ongoing_p,
         i.live_revision,
         to_char(p.estimated_finish_date,'YYYY-MM-DD HH24:MI') as estimated_finish_date,
@@ -155,7 +133,8 @@
   <fullquery name="custom_query">
     <querytext>
         SELECT
-        p.customer_id
+        p.customer_id,
+        c.name as customer_name
         FROM
 	pm_projectsx p 
         LEFT JOIN organizations c ON p.customer_id = c.organization_id