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 -N -r1.8 -r1.8.2.1
--- openacs-4/contrib/packages/project-manager/www/index-postgresql.xql	18 Sep 2003 01:09:14 -0000	1.8
+++ openacs-4/contrib/packages/project-manager/www/index-postgresql.xql	4 Dec 2003 21:00:13 -0000	1.8.2.1
@@ -19,10 +19,12 @@
         to_char(p.estimated_finish_date, 'MM/DD/YY') as estimated_finish_date,
         to_char(p.earliest_finish_date, 'MM/DD/YY') as earliest_finish_date,
         to_char(p.latest_finish_date, 'MM/DD/YY') as latest_finish_date
-        FROM pm_projectsx p, cr_items i
+        FROM pm_projectsx p, cr_items i, pm_project_status s
         WHERE p.project_id = i.live_revision and
-        p.parent_id = :root_folder
-        ORDER BY p.title
+        p.parent_id = :root_folder and
+        s.status_id = p.status_id
+        [template::list::filter_where_clauses -and -name projects]
+        [template::list::orderby_clause -orderby -name projects]
     </querytext>
 </fullquery>