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 -N -r1.19 -r1.19.2.1
--- openacs-4/contrib/packages/project-manager/www/one-postgresql.xql	3 Oct 2003 23:52:17 -0000	1.19
+++ openacs-4/contrib/packages/project-manager/www/one-postgresql.xql	4 Dec 2003 21:00:13 -0000	1.19.2.1
@@ -33,13 +33,13 @@
 	p.project_code,
 	p.goal,
 	p.description,
-	to_char(p.planned_start_date,'Mon DD') as planned_start_date,
-	to_char(p.planned_end_date,'Mon DD') as planned_end_date,
+	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.ongoing_p,
         i.live_revision,
-        to_char(p.estimated_finish_date,'Mon DD') as estimated_finish_date,
-        to_char(p.earliest_finish_date,'Mon DD') as earliest_finish_date,
-        to_char(p.latest_finish_date,'Mon DD') as latest_finish_date,
+        to_char(p.estimated_finish_date,'YYYY-MM-DD HH24:MI') as estimated_finish_date,
+        to_char(p.earliest_finish_date,'YYYY-MM-DD HH24:MI') as earliest_finish_date,
+        to_char(p.latest_finish_date,'YYYY-MM-DD HH24:MI') as latest_finish_date,
         p.actual_hours_completed,
         p.estimated_hours_total,
         p.parent_id
@@ -84,12 +84,12 @@
 	SELECT
         t.item_id as task_id,
         t.title,
-	to_char(t.end_date,'Mon DD') as end_date,
-	to_char(t.earliest_start,'Mon DD') as earliest_start,
-	to_char(t.earliest_finish,'Mon DD') as earliest_finish,
-	to_char(t.latest_start,'Mon DD') as latest_start,
-	to_char(t.latest_finish,'Mon DD') as latest_finish,
-        to_char(t.latest_start-t.earliest_start,'FMDD') || ' days' as slack_time,
+	to_char(t.end_date,'YYYY-MM-DD HH24:MI') as end_date,
+	to_char(t.earliest_start,'YYYY-MM-DD HH24:MI') as earliest_start,
+	to_char(t.earliest_finish,'YYYY-MM-DD HH24:MI') as earliest_finish,
+	to_char(t.latest_start,'YYYY-MM-DD HH24:MI') as latest_start,
+	to_char(t.latest_finish,'YYYY-MM-DD HH24:MI') as latest_finish,
+        to_char(t.latest_start-t.earliest_start,'DD') || ' days' as slack_time,
         u.first_names,
         u.last_name,
         t.percent_complete,
@@ -100,11 +100,11 @@
         t.estimated_hours_work_max,
         t.actual_hours_worked
 	FROM
-	pm_tasks_revisionsx t LEFT JOIN pm_task_assignment a ON t.item_id = a.task_id, cr_items i LEFT JOIN pm_task_dependency d ON i.item_id = d.task_id, cc_users u
+	(select * from pm_tasks_revisionsx LEFT JOIN pm_task_assignment ON item_id = task_id) t, cr_items i LEFT JOIN pm_task_dependency d ON i.item_id = d.task_id, all_users u
 	WHERE
         t.parent_id = :project_item_id and
         t.revision_id = i.live_revision and
-        a.party_id = u.party_id
+        t.party_id = u.party_id
         [template::list::orderby_clause -name tasks -orderby]
     </querytext>
   </fullquery>