Index: openacs-4/contrib/packages/project-manager/www/task-one-postgresql.xql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/contrib/packages/project-manager/www/Attic/task-one-postgresql.xql,v
diff -u -N -r1.7 -r1.8
--- openacs-4/contrib/packages/project-manager/www/task-one-postgresql.xql	8 Aug 2003 19:13:53 -0000	1.7
+++ openacs-4/contrib/packages/project-manager/www/task-one-postgresql.xql	8 Aug 2003 22:24:14 -0000	1.8
@@ -70,7 +70,7 @@
 	WHERE
         t.item_id = :task_id and
         t.item_id = i.item_id
-        $orderby_clause
+        $orderby_revisions_clause
     </querytext>
   </fullquery>
 
@@ -91,6 +91,29 @@
         c.parent_task_id = t.item_id and 
         t.revision_id    = i.live_revision and
         t.item_id        = i.item_id
+        $orderby_consts_clause
     </querytext>
   </fullquery>
+
+  <fullquery name="consts2_query">
+    <querytext>
+	SELECT
+        t.title as task_title,
+	to_char(t.start_date,'MM/DD/YYYY') as start_date,
+	to_char(t.end_date,'MM/DD/YYYY') as end_date,
+        t.percent_complete,
+        i.live_revision,
+        c.parent_task_id,
+        c.const_type,
+        c.task_id
+	FROM
+	pm_tasks_revisionsx t, cr_items i, pm_task_constraints c
+	WHERE
+        c.task_id        = t.item_id and
+        c.parent_task_id = :task_id and 
+        t.revision_id    = i.live_revision and
+        t.item_id        = i.item_id
+        $orderby_consts2_clause
+    </querytext>
+  </fullquery>
 </queryset>