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.20 -r1.21
--- openacs-4/contrib/packages/project-manager/www/one-postgresql.xql	11 Dec 2003 21:39:44 -0000	1.20
+++ openacs-4/contrib/packages/project-manager/www/one-postgresql.xql	26 Jan 2004 15:39:40 -0000	1.21
@@ -86,10 +86,12 @@
         t.title,
 	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_start,'J') as earliest_start_j,
 	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_start,'J') as latest_start_j,
+	to_char(current_date,'J') as today_j,
 	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 +102,10 @@
         t.estimated_hours_work_max,
         t.actual_hours_worked
 	FROM
-	(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
+	(select * from pm_tasks_revisionsx LEFT JOIN pm_task_assignment ON item_id = task_id) t LEFT JOIN all_users u ON t.party_id = u.party_id, cr_items i LEFT JOIN pm_task_dependency d ON i.item_id = d.task_id
 	WHERE
         t.parent_id = :project_item_id and
-        t.revision_id = i.live_revision and
-        t.party_id = u.party_id
+        t.revision_id = i.live_revision 
         [template::list::orderby_clause -name tasks -orderby]
     </querytext>
   </fullquery>
@@ -147,4 +148,9 @@
     </querytext>
   </fullquery>
 
+  <fullquery name="custom_query">
+    <querytext>
+    </querytext>
+  </fullquery>
+
 </queryset>