Index: openacs-4/contrib/packages/project-manager/www/index-postgresql.xql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/contrib/packages/project-manager/www/Attic/index-postgresql.xql,v
diff -u -r1.3 -r1.4
--- openacs-4/contrib/packages/project-manager/www/index-postgresql.xql	13 Aug 2003 18:56:29 -0000	1.3
+++ openacs-4/contrib/packages/project-manager/www/index-postgresql.xql	22 Aug 2003 21:06:10 -0000	1.4
@@ -14,7 +14,12 @@
 	p.project_code,
 	to_char(p.planned_start_date, 'YYYY MM DD') as planned_start_date,
 	to_char(p.planned_end_date, 'YYYY MM DD') as planned_end_date,
-	p.ongoing_p
+	p.ongoing_p,
+        p.estimated_completion_date - p.planned_end_date as days_late,
+        p.earliest_completion_date  - p.planned_end_date as days_late_earliest,
+        p.latest_completion_date    - p.planned_end_date as days_late_latest,
+        actual_hours_completed,
+        estimated_hours_total
         FROM pm_projectsx p, cr_items i
         WHERE p.project_id = i.live_revision
         ORDER BY i.tree_sortkey