Index: openacs-4/packages/project-manager/tcl/project-procs-postgresql.xql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/project-manager/tcl/project-procs-postgresql.xql,v
diff -u -r1.14 -r1.15
--- openacs-4/packages/project-manager/tcl/project-procs-postgresql.xql 24 Oct 2006 13:18:04 -0000 1.14
+++ openacs-4/packages/project-manager/tcl/project-procs-postgresql.xql 14 Nov 2006 16:11:10 -0000 1.15
@@ -446,4 +446,35 @@
+
+
+ select
+ i.item_id
+ from
+ cr_items i, cr_revisions r, pm_projects p
+ where
+ lower(r.title) like '%${keyword}%'
+ and i.latest_revision = r.revision_id
+ and r.revision_id = p.project_id
+ order by
+ r.title asc
+
+
+
+
+
+ select
+ item_id,
+ o.package_id as object_package_id
+ from
+ cr_items i, acs_objects o, pm_projects p
+ where
+ lower(p.project_code) like '%${keyword}%'
+ and i.latest_revision = o.object_id
+ and o.object_id = p.project_id
+ order by
+ title asc
+
+
+