Index: openacs-4/packages/project-manager/lib/search-project.xql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/project-manager/lib/search-project.xql,v
diff -u -r1.4 -r1.5
--- openacs-4/packages/project-manager/lib/search-project.xql	20 Oct 2006 06:08:17 -0000	1.4
+++ openacs-4/packages/project-manager/lib/search-project.xql	24 Oct 2006 15:05:17 -0000	1.5
@@ -4,16 +4,15 @@
 <fullquery name="get_projects">
     <querytext>
 	select 
-		item_id,
-		o.package_id as object_package_id
+		i.item_id
 	from
-		cr_items i, acs_objects o
+		cr_items i, cr_revisions r, pm_projects p
 	where
-		lower(o.title) like '%${keyword}%'
-		and i.latest_revision = o.object_id
-		and i.content_type = 'pm_project'
+		lower(r.title) like '%${keyword}%'
+		and i.latest_revision = r.revision_id
+		and r.revision_id = p.project_id
 	order by
-		title asc
+		r.title asc
     </querytext>
 </fullquery>