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.6 -r1.7
--- openacs-4/contrib/packages/project-manager/www/index-postgresql.xql	29 Aug 2003 00:35:35 -0000	1.6
+++ openacs-4/contrib/packages/project-manager/www/index-postgresql.xql	4 Sep 2003 22:45:23 -0000	1.7
@@ -5,24 +5,24 @@
 <fullquery name="project_folders">
     <querytext>
         SELECT
-	p.item_id,
+        p.item_id,
         p.project_id,
- 	repeat(:indent_pattern, (tree_level(p.tree_sortkey) - 5)* :indent_factor) as indent,
         p.parent_id as folder_id,
-	p.object_type as content_type,
-	p.title as project_name,
-	p.project_code,
-	to_char(p.planned_start_date, 'Mon DD ''YY') as planned_start_date,
-	to_char(p.planned_end_date, 'Mon DD ''YY') as planned_end_date,
-	p.ongoing_p,
+        p.object_type as content_type,
+        p.title as project_name,
+        p.project_code,
+        to_char(p.planned_start_date, 'Mon DD ''YY') as planned_start_date,
+        to_char(p.planned_end_date, 'Mon DD ''YY') as planned_end_date,
+        p.ongoing_p,
         p.actual_hours_completed,
         p.estimated_hours_total,
         to_char(p.estimated_finish_date, 'Mon DD ''YY') as estimated_finish_date,
         to_char(p.earliest_finish_date, 'Mon DD ''YY') as earliest_finish_date,
         to_char(p.latest_finish_date, 'Mon DD ''YY') as latest_finish_date
         FROM pm_projectsx p, cr_items i
-        WHERE p.project_id = i.live_revision
-        ORDER BY i.tree_sortkey
+        WHERE p.project_id = i.live_revision and
+        p.parent_id = :root_folder
+        ORDER BY p.title
     </querytext>
 </fullquery>