Index: openacs-4/packages/project-manager/lib/tasks-postgresql.xql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/project-manager/lib/tasks-postgresql.xql,v
diff -u -r1.10 -r1.11
--- openacs-4/packages/project-manager/lib/tasks-postgresql.xql	22 Sep 2005 07:40:31 -0000	1.10
+++ openacs-4/packages/project-manager/lib/tasks-postgresql.xql	25 Oct 2005 23:06:00 -0000	1.11
@@ -137,8 +137,19 @@
                     and ppm.party_id = :user_id)
 	$done_clause
         [template::list::filter_where_clauses -and -name tasks]
-        [template::list::orderby_clause -name tasks -orderby]) t
+        [template::list::orderby_clause -name tasks -orderby]) t 
     </querytext>
 </fullquery>
 
+<fullquery name="get_subprojects">
+    <querytext>
+    	 select 
+		distinct item_id 
+	from 
+		pm_projectsx 
+	where 
+		parent_id = :project_item_id
+    </querytext>
+</fullquery>
+
 </queryset>