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.12.2.2 -r1.12.2.3
--- openacs-4/contrib/packages/project-manager/www/index-postgresql.xql	14 Feb 2005 15:23:37 -0000	1.12.2.2
+++ openacs-4/contrib/packages/project-manager/www/index-postgresql.xql	4 May 2005 06:13:53 -0000	1.12.2.3
@@ -53,6 +53,10 @@
         s.status_id           = p.status_id
 	and i.parent_id = f.folder_id
         and f.package_id = :package_id 
+        and exists (select 1 from acs_object_party_privilege_map ppm 
+                    where ppm.object_id = p.project_id
+                    and ppm.privilege = 'read'
+                    and ppm.party_id = :user_id)
         [template::list::filter_where_clauses -and -name projects]
         [template::list::orderby_clause -orderby -name projects]
     </querytext>