Index: openacs-4/contrib/packages/project-manager/www/tasks-postgresql.xql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/contrib/packages/project-manager/www/Attic/tasks-postgresql.xql,v
diff -u -r1.5.2.9 -r1.5.2.10
--- openacs-4/contrib/packages/project-manager/www/tasks-postgresql.xql	12 Apr 2005 08:12:24 -0000	1.5.2.9
+++ openacs-4/contrib/packages/project-manager/www/tasks-postgresql.xql	25 Apr 2005 12:44:53 -0000	1.5.2.10
@@ -62,8 +62,9 @@
 
 <fullquery name="tasks_pagination">
     <querytext>
+     select distinct task_id from (
         SELECT
-	distinct ts.task_id
+	ts.task_id
         FROM
         pm_tasks_active ts, 
         cr_items i,
@@ -86,6 +87,7 @@
 	and proj.parent_id = f.folder_id
         and f.package_id = :package_id 
         [template::list::filter_where_clauses -and -name tasks]
+        [template::list::orderby_clause -orderby -name tasks]) as tasks
     </querytext>
 </fullquery>